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.

💎 SQL Masterclass: From Zero to Hero with SQL Server

💎 Learn Blazor while building an Inventory Management System in .NET 8

💎 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:

💎 Learn .NET Core MVC in .NET 8 by building a Market Management System

💎 Complete Guide to ASP.NET Core Identity in .NET 8

💎 Complete Web API Course in .NET 8

💎Learn .NET MAUI while creating a Contacts App in .NET 7:

🔥Learn Blazor while creating an Inventory Management System in .NET 6

💎Complete Blazor Course: Build an e-commerce app with ASP.NET Blazor and Clean Architecture

👍Clearn Architecture Course

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

[tylerwebb]

Mr. Liu thank you for your original video on Identity, it was the most concise and clear training i have found so far. The overview explanation of what each process was physically doing really helped me to look at coding different and it also changed how I am learning about coding. Thanks again.

[raggardy]

I love the analogy many students remember one Frank, that made it stick!

[Joeyxyx]

I am very glad I bought this full course on Udemy ❤😊. Thanks for sharing your knowledge, Frank.

[rachid_]

Thank you, your courses are awesome. ❤

[mokumdrie]

get followng message as result of drop database FirstDB:

Msg 3702, Level 16, State 4, Line 1
Cannot drop database "FirstDB" because it is currently in use.

[jesamcool]

Bro you totally could have won that lawsuit against Reno

[naren]

Hi Liu Thanks a Lot for uploading the video..i am expecting advanced sql concepts videos from you...