SQL Tutorial for Beginners with SQL Server | Full Course | 2024

🎁ALL-ACCESS Subscription: Unlock access to all of my courses, both now and in the future at a low $19.99 / month. https://frankliucs.com/all-access 💎 SQL Masterclass: From Zero to Hero with SQL Server https://frankliucs.com/sql 💎 ASP.NET Deep Dive (32 Hours Complete Course) https://frankliucs.com/aspnetcore 💎 Complete Web API Course in .NET 10 https://frankliucs.com/webapi-course 💎 Learn Blazor while building an Inventory Management System in .NET 8 https://frankliucs.com/blazor-ims 💎 Become advanced-level programmer with challenges from CodeCrafters. Over 50k devs use CodeCrafters, including staff-level engineers at Google, GitHub, Vercel, and more. Use the following link to get 40% off: https://frankliucs.com/codecrafters 💎 Learn .NET Core MVC in .NET 8 by building a Market Management System https://frankliucs.com/mvc 💎 Complete Guide to ASP.NET Core Identity in .NET 8 https://frankliucs.com/identity 💎 Complete Web API Course in .NET 8 https://frankliucs.com/webapi-course 💎Learn .NET MAUI while creating a Contacts App in .NET 7: https://frankliucs.com/maui 🔥Learn Blazor while creating an Inventory Management System in .NET 6 https://frankliucs.com/blazor-ims 💎Complete Blazor Course: Build an e-commerce app with ASP.NET Blazor and Clean Architecture https://frankliucs.com/blazor-course 👍Clearn Architecture Course https://frankliucs.com/architecture-course 🔌 Connect with me: https://frankliucs.com/ 🏅 Support me on Patreon: https://www.patreon.com/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