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

Published: 31 January 2024
on channel: Frank Liu

5,798

189

🎁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

On this page of the site you can watch the video online SQL Tutorial for Beginners with SQL Server | Full Course | 2024 with a duration of hours minute second in good quality, which was uploaded by the user Frank Liu 31 January 2024, share the link with friends and acquaintances, this video has already been watched 5,798 times on youtube and it was liked by 189 viewers. Enjoy your viewing!

3,223

127