T-SQL Training Course

Our MSSQL Course is designed for beginners and professionals. MSSQL is a relational database management system. It is open-source and free. Our MSSQL course includes all topics of MSSQL database such as insert record, update record, delete record, select record, create table, drop table etc. MSSQL is one of the best RDBMS being used for developing various web-based software applications. MSSQL is developed, marketed and supported by MicroSoft company.

Overview

MSSQL: T-SQL & T-SQL Programming in SQL Server

Transact-SQL is an essential skill for data professionals and developers working with SQL databases. With this combination of expert instruction, demonstrations, and practical labs, step from your first SELECT statement through to implementing transactional programmatic logic.

Work through multiple modules, each of which explore a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database. The labs in this course use a sample database that can be deployed easily in Azure SQL Database, so you get hands-on experience with Transact-SQL without installing or configuring a database server.


Prerequisites

Anyone with a willingness to learn.

Basic knowledge of using Computers.


MSSQL Training Duration

Regular classroom based training: 4 Weeks, 60 minutes of theory & practical session per day.

Modules

Course Content

  1. Introduction to TSQL
  2. Datatypes
  3. SELECT statments
  4. From Clause
  5. Where clause
  1. Group by Clause
  2. Sorting
  3. TOP/Percent
  4. Operators in SQL
  5. ALIASES
  1. DDLs
  2. Batch processing
  3. Built In Functions – Strings
  4. Built In Functions – Date/Time
  5. Built In Functions – Conversion
  1. Aggregate Functions
  2. Advanced Functions
  3. Top n Clause - Set Operators
  4. Joins – INNER, OUTER, FULL
  5. SET Operators – UNION, INTERSECT, EXCEPT
  1. Sub Queries & Co-related Subqueries
  2. Constraints
  3. Indexes
  4. ALTER Command
  5. Sequence
  1. Views
  2. WITH Clause
  3. Introduction to TSQL Programming
  4. Variables and Dataypes
  5. Declaration
  1. Writing programs and batches
  2. Table datatype
  3. Transaction Management
  4. Control statements
  5. Looping Control
  1. Break and Continue
  2. Handling Errors
  3. Cursors
  4. Stored Procedures
  5. OUT PARAMETER
  6. User Defined Functions
  7. Triggers
  8. Exception Handling
Post an Enquiry

Post an Enquiry

Address

1/583, ECR, KOTTIVAKKAM
CHENNAI / TAMIL NADU / INDIA

E-mail

astroinfo@astrotech.in
astroeq.com@gmail.com

Contact No.

+91 9710107874
(044) 438 55 773