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

Simpliv

Course

Online

£ 10 + VAT

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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 followHow 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 ProcedureFollowing are the major topics covered Deep dive into Window Functions
Ranking Functions - (Rank, Dense_Rank Row_Number, NTile )
Aggregate Functions - (Sum,Min,Max,Avg,Count)
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/Throw
Error Handling (Try….Catch)

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Sales Training
  • Trade
  • Sales
  • SQL
  • Server

Course programme

Module 1 10 lectures 01:00:34 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 Please download Demonstration Exercises 1 Please download the following file and extract it in your computer Guidelines while performing DML Operations How to switch between different SQL Servers within a query window in SSMS How to create Solution File in SSMS and what is the need for it How to use a single sql script file for different SQL Servers How to generate Identity Column How to insert a row with old identity value which was deleted How to reset table identity Module 1 10 lectures 01:00:34 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 Please download Demonstration Exercises 1 Please download the following file and extract it in your computer Guidelines while performing DML Operations How to switch between different SQL Servers within a query window in SSMS How to create Solution File in SSMS and what is the need for it How to use a single sql script file for different SQL Servers How to generate Identity Column How to insert a row with old identity value which was deleted How to reset table identity How to view the structure of a table & how to create your own shortcuts in SSMS How to view the structure of a table & how to create your own shortcuts in SSMS How to view the structure of a table & how to create your own shortcuts in SSMS 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 Dropping multiple tables in one go having a fixed pattern Dropping multiple tables in one go having a fixed pattern Dropping multiple tables in one go having a fixed pattern Please download Demonstration Exercises 1 Please download the following file and extract it in your computer Please download Demonstration Exercises 1 Please download the following file and extract it in your computer Please download Demonstration Exercises 1 Please download the following file and extract it in your computer Please download Demonstration Exercises 1 Please download the following file and extract it in your computer Please download the following file and extract it in your computer Please download the following file and extract it in your computer Guidelines while performing DML Operations Guidelines while performing DML Operations Guidelines while performing DML Operations Guidelines while performing DML Operations How to switch between different SQL Servers within a query window in SSMS How to switch between different SQL Servers within a query window in SSMS How to switch between different SQL Servers within a query window in SSMS How to switch between different SQL Servers within a query window in SSMS How to create Solution File in SSMS and what is the need for it How to create Solution File in SSMS and what is the need for it How to create Solution File in SSMS and what is the need for it How to create Solution File in SSMS and what is the need for it How to use a single sql script file for different SQL Servers How to use a single sql script file for different SQL Servers How to use a single sql script file for different SQL Servers How to use a single sql script file for different SQL Servers How to generate Identity Column How to generate Identity Column How to generate Identity Column How to generate Identity Column How to insert a row with old identity value which was deleted How to insert a row with old identity value which was deleted How to insert a row with old identity value which was deleted How to insert a row with old identity value which was deleted How to reset table identity How to reset table identity How to reset table identity How to reset table identity Module 2 10 lectures 01:10:47 Please download Demonstration Exercises 2 Please download the following file and extract it in your computer Theoretical Explanation of Window Functions RANK DENSE_RANK ROW_NUMBER NTILE WINDOW FUNCTIONS SUM MIN MAX COUNT AVG Window Functions FIRST_VALUE LAST_VALUE LAG LEAD Window Function Scenarios on Window Functions Scenario1 - Solution on Aggregate Window Function Scenario2 - Solution on Cumulative totals Scenario3 - Solution on Analytical Window Function Quiz 1 Hands On Questions on Window Functions Please try the questions by yourself and then you can verify the answers from the solutions file. Please download the zip file Module 2. 10 lectures 01:10:47 Please download Demonstration Exercises 2 Please download the following file and extract it in your computer Theoretical Explanation of Window Functions RANK DENSE_RANK ROW_NUMBER NTILE WINDOW FUNCTIONS SUM MIN MAX COUNT AVG Window Functions FIRST_VALUE LAST_VALUE LAG LEAD Window Function Scenarios on Window Functions Scenario1 - Solution on Aggregate Window Function Scenario2 - Solution on Cumulative totals Scenario3 - Solution on Analytical Window Function Quiz 1 Hands On Questions on Window Functions Please try the questions by yourself and then you can verify the answers from the solutions file Please download the following file and extract it in your computer Please download the following file and extract it in your computer Please download the following file and extract it in your computer How to use window function in the where clause using CTE and Derived Tables How to use window function in the where clause using CTE and Derived Tables How to use window function in the where clause using CTE and Derived Tables How to use window function in the where clause using CTE and Derived Tables How to delete duplicate records from a table How to delete duplicate records from a table How to delete duplicate records from a table How to delete duplicate records from a table How to select only duplicate records from a table How to select only duplicate records from a table How to select only duplicate records from a table How to select only duplicate records from a table Quiz 2 Quiz 2 Quiz 2 Quiz 2 How to produce Date Dimension using Recursive CTE How to produce Date Dimension using Recursive CTE How to produce Date Dimension using Recursive CTE How to produce Date Dimension using Recursive CTE Hands On Question Please try the question by yourself and then you can verify the answers from the solutions file. Please download the zip file Hands On Question Please try the question by yourself and then you can verify the answers from the solutions file. Please download the zip file Hands On Question Please try the question by yourself and then you can verify the answers from the solutions file. Please download the zip file Hands On Question Please try the question by yourself and then you can verify the answers from the solutions file. Please download the zip file Please try the question by yourself and then you can verify the answers from the solutions file. Please download the zip file Please try the question by yourself and then you can verify the answers from the solutions file. Please download the zip file Scenario solved using Coalesce Function Scenario solved using Coalesce Function Scenario solved using Coalesce Function Scenario solved using Coalesce Function How to Merge New Changes to an Existing Table How to Merge New Changes to an Existing Table How to Merge New Changes to an Existing Table How to Merge New Changes to an Existing Table How to Merge New Changes to an Existing Table using Coalesce Function How to Merge New Changes to an Existing Table using Coalesce Function How to Merge New Changes to an Existing Table using Coalesce Function ...

Additional information

Elementary knowledege of Transact SQL is needed like SSMS,Database Tables, Select , Join , Group By Commands ,Primary Key, Foreign Key

See related categories

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

£ 10 + VAT

The best Other Education courses

See all

See all