только у нас скачать шаблон dle скачивать рекомендуем

Фото видео монтаж » Видео уроки » Видео уроки web-design » T-SQL Training with Real World Scenarios:Tricks of the Trade

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

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

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

Last updated 6/2023
Created by Vikas Munjal
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 44 Lectures ( 6h 3m ) | Size: 1.12 GB


Transact SQL Query Programming & Developer Advanced Microsoft SQL Server Online Video Training Course by Vikas Munjal

What you'll learn:
Feel more confident in handling real life scenarios and writing complex codes

Requirements:
Basic knowledege of T-SQL is required such as Select , Join , Group By ,Primary Key, Foreign Key

Description:
In this online T-SQL training course , a lot of real life scenarios are included which i learnt by practicing on Microsoft SQL Server Technology over the years. I believe this Transact SQL Programming & Development video tutorial will deepen the understanding on T-SQL developer and participant will feel more confident in handling real life scenarios. I have covered not only the course contents but also i have covered the real life situations 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 - (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)

Who this course is for:
Anyone who wants to enhance his/her knowledge to handle real life situations in T-SQL


HOMEPAGE


 https://www.udemy.com/course/t-sql-training/?couponCode=24T5FS31824  


DOWNLOAD


https://rapidgator.net/file/0e4afd3988572613e649baf2533bdacb/T-SQL_Training_with_Real_World_ScenariosTricks_of_the_Trade.part1.rar.html
https://rapidgator.net/file/89676d389903a6474197c322fd019968/T-SQL_Training_with_Real_World_ScenariosTricks_of_the_Trade.part2.rar.html


https://uploadgig.com/file/download/c848542Bf1783bc0/T-SQL_Training_with_Real_World_ScenariosTricks_of_the_Trade.part1.rar
https://uploadgig.com/file/download/9959c7b78Be12486/T-SQL_Training_with_Real_World_ScenariosTricks_of_the_Trade.part2.rar
Poproshajka




Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.