This is everything you need to know to get started as a SQL Server! This is a basic, quick start series to help you get started! Enjoy my content? Subscribe for free! -
Patreon -
Timestamps
00:00:00 - Intro to SQL Server
00:09:21 - Installing SQL Server 2016
00:12:42 - How to Install SSMS
00:16:44 - Beginner Terms Part 1
00:23:56 - Beginner Terms Part 2
00:35:33 - One-to-One Relationship
00:42:15 - One-to-Many Relationships
00:49:33 - Many-to-Many Relationships
00:54:44 - Database Relationships Summary
01:02:21 - Entity Integrity
01:09:41 - Referential Integrity
01:14:55 - Domain Integrity
01:18:36 - Primary Key
01:25:25 - Composite Key
01:33:21 - Foreign Key
01:41:23 - ON DELETE and ON UPDATE
01:49:36 - Intro to Normalization
02:00:02 - 1NF
02:12:54 - 2NF
02:28:09 - 3NF
02:35:37 - Normalization Summary
02:40:16 - Intro to Queries
02:46:48 - CREATE TABLE
02:51:47 - Drop Table
02:55:31 - PRIMARY KEY, NOT NULL, UNIQUE
02:59:07 - How to Create FOREIGN KEY Constraints
03:03:32 - Composite Primary Key
03:08:26 - How to Name Constraints
03:12:08 - How to INSERT Data
03:17:56 - How to SELECT Data
03:20:35 - How to Create an Alias with AS
03:24:00 - Indexes
03:31:41 - How to Create and Drop Indexes
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Want to learn code? Try Pluralsight for free -
Need help getting a job? -
My recommended Web Hosting -
Amazing BenQ Lamp -
~~~~~~~~~~~~~~~ Additional Links ~~~~~~~~~~~~~~~
Instagram -
Twitter -
Facebook -
More content -
Patreon -
Donate -
0 Comments