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
💎 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-c...
🔌 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
