Complete Microsoft SQL Server Database Design Masterclass

4.56 (2777 reviews)

Udemy

platform

English

language

Databases

What you will 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

Loading charts...

Comidoc Review

Our Verdict

The Complete Microsoft SQL Server Database Design Masterclass is an extensive course that provides solid foundational knowledge and introduces advanced SQL features. While some users might crave more formal exercises or in-depth explanations of specific topics, the sheer volume of information covered in this course makes it a worthy choice for beginners looking to grasp SQL fundamentals and venture into more complex subjects.

What We Liked

Covers a wide range of topics including table relationships, Transact-SQL, functions, stored procedures, and database security.
Instructor explains concepts clearly with prompts for hands-on practice, making it easy to follow along.
Ideal for beginners, refreshing foundational knowledge and introducing advanced SQL features.
Comprehensive course material, updated regularly ensuring relevance.

Potential Drawbacks

Some users might find pacing challenging due to the volume of information presented.
Lacking in formal exercises or quizzes as reinforcement.
Certain concepts could benefit from additional explanation for absolute beginners.
Minimal coverage on modifying existing tables without dropping them.