MP4 | h264, 1280×720 | Lang: English | Audio: aac, 44100 Hz | 9h 18m | 2.92 GB
What you’ll learn
SQL Basics and Advanced Concepts
Requirements
No
Description
This Course covers everything from basics to medium and advanced topics. You don’t need to have basic knowledge in SQL. we teach you everything. We explain each topic with theory and practical explanations. We start from installation and go through every topic that makes you strengthen your knowledge
Some topics covered in this session are
How to install SQL Management Studio
Connect with SQL Server using SSMS
Database idea
Tables- Creation and Working with that
Default Constraint
Cascading Referential Integrity
Check Constraint
Identity Column basics
Retrieve Identity Column Value
Unique Key Constraint
Select Statement Usages
Group By
Basic Joins
Advanced Joins
Self Joins
How to Replace NULL -Different Ways
Coalesce function
Union and Union All
Stored Procedures
Stored Procedures with output parameters
Difference between output parameters and return values
Stored Procedures – Advantages
String Functions
Left and Right
CharIndex and Substring
Replicate,Space,Patindex,
Replace and Stuff
Datetime Functions
IsDate,Day,Month,Year and DateName functions
DatePart,DateAdd and DateDiff
Convert and Cast
Mathematical Functions
Scalar User Defined Functions
Inline table Valued Functions
Multi Statement Table Valued Functions
Functions – Some concepts
Temporary Tables
Indexes
Clustered and Non Clustered Indexes
Unique and Non-Unique Indexes
Advantages and disadvantages of indexes
Views
Updateable Views
Indexed Views
View Limitations
DML Triggers
DML After Update Trigger
Instead of insert trigger
Instead of update trigger
Instead of delete trigger
Derived table and CTE’s
Common Table Expressions
Updatable CTE
Recursive CTE
Normalization & First Normal Form
2NF and 3NF
Pivot Operator
Error handling in SQL Server 2000
Error handling in SQL Server 2005 and later versions
Transactions in SQL Server
Transaction ACID Tests
Subqueries in SQL
Correlated subquery
Creating a large table with random data for performance testing
What to choose for performance – Subquery or Joins
Cursors in SQL Server
Replacing cursors using joins
List all tables in a SQL Server database using a query
Writing re-runnable SQL Server scripts
Alter database table columns without dropping table
Optional parameters in SQL Server stored procedures
Merge in SQL Server
SQL Server concurrent transactions
SQL Server dirty read example
SQL Server lost update problem
Non repeatable read example in SQL Server
Phantom reads example in SQL Server
Snapshot isolation level in SQL Server
Read committed snapshot isolation level in SQL Server
Difference between snapshot isolation and read committed snapshot
SQL Server deadlock example)
SQL Server deadlock victim selection
Logging deadlocks in SQL Server
SQL Server deadlock analysis and prevention
Capturing deadlocks in SQL profiler
SQL Server deadlock error handling
Handling deadlocks in ado dot net
Retry logic for deadlock exceptions
How to find blocking queries in SQL Server
SQL Server except operator
Difference between except and not in SQL Server
Intersect operator in SQL Server
Difference between union intersect and except in SQL Server
Cross apply and outer apply in SQL Server
DDL Triggers in SQL Server
Server-scoped DDL triggers
SQL Server trigger execution order
Audit table changes in SQL Server
Logon triggers in SQL Server
Select into in SQL Server
Difference between where and having in SQL Server
Table valued parameters in SQL Server
Send data table as parameter to stored procedure
Grouping Sets in SQL Server
Rollup in SQL Server
Cube in SQL Server
Difference between cube and rollup in SQL Server
Grouping function in SQL Server
GROUPING_ID function in SQL Server
Debugging SQL Server stored procedures
Over clause in SQL Server
Row_Number function in SQL Server
Rank and Dense_Rank in SQL Server
Difference between rank dense_rank and row_number in SQL
Calculate running total in SQL Server 2012
NTILE function in SQL Server
Lead and Lag functions in SQL Server 2012
FIRST_VALUE function in SQL Server
Window functions in SQL Server
Difference between rows and range
LAST_VALUE function in SQL Server
UNPIVOT in SQL Server
Reverse PIVOT table in SQL Server
Choose function in SQL Server
IIF function in SQL Server
TRY_PARSE function in SQL Server 2012
TRY_CONVERT function in SQL Server 2012
EOMONTH function in SQL Server 2012
DATEFROMPARTS function
Difference between DateTime and SmallDateTime in SQL Server
DateTime2FromParts function in SQL Server 2012
Difference between DateTime and DateTime2 in SQL Server
Offset fetch next in SQL Server 2012
Identifying object dependencies in SQL Server
sys dm_sql_referencing_entities in SQL Server
sp_depends in SQL Server
Sequence object in SQL Server 2012
Difference between sequence and identity in SQL Server
GUID in SQL Server
How to check GUID is null or empty in SQL Server
Dynamic SQL in SQL Server
Implement search web page using ASP.NET and Stored Procedure
Implement search web page using ASP.NET and Dynamic SQL
Prevent SQL injection with dynamic SQL
Dynamic SQL in Stored Procedure
SQL Server query plan cache
exec vs sp_executesql in SQL Server
Dynamic sql table name variable
Quotename function in SQL Server
Dynamic SQL vs Stored Procedure
Dynamic sql output parameter
Temp tables in dynamic SQL
Who this course is for:
Any Students who like to be a Master in SQL
Password/解压密码0daydown
Download rapidgator
https://rg.to/file/b7655c25f7071306a9b340e58068e6ac/Learn_SQL_from_Scratch_and_Be_a_Master.part1.rar.html
https://rg.to/file/1bad4eff07d48bfa682e3fe4cc8ffb3d/Learn_SQL_from_Scratch_and_Be_a_Master.part2.rar.html
https://rg.to/file/ea36eb55b621f912471de229c15d9ebf/Learn_SQL_from_Scratch_and_Be_a_Master.part3.rar.html
https://rg.to/file/7c30cfcdfab23fd1d1635b44a75b3eb2/Learn_SQL_from_Scratch_and_Be_a_Master.part4.rar.html
https://rg.to/file/0a0dc5d854fd2b7bd78030b296fb4043/Learn_SQL_from_Scratch_and_Be_a_Master.part5.rar.html
Download nitroflare
https://nitroflare.com/view/60289346544354A/Learn_SQL_from_Scratch_and_Be_a_Master.part1.rar
https://nitroflare.com/view/A454FF3708356E8/Learn_SQL_from_Scratch_and_Be_a_Master.part2.rar
https://nitroflare.com/view/861F331391D6657/Learn_SQL_from_Scratch_and_Be_a_Master.part3.rar
https://nitroflare.com/view/94AA4F4A69FA065/Learn_SQL_from_Scratch_and_Be_a_Master.part4.rar
https://nitroflare.com/view/42E23FA97D114FC/Learn_SQL_from_Scratch_and_Be_a_Master.part5.rar