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
Auf dieser Seite können Sie das Online-Video SQL Tutorial for Beginners with SQL Server | Full Course | 2024 mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Frank Liu 31 Januar 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 5,798 Mal angesehen und es wurde von 189 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
