ALLACCESS Subscription: Unlock access to all of my courses, both now and in the future at a low $19.99 / month.
https://frankliucs.com/allaccess'>https://frankliucs.com/allaccess

SQL Masterclass: From Zero to Hero with SQL Server
https://frankliucs.com/sql'>https://frankliucs.com/sql

Learn Blazor while building an Inventory Management System in .NET 8
https://frankliucs.com/blazorims'>https://frankliucs.com/blazorims'>https://frankliucs.com/blazorims'>https://frankliucs.com/blazorims

Become advancedlevel programmer with challenges from CodeCrafters. Over 50k devs use CodeCrafters, including stafflevel engineers at Google, GitHub, Vercel, and more. Use the following link to get 40% off:
https://frankliucs.com/codecrafters'>https://frankliucs.com/codecrafters

Learn .NET Core MVC in .NET 8 by building a Market Management System
https://frankliucs.com/mvc'>https://frankliucs.com/mvc

Complete Guide to ASP.NET Core Identity in .NET 8
https://frankliucs.com/identity'>https://frankliucs.com/identity

Complete Web API Course in .NET 8
https://frankliucs.com/webapicourse'>https://frankliucs.com/webapicourse

Learn .NET MAUI while creating a Contacts App in .NET 7:
https://frankliucs.com/maui'>https://frankliucs.com/maui

Learn Blazor while creating an Inventory Management System in .NET 6
https://frankliucs.com/blazorims'>https://frankliucs.com/blazorims'>https://frankliucs.com/blazorims'>https://frankliucs.com/blazorims

Complete Blazor Course: Build an ecommerce app with ASP.NET Blazor and Clean Architecture
https://frankliucs.com/blazorcourse'>https://frankliucs.com/blazorcourse

Clearn Architecture Course
https://frankliucs.com/architecturec...

Connect with me: https://frankliucs.com/
Support me on Patreon:   / frankliucs  
☕ Support me on Buy me a Coffee: https://www.buymeacoffee.com/frankliucs

00:00:00 Introduction
00:03:18 What is SQL
00:04:47 DBMS, Databases, and Tables
00:06:34 Install MS SQL Server and SSMS
00:13:25 Use SSMS to Connect to SQL Server
00:22:43 How to execute SQL statements
00:28:47 Create & Delete Databases
00:34:57 Create Table & USE database
00:43:52 Data Types: char, varchar, nchar, nvarchar
00:53:30 Data Types: float, real & decimal
01:01:59 Data Types: date, time, dat
01:07:16 Column Constraints: NOT NULL
01:10:12 Column Constraints: UNIQUE
01:11:58 Column Constraints: CHECK
01:14:12 Column Constraints: PRIMARY KEY & IDENTITY
01:19:10 Modify existing tables
01:25:25 Assignment 1: Questions
01:26:57 Assignment 1: Anwsers
01:36:13 Table Relationships: 1 to Many
01:43:18 FOREIGN KEY constraint
01:47:16 Table Relationships: Many to Many
01:58:31 Assignment 2: Questions
02:00:37 Assignment 2: Anwsers