Skip to Content on-demand course The Complete Guide for SQL with Microsoft SQL Server April 2023
Beginner
7h 47m
English
Closed Captioning available in English Course outline Chapter 1 : Course Introduction and Table of Contents 9m
Chapter 2 : Database and Database Management Systems 7m
Chapter 3 : RDBMS and NonRDBMS 5m
Chapter 4 : SQL Commands 2m
Chapter 5 : Installing Microsoft SQL Server 7m
Chapter 6 : Basic Database Operations 20m
Chapter 7 : Fundamental Table Operations 29m
Chapter 8 : Importing Sample Databases 7m
Chapter 9 : Using Aggregate Functions in MSSQL 19m
Chapter 10 : Clauses in MSSQL 27m
Chapter 11 : Grouping Sets Clause 15m
Chapter 12 : SQL Basic Operators 19m
Chapter 13 : Union and Intersect Operators 12m
Chapter 14 : Introduction to Popular Data Types 17m
Chapter 15 : Popular Datatypes 15m
Chapter 16 : Mastering Primary Key Constraints in SQL 23m
Chapter 17 : Mastering Foreign Key Constraints in SQL 21m
Chapter 18 : NOT NULL and UNIQUE Constraints 13m
Chapter 19 : CHECK and DEFAULT Constraints 12m
Chapter 20 : ER Diagrams 9m
Chapter 21 : SQL String Functions 12m
Chapter 22 : SQL Popular Date Functions 11m
Chapter 23 : SQL Popular Mathematical Functions 3m
Chapter 24 : SQL Popular Convert Functions 5m
Chapter 25 : Joins - Introduction and Table Preparation 18m
Chapter 26 : Inner Join 7m
Chapter 27 : Outer Join 7m
Chapter 29 : Cross Join 4m
Chapter 30 : Stored Procedure Basics 11m
Chapter 31 : Stored Procedure Parameters and Return 8m
Chapter 32 : SQL Subqueries 3m
Chapter 34 : SQL Triggers - DDL Triggers 8m
Chapter 35 : SQL Triggers - DML Trigger 18m
Chapter 36 : SQL Transactions 13m
Chapter 37 : Normalization 5m
Chapter 38 : Database Backup and Restore 7m
Chapter 39 : Database Security 9m
Show More Different Types of SQL Commands
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, Start your free trial