IIRF Online > Development > Database Design & Development > SQL Server > Complete Microsoft SQL Server Database Design Masterclass
Complete Microsoft SQL Server Database Design Masterclass by Udemy
Database Design | SQL Server | T-SQL | Database Tables | Foreign Keys | SQL CRUD | Views | Triggers | Stored Procedures
Course Highlights
- 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
Skills you will learn!
Curriculum
2 Topics
Introduction
Understanding Types of Data and Storage
2 Topics
Download and Install SQL Server Express (Windows)
Install SQL Server on Mac and Linux
3 Topics
Explore SQL Server Management Studio
Explore Azure Data Studio
Explore Draw.io
6 Topics
Section Overview
Create Database using Management Studio
Create a Database using SQL Script
How to Remove a Database
How To Change Database Name
Section Review
15 Topics
What is a Database Table?
Create Entity Data Model
Create a Database Table using Management Studio
What is SQL?
Create a Database Table using SQL Script
Review Table Creation
Insert Data into the Table using Management Studio
Insert Data into the Table using SQL Scripts
Select Data from Tables - Simple Queries
Select Data from Tables - Adding Filtering
Select Data from Tables - Exporting Data
Update Data in Tables
Delete Data from the Tables
SQL Transactions
Review CRUD Operations
9 Topics
What are Relationships Foreign Keys and Normalization
Normalizing Our Database
Creating a Relationship in SQL Server
Inserting Records in One To Many Related Tables
Inserting Records in Many To Many Related Tables
Using Inner Joins To Read Related Data
Understanding Left Right and Full Joins
Foreign Key Cascade Options
Review
7 Topics
Grouping Data using SQL GROUP BY Clause
SQL COUNT Aggregate Function
SQL AVG (Average) Aggregate Function
SQL MAX and MIN Aggregate Functions
SQL SUM Aggregate Function
Filtering on Aggregate Values
Aggregate Function Scripts
9 Topics
Section Overview
Create and Manage Views
Scalar Valued Functions
Inline Table Valued Functions
Multi Statement Table Valued Functions
Stored Procedures
Table Triggers
Generating Database Scripts
Database Backup and Restore
4 Topics
Section Overview
Create an SQL User Login
Add Windows Authenticated Login
Add Server Logins With Script
1 Topic
Bonus Lecture
Complete Microsoft SQL Server Database Design Masterclass
Related SQL Server Courses
Thank You!
Your review has been submitted successfully.