Live Class Practical Oriented Training
Timely Doubt Resolution
Dedicated Student Success Mentor
Certification & Job Assistance
Free Access to Workshop & Webinar
No Cost EMI Option
Understand the underlying architecture and basic concepts of SQL Server 2016. Familiarize with Transact-SQL and discern...
Write queries for multiple tables. Sort, filter, and modify data using Transact-SQL
Understand different data types used in SQL Server. Use built-in functions, table expressions, set operators and subquer...
Group and aggregate data. Implement window ranking, offset and aggregate functions
Implement grouping sets and pivoting. Execute stored procedures, transactions and error handling
Write queries for multiple tables. Sort, filter, and modify data using Transact-SQL
Part 1: Querying Data with Transact-SQL
Lecture 1: Introduction to Microsoft SQL Server
Lecture 2: Introduction to T-SQL Querying
Lecture 3: Writing SELECT Queries
Lecture 4: Querying Multiple Tables
Lecture 5: Sorting and Filtering Data
Lecture 6: Working with SQL Server Data Types
Lecture 7: Using DML to Modify Data
Lecture 8: Using Built-In Functions
Lecture 9: Grouping and Aggregating Data
Lecture 10: Using Subqueries
Lecture 11: Using Table Expressions
Lecture 12: Using Set Operators
Lecture 13: Using Windows Ranking, Offset & Aggregate Functions
Lecture 14: Pivoting and Grouping Sets
Lecture 15: Executing Stored Procedures
Lecture 16: Programming with T-SQL
Lecture 17: Implementing Error Handling
Lecture 18: Implementing Transactions
Part 2: Developing SQL Databases
Lecture 19: Introduction to Database Development
Lecture 20: Designing and Implementing Tables
Lecture 21: Advanced Table Designs
Lecture 22: Ensuring Data Integrity through Constraints
Lecture 23: Introduction to Indexes
Lecture 24: Designing Optimized Index Strategies
Lecture 25: Columnstore Indexes
Lecture 26: Designing and Implementing Views
Lecture 27: Designing and Implementing Stored Procedures
Lecture 28: Designing &Implementing User-Defined Functions
Lecture 29: Responding to Data Manipulation via Triggers
Lecture 30: Using In-Memory Tables
Lecture 31: Implementing Managed Code in SQL Server
Lecture 32: Storing and Querying XML Data in SQL Server
Lecture 33: Storing and Querying Spatial Data in SQL Server
Lecture 34: Storing & Querying BLOBs in SQL Server
Lecture 35: SQL Server Concurrency
Lecture 36: Performance and Monitoring