Learn SQL from Scratch and Be a Master

Complete Study From ZERO to HERO

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