Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server Complete Series

Caleb Curry via YouTube

Overview

Dive into a comprehensive 7-hour video series on SQL Server, covering everything from installation and basic concepts to advanced database design principles and query techniques. Learn how to set up SQL Server 2016 and SQL Server Management Studio (SSMS), understand key database relationships, explore integrity constraints, master normalization techniques, and practice essential SQL commands. Progress through hands-on tutorials on creating tables, defining primary and foreign keys, inserting and selecting data, working with aliases, and managing indexes. Gain a solid foundation in SQL Server with this all-encompassing quick start guide suitable for beginners and intermediate users alike.

Syllabus

SQL Server 1 - Intro to SQL Server.
SQL Server 2 - Installing SQL Server 2016.
SQL Server 3 - How to Install SSMS.
SQL Server 4 - Beginner Terms Part 1.
SQL Server 5 - Beginner Terms Part 2.
SQL Server 6 - Beginner Terms Part 3.
SQL Server 7 - One-to-One Relationship.
SQL Server 8 - One-to-Many Relationship.
SQL Server 9 - Many-to-Many Relationship.
SQL Server 10 - Database Relationships Summary.
SQL Server 11 - Entity Integrity.
SQL Server 12 - Referential Integrity.
SQL Server 13 - Domain Integrity.
SQL Server 14 - Primary Key.
SQL Server 15 - Composite Key.
SQL Server 16 - Foreign Key.
SQL Server 17 - ON DELETE and ON UPDATE.
SQL Server 18 - Intro to Normalization.
SQL Server 19 - 1NF.
SQL Server 20 - 2NF.
SQL Server 21 - 3NF.
SQL Server 22 - Normalization Summary.
SQL Server 23 - Intro to Queries.
SQL Server 24 - CREATE TABLE.
SQL Server 25 - Drop Table.
SQL Server 26 - PRIMARY KEY, NOT NULL, UNIQUE.
SQL Server 27 - How to Create FOREIGN KEY Constraints.
SQL Server 28 - Composite Primary Key.
SQL Server 29 - How to Name Constraints.
SQL Server 30 - How to INSERT Data.
SQL Server 31 - How to SELECT Data.
SQL Server 32 - How to Create an Alias with AS.
SQL Server 33 - Indexes.
SQL Server 34 - How to Create and Drop Indexes.
SQL Server All-in-One Quick Start Tutorial Series (OVER 3 HOURS!).

Taught by

Caleb Curry

Reviews

4.2 rating, based on 4 Class Central reviews

Start your review of SQL Server Complete Series

  • Profile image for Durga Bhavani
    Durga Bhavani
    thank you for the support and knowledge shared by you helped me to improve my skill on SQL which helped me to enhance the knowledge about constraints .
  • Gayathri Pasupuleti
    It is useful for the beginners to get basic knowledge on SQL. The definition of each topic is clearly explained in this vedio
  • Kire
    Excellent tutorial, everything was explained really well.
    i hope you will make more videos like this.
  • Sakshee Gawande
    Nice excellent and write in notess thank you
    But voice is error little
    Thank you
    Thank you thank you

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.