Beginning T-SQL for SQL Server Developer, Data Analyst & DBA

Step By Step Practical Training on Programming, Development and Querying Microsoft SQL Server using Transact SQL

Created by: Vikas Munjal
SQL Server | MSBI Microsoft Certified Trainer & Consultant

What Will I Learn?

• Creating Database , Tables and Performing DML Operations
• Basic T-SQL - SELECT , WHERE , GROUP BY ,HAVING, BETWEEN , LIKE etc
• Joins - Inner Left Right Full & Cross
• Schema
• SubQueries
• DataTypes
• Implicit and Explicit Conversion
• CASE Statements
• Joining more than two tables
• InBuilt Functions

Requirements

• The course starts right from the scratch which also tells about software installation. One can go through free preview videos for better understanding

Target audience

• Beginner Developers, DBAs or Data Analysts curious about Microsoft SQL Server Database Engine