T-SQL Training using Real World Scenarios:Tricks of the Trade

About this Course:

This online T-SQL video training course on Microsoft SQL Server Technology includes a lot of real world scenario which i learnt in my professional work. I have covered the course contents with the real life situation example for every topic.

Real Life situations are as follow:

• How to view the structure of a table
• How to create your own shortcuts in SSMS
• Dropping multiple tables in one go having a fixed pattern
• Guidelines while performing DML Operations
• How to create Solution File in SSMS and what is the need for it
• How to insert a row with old identity value which was deleted
• How to reset table identity
• How to delete duplicate records from a table
• How to select only duplicate records from a table
• How to produce Date Dimension using Recursive CTE Query
• How to Merge New Changes to an Existing Table
• What are the advantages of Stored Procedure
• BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT
• How to produce running totals or cumulative totals using sql server query
• How to compare current year sales with the previous year sales
• How to compare current year sales since the start of the business year sales
• How to switch between different SQL Servers within a query window in SSMS
• How to use a single sql script file for different SQL Servers
• Reducing Roundtrips using Table Valued Stored Procedure
• Pagination in SQL Server using OFFSET-FETCH
• BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT
• Relevance of Batch in SQL Server
• How to create and store customized errors
• Guidelines of writing a Stored Procedure
• Following are the major topics covered
• Deep dive into Window Functions
• Ranking Functions - Rank Dense Rank Row Number NTile
• Aggregate Functions - SumMinMaxAvgCount
• Analytical Functions - Lead Lag First Value Last Value
• Stored Procedures
• Input Parameters
• Output Parameters
• Default Parameters
• Return
• Table Valued Parameters
• Common Table Expressions
• Recursive Common Table Expressions
• Synonyms
• Identity Columns
• Transactions
• Raiserror or Throw
• Error Handling - Try Catch

Basic knowledge:

• Elementary knowledege of Transact SQL is needed like SSMSDatabase Tables Select Join Group By Commands Primary Key Foreign Key

Course Completion Certificate

What you will learn:

• Participant's knowledge will be deepened to handle real life situations in T-SQL
• Please watch the course description to see more details

Curriculum:

• Module 1
• Module 2
• Module 3
• Module 4

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.