The Ultimate T-SQL and Microsoft SQL Server Bootcamp

Overview

The Ultimate T-SQL and Microsoft SQL Server Bootcamp is a comprehensive course designed for individuals who want to gain expertise in managing and utilizing Microsoft SQL Server and Transact-SQL.

Syllabus

• Introduction to Microsoft SQL Server
Overview of SQL Server and its components
Installation and configuration of SQL Server
SQL Server Management Studio (SSMS) basics
• Understanding Databases and Tables
Creating and managing databases
Database schemas and data types
Designing and creating tables
• Introduction to Transact-SQL (T-SQL)
Understanding T-SQL syntax and structure
Basic SELECT queries
Filtering and sorting data
• Advanced T-SQL Querying
Joins and subqueries
Aggregation and grouping
Common table expressions (CTEs)
• Data Modification
Inserting, updating, and deleting data
Using transactions and locking
Error handling and TRY-CATCH
• Indexes and Performance Tuning
Understanding indexes and their types
Creating and managing indexes
Indexing strategies for performance optimization
• Views, Stored Procedures, and Functions
Creating and using views
Designing and implementing stored procedures
Creating user-defined functions
• Security and User Management
SQL Server authentication and authorization
Managing user permissions and roles
Understanding encryption and data security
• Backup and Recovery
Backup strategies and types
Restoring databases and data recovery techniques
Managing transactions and log files
• SQL Server Integration Services (SSIS)
Introduction to ETL processes
Designing SSIS packages
Deploying and managing SSIS projects
• SQL Server Reporting Services (SSRS)
Creating and managing reports
Designing report templates
Deploying and configuring reports
• Best Practices and Real-world Applications
Best practices for database design and management
Real-world case studies
Common pitfalls and how to avoid them
• Capstone Project
Designing and implementing a complete database solution
Integrating learned skills to solve complex business problems
Presenting and documenting project outcomes

---

Taught by

Trevoir Williams and Emar Morrison

---

Subjects

Computer Science