T-SQL Bootcamp - 200 Days of Individual Coaching

Before purchasing this course, please register yourself of the following

Google Forms Link : https://forms.gle/TMock1ZDd9kyFpaC6

Once you fill the form, we will send you an email mentioning the available time slots. Once we agree on time slot, we will then ask you to make the payment.

Google Meet Link will be shared over to your email once you make payment for this course.

We will cover following topics during this Bootcamp.

Getting Started with SELECT

Elementary Programming

Working with NULLS

Querying from Multiple Table

Aggregations and Groupings

Advanced SELECT techniques

Windowing Functions

Inserting, Updating and Deleting

Working with String

Working with Dates and Times

Working with Numbers

Transactions, Locking, Blocking, and Deadlocking

Managing Tables

Managing Views

Managing Large Tables and Databases

Managing Indexes

Stored Procedures

User-Defined Functions and Types

In-Memory OLTP

Triggers

Error Handling

Query Performance Tuning

Hints

Index Tuning and Statistics

Backup

Recovery

Principals and Users

Securables, Permissions, and Auditing

Objects and Dependencies