Overview

This course starts from the beginning , no prior knowledge is needed and it is step By step Practical Training on Programming Transact SQL Query from basics on Microsoft SQL Server Database EngineThis course is must for all the Aspirants who want to become Microsoft SQL Server Database Developers , Microsoft Database Administrator, Web Developers such as.NET Developers,Database ANALYSTS , Report Developers such as SSRS or ETL Developers such as SSIS etcFollowing are the course contents which are covered in this course T-SQL Online SQL Server Video Step By Step TrainingIntroductionWhat is a Relational DatabaseWhat is Relational Database Management SystemSSMS and SQL Server Database EngineSQL Server and SSMS InstallationBasic T-SQLCreating DB Tables & Inserting Data into the tablesPrimary Key and Foreign KeyBasic Select CommandsAggregate Functions with SELECT CommandGroup By Clause using Single and Multiple ColumnsDifference Between WHERE and HAVING ClauseSyntax of SELECT CommandT-SQL Joins to query SQL ServerInner JoinT-SQL with Inner Join and Group By TogetherLeft JoinRight JoinFull JoinCross JoinSelf-JoinUnion OperationUnion All OperationIntersect OperationExcept OperationWorking with SchemaWhat is Schema and its ImportanceSchema Creation & Transfer and Viewing the objects inside Schema using T-SQLSubqueriesGetting Started with first Subquery ExampleCommon Interview Question on SubqueryJoins Group by Derived table Subquery combined TSQLSubquery as a ColumnSubquery using NOT ExistsALL ANY SOME Keywords in SubqueryCorrelated SubqueryNot Exists Keyword Scenario of Correlated Subquery to speed up query performanceDatatypesDatatype ConversionImplicit & Explicit Conversion (Type Casting)DML Operations and ConstraintsMany Different Options while performing insert update and delete operationsPrimary Key, Foreign Key, Unique, Not NULL, Default, Check ConstraintsJoining more than two tablesJoining three tablesJoining four TablesOne more example in joining four tablesWorking with CASE Statements and Inbuilt FunctionsPerforming Select and Update operation using case statementWHILE LoopInbuilt Functions - EOMONTH, IIF, CHOOSE, DatePart, String Functions etc.

Skills

Reviews