T-SQL

About the course

SQL is the standard language to define, manipulate and control relational database management systems in any RDBMS. Microsoft has added a procedural language on SQL and named it T-SQL, Transaction-SQL, that adds declared variables, transaction control, error and exception handling and row processing to SQL. Because T-SQL has added a number of functions/ procedures on SQL, a lot of companies are using it to process transactions on MS SQL Server.

What are the requirements?

Anyone who is interested to know and apply T-SQL on MS SQL Server
Requires Database and Database Design Concept, and SQL

What I am going to get from this course

Understand basics of MS SQL Server
Know what procedural language and how it is used in T-SQL
Know T-SQL keywords and rules
Use DDL, DML DCL queries for T-SQL
Use T-SQL ranking, offset and aggregate functions
Execute stored procedures
Program with T-SQL
Implement error handling and transactions

Training Highlights

Mentorship will be available through training and after training
You will practice on interview questions starting from day one

Curriculum

Module 1: Basics on MS SQL Server 2016

1.1 This module introduces SQL Server
1.2 the versions of SQL Server
1.3 including cloud versions
1.4 and how to connect to SQL Server using SQL Server Management Studio
1.5 SQL Server Architecture
1.6 Learn SQL Server Management Studio and Tools
1.7 Creating T-SQL Scripts and Managing them

Module 2: Introduction to T-SQL Querying

2.1 Basics of T-SQL
2.2 Know Sets and Predicate Logic
2.3 Know Logical Order of Operations in SELECT statements
2.4 Write T-SQL Querying and run SELECT Statements
2.5 Run queries that filters data using predicates
2.6 Use ORDER BY to sort data
2.7 -- (Comment) and Slash Star Comment
2.8 CREATE DIAGNOSTICS SESSION
2.9 NULL and UNKNOWN USE
2.10 Backslash and GO

Module 3: T-SQL Control Flows and Error Handling

3.1 BEGIN...END
3.2 BREAK and CONTINUE
3.3 ELSE (IF...ELSE)
3.4 END (BEGIN...END)
3.5 GOTO
3.6 RETURN
3.7 TRY...CATCH and THROW
3.8 WAITFOR while WHILE

Module 4: Using CURSORS IN T-SQL

4.1 CLOSE
4.2 DEALLOCATE and DECLARE CURSOR
4.3 FETCH and OPEN

Module 5: Using Expressions in T-SQL

5.1 Using with CASE Expression
5.2 Using with COALESCE Expression
5.3 Using NULLIF Expression

Module 6: Using Operators in T-SQL

6.1 Using Unary - Positive and Negative Operators
6.2 Set - EXCEPT and INTERSECT Operators
6.3 Set - UNION Operator
6.4 Using Arithmetic Operators
6.5 Module
6.6 Assignment
6.7 Using Comparisons
6.8 Logical Operators
6.9 Work on Strings

Module 7: Working in TRANSACTIONS

7.1 Transaction Isolation Levels
7.2 Apply BEGIN DISTRIBUTED TRANSACTION and BEGIN TRANSACTION
7.3 COMMIT TRANSACTION and COMMIT WORK
7.4 ROLLBACK TRANSACTION and ROLLBACK WORK
7.5 SAVE TRANSACTION

Module 8: Variables in T-SQL

8.1 SET @local_variable
8.2 SELECT @local_variable
8.3 DECLARE @local_variable

Request a detailed syllabus.

Get Answers (Answering their questions)

What kind of learning does ITlearn360.com provide?

ITlearn360.com offers instructor-led online live sessions and classroom-based corporate trainings and bootcamps for various courses and certifications to the learners.

Who are the instructors @ITlearn360.com?

@ITlearn360.com, we have an instructor community of industry professionals who are working in leading organizations and are veterans in their respective fields. These experts belong to various industries and are willing to share their talent with learners like you.

Are classes @ITlearn360.com conducted through online video streaming?

Yes, the classes @ITlearn360.com are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users also get recorded video of the class.