-
Book Overview & Buying
-
Table Of Contents
The Complete Guide for SQL with Microsoft SQL Server
By :
The Complete Guide for SQL with Microsoft SQL Server
By:
Overview of this book
Embark on a complete journey through Microsoft SQL Server 2022, starting with its installation and foundational concepts. The course progresses to complex topics, ensuring you gain expertise in both SQL commands and SQL Server Management Studio. It offers hands-on experience with practical exercises, taking you step by step through key operations like table management, aggregate functions, and advanced SQL queries.
You’ll first get familiar with the basics, from setting up SQL Server to understanding RDBMS and NonRDBMS systems. The course covers SQL commands, key constraints, and creating, modifying, and managing databases and tables. Later, dive into aggregate functions, operators, joins, and subqueries, followed by advanced topics such as stored procedures, triggers, transactions, and normalization.
Finally, the course introduces essential database security practices, transaction management, and database backup strategies. By the end, you’ll be proficient in managing and optimizing SQL Server, ready to tackle real-world database challenges with confidence.
Table of Contents (39 chapters)
Course Introduction and Table of Contents
Database and Database Management Systems
RDBMS and NonRDBMS
SQL Commands
Installing Microsoft SQL Server
Basic Database Operations
Fundamental Table Operations
Importing Sample Databases
Using Aggregate Functions in MSSQL
Clauses in MSSQL
Grouping Sets Clause
SQL Basic Operators
Union and Intersect Operators
Introduction to Popular Data Types
Popular Datatypes
Mastering Primary Key Constraints in SQL
Mastering Foreign Key Constraints in SQL
NOT NULL and UNIQUE Constraints
CHECK and DEFAULT Constraints
SQL String Functions
SQL Popular Date Functions
SQL Popular Mathematical Functions
SQL Popular Convert Functions
Joins - Introduction and Table Preparation
Inner Join
Outer Join
Self Join
Cross Join
Stored Procedure Basics
Stored Procedure Parameters and Return
SQL Subqueries
SQL Views
SQL Triggers - DDL Triggers
SQL Triggers - DML Trigger
SQL Transactions
Normalization
Database Backup and Restore
Database Security
This video is locked
