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

This course aims to teach students the fundamentals of SQL Server, including installation, database relationships, integrity constraints, normalization, querying, and indexing. Students will learn how to create tables, insert and select data, and utilize various SQL commands. The teaching method includes video tutorials and practical demonstrations. This course is intended for beginners who want to learn SQL Server for database management and development purposes.

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 .
  • Sakshee Gawande
    Nice excellent and write in notess thank you
    But voice is error little
    Thank you
    Thank you thank you
  • Kire
    Excellent tutorial, everything was explained really well.
    i hope you will make more videos like this.
  • 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

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.