Complete Microsoft SQL Server Database Design Masterclass

Database Design | SQL Server | T-SQL | Database Tables | Foreign Keys | SQL CRUD | Views | Triggers | Stored Procedures
Complete Microsoft SQL Server Database Design Masterclass
File Size :
3.12 GB
Total length :
8h 20m



Trevoir Williams


Last update




Complete Microsoft SQL Server Database Design Masterclass

What you’ll learn

Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
Using Microsoft SQL Management Studio
SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
DELETE: How to remove data from a database
INSERT INTO: How to insert data into a table
UPDATE: How to update existing data
Filter groups of data using the HAVING clause
Overall Database Development Best Practices
Creating Relationships and Foreign Keys
How to query related data from multiple tables
Using Aggregate Functions in SQL
How to export Query Results to Excel
How to craft SQL statements based on real scenarios
Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers)
Backup and Restore Databases
Generate Database Scripts for Automation
How to manage database users and security

Complete Microsoft SQL Server Database Design Masterclass


A Computer
A desire to learn database development


OverviewMicrosoft SQL Server is a powerful and widely-used database management system used by organizations of all sizes to store and retrieve data. This course teaches you how to use Microsoft SQL Server to design, implement, and maintain a database. You will learn key concepts such as database design, query writing, and stored procedure creation. You will have the opportunity to practice your skills through hands-on exercises and projects.This is a zero-to-hero course on Microsoft SQL Database development and querying techniques. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Database Administrator. There are no prerequisites for this course. By the end of this course, you will have a strong understanding of how to use Microsoft SQL Server to manage and manipulate data and will be able to use it effectively in your projects. Whether you are new to database management or have some experience, this course is designed to provide a comprehensive overview of Microsoft SQL Server and help you become proficient in its use.What you’ll learnHow to Install SQL Server and SQL Server Management Studio (Windows or Docker for Mac and Linux)How to Connect to a Database Instance and create Databases and TablesHow to Use SQL Management Studio (SSMS)How to use Azure Data StudioHow to Author queries to Create, Read, Update and Delete data in tables. How to develop entity relationship diagrams using visual design toolsHow to normalize a database and create relationships and foreign keys How to Use Aggregate Functions to do quick mathematical operationsHow to export data to Excel using the Management StudioHow to create and manage Database ViewsHow to create and manage Functions, Table Triggers, and Stored ProceduresHow to Backup and Restore DatabasesHow to manage users and database securityWhy Learn Microsoft SQL ServerMicrosoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.We will explore best practices in database development using SQL Server and will be building a small school management system database. All you need is a capable machine, and we will walk through setting up an environment, creating a database, creating your first table, and writing queries. At the end of this course, you should be comfortable writing queries for multiple situations and reports. Are there any course requirements or prerequisites?A Windows PC (or Docker if using Linux/Mac) Who this course is for:This course is for beginners with absolutely no experience.This course is for you if you are already comfortable with fundamental database operations. This course is for you if you feel a bit ‘rusty’ and need to refresh your knowledge.This course is for you if you want to understand design principles in database development.This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System.This course is for EVERYONE!Content and OverviewThis is a complete course. I take you through various scenarios and techniques to write queries, build a database and further administrate, then we touch on more advanced topics that are in great demand in the workplace. Over 6 hours of premium content, all put together to ensure that; then get up and running with becoming e Developer and Administrator. By the time you finish the course, you will have moved around in Microsoft SQL Manager Studio so much that it will become second nature for you when interacting with your databases on different servers. This will put your newly learned skills into practical use and impress your boss and coworkers.The course has working files and scripts, making it easy to replicate the demonstrated code. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.Clicking the Take This Course button could be the best step to increase your income and marketability quickly! Also, remember that if you think the course is not worth what you spent, you have a full 30 days to get a no questions asked refund!It’s time to take action!See you in the course!


Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Understanding Types of Data and Storage

Section 2: Environment Setup

Lecture 3 Download and Install SQL Server Express (Windows)

Lecture 4 Install SQL Server on Mac and Linux

Section 3: Understanding The Toolset

Lecture 5 Explore SQL Server Management Studio

Lecture 6 Explore Azure Data Studio

Lecture 7 Explore

Section 4: Creating And Manipulating Databases

Lecture 8 Section Overview

Lecture 9 Create Database using Management Studio

Lecture 10 Create a Database using SQL Script

Lecture 11 How to Remove a Database

Lecture 12 How To Change Database Name

Lecture 13 Section Review

Section 5: Managing Tables and Data

Lecture 14 What is a Database Table?

Lecture 15 Create Entity Data Model

Lecture 16 Create a Database Table using Management Studio

Lecture 17 What is SQL?

Lecture 18 Create a Database Table using SQL Script

Lecture 19 Review Table Creation

Lecture 20 Insert Data into the Table using Management Studio

Lecture 21 Insert Data into the Table using SQL Scripts

Lecture 22 Select Data from Tables – Simple Queries

Lecture 23 Select Data from Tables – Adding Filtering

Lecture 24 Select Data from Tables – Exporting Data

Lecture 25 Update Data in Tables

Lecture 26 Delete Data from the Tables

Lecture 27 SQL Transactions

Lecture 28 Review CRUD Operations

Section 6: Normalization, Relationships and Foreign Keys

Lecture 29 What are Relationships, Foreign Keys and Normalization

Lecture 30 Normalizing Our Database

Lecture 31 Creating a Relationship in SQL Server

Lecture 32 Inserting Records in One To Many Related Tables

Lecture 33 Inserting Records in Many To Many Related Tables

Lecture 34 Using Inner Joins To Read Related Data

Lecture 35 Understanding Left, Right and Full Joins

Lecture 36 Foreign Key Cascade Options

Lecture 37 Review

Section 7: Group By and Aggregate Functions

Lecture 38 Grouping Data using SQL GROUP BY Clause

Lecture 39 SQL COUNT Aggregate Function

Lecture 40 SQL AVG (Average) Aggregate Function

Lecture 41 SQL MAX and MIN Aggregate Functions

Lecture 42 SQL SUM Aggregate Function

Lecture 43 Filtering on Aggregate Values

Lecture 44 Aggregate Function Scripts

Section 8: Advanced SQL Server Objects and Concepts

Lecture 45 Section Overview

Lecture 46 Create and Manage Views

Lecture 47 Scalar Valued Functions

Lecture 48 Inline Table Valued Functions

Lecture 49 Multi Statement Table Valued Functions

Lecture 50 Stored Procedures

Lecture 51 Table Triggers

Lecture 52 Generating Database Scripts

Lecture 53 Database Backup and Restore

Section 9: SQL Server Security

Lecture 54 Section Overview

Lecture 55 Create an SQL User Login

Lecture 56 Add Windows Authenticated Login

Lecture 57 Add Server Logins With Script

Section 10: BONUS Lecture

Lecture 58 Bonus Lecture

Beginner Database Developer,Intermediate Database Developers,Potential Database Administrators,Everyone!

Course Information:

Udemy | English | 8h 20m | 3.12 GB
Created by: Trevoir Williams

You Can See More Courses in the Developer >> Greetings from

New Courses

Scroll to Top