SQL -Be a Master- 100% Study-Everything You Need to Know

SQL -Be a Master- 100% Study-Everything You Need to Know | Skillshare
English | Size: 3.30 GB
Genre: eLearning

This course is for everyone who like to be a master in SQL . This course describes more than 150 topics in SQL and it will give you write any SQL queries in basic and complex scenarios.

This course will start from SSMS installation and discuss every main concepts in SQL. So this course is a must one collection for every developers.

This course explains all the concepts with theory and practical explanations

Main Topics explained in this course are as follows

1) How to install SQL Management Studio
2) Connect with SQL Server using SSMS
3) Database idea
4) Tables- Creation and Working with that
5) Default Constraint
5) Cascading Referenctial Integrity
6) Check Constraint
7) Identity Column basics
8) Retrieve Identity Column Value
9) Unique Key Constraint
10) Select Statement Usages
11) Group By
12) Basic Joins
13) Advanced Joins
14) Self Joins
15) How to Replace NULL -Different Ways
16) Coalesce function
17) Union and Union All
18) Stored Procedures
19) Stored Procedures with output parameters
20) Difference between output parameters and return values
21) Stored Procedures – Advantages
22) String Functions
23) Left and Right
24) CharIndex and Substring
25) Replicate,Space,Patindex,
26) Replace and Stuff
27) Datetime Functions
28) IsDate,Day,Month,Year and DateName functions
29) DatePart,DateAdd and DateDiff
30) Convert and Cast
31) Mathematical Functions
32) Scalar User Defined Functions
33) Inline table Valued Functions
34) Multi Statement Table Valued Functions
35) Functions – Some concepts
36) Temporary Tables
37) Indexes
38) Clustered and NonClustered Indexes
39) Unique and Non-Unique Indexes
40) Advantages and disadvantages of indexes
41) Views
42) Updateable Views
43) Indexed Views
44) View Limitations
45) DML Triggers
46) DML After Update Trigger
47) Instead of insert trigger
48) Instead of update trigger
49) Instead of delete trigger
50) Derived table and CTE’s
51) Common Table Expressions
52) Updatable CTE
53) Recursive CTE
54) Normalization & First Normal Form
55) 2NF and 3NF
56) Pivot Operator
57) Error handling in SQL Server 2000
58) Error handling in SQL Server 2005 and later versions
59) Transactions in SQL Server
60) Transaction ACID Tests
61) Subqueries in sql
62) Correlated subquery
63) Creating a large table with random data for performance testing
64) What to choose for performance – SubQuery or Joins
65) Cursors in sql server
66) Replacing cursors using joins
67) List all tables in a sql server database using a query
68) Writing re-runnable sql server scripts
69) Alter database table columns without dropping table
70) Optional parameters in sql server stored procedures
71) Merge in SQL Server
72) SQL Server concurrent transactions
73) SQL Server dirty read example
74) SQL Server lost update problem
75) Non repeatable read example in sql server
76) Phantom reads example in sql server
77) Snapshot isolation level in sql server
78) Read committed snapshot isolation level in sql server
79) Difference between snapshot isolation and read committed snapshot
80) SQL Server deadlock example)
81) SQL Server deadlock victim selection
82) Logging deadlocks in sql server
83) SQL Server deadlock analysis and prevention
84) Capturing deadlocks in sql profiler
85) SQL Server deadlock error handling
86) Handling deadlocks in ado.net
87) Retry logic for deadlock exceptions
88) How to find blocking queries in sql server
89) SQL Server except operator
90) Difference between except and not in sql server
91) Intersect operator in sql server
92) Difference between union intersect and except in sql server
93) Cross apply and outer apply in sql server
94) DDL Triggers in sql server
95) Server-scoped ddl triggers
96) SQL Server trigger execution order
97) Audit table changes in sql server
98) Logon triggers in sql server
99) Select into in sql server
100) Difference between where and having in sql server
101) Table valued parameters in SQL Server
102) Send datatable as parameter to stored procedure
103) Grouping Sets in SQL Server
104) Rollup in SQL Server
105) Cube in SQL Server
106) Difference between cube and rollup in SQL Server
107) Grouping function in SQL Server
108) GROUPING_ID function in SQL Server
109) Debugging sql server stored procedures
110) Over clause in SQL Server
111) Row_Number function in SQL Server
112) Rank and Dense_Rank in SQL Server
113) Difference between rank dense_rank and row_number in SQL
114) Calculate running total in SQL Server 2012
115) NTILE function in SQL Server
116) Lead and Lag functions in SQL Server 2012
117) FIRST_VALUE function in SQL Server
118) Window functions in SQL Server
119) Difference between rows and range
120) LAST_VALUE function in SQL Server
121) UNPIVOT in SQL Server
122) Reverse PIVOT table in SQL Server
123) Choose function in SQL Server
124) IIF function in SQL Server
125) TRY_PARSE function in SQL Server 2012
126) TRY_CONVERT function in SQL Server 2012
127) EOMONTH function in SQL Server 2012
128) DATEFROMPARTS function
129) Difference between DateTime and SmallDateTime in SQL Server
130) DateTime2FromParts function in SQL Server 2012
131) Difference between DateTime and DateTime2 in SQL Server
132) Offset fetch next in SQL Server 2012
133) Identifying object dependencies in SQL Server
134) sys.dm_sql_referencing_entities in SQL Server
135) sp_depends in SQL Server
136) Sequence object in SQL Server 2012
137) Difference between sequence and identity in SQL Server
138) Guid in SQL Server
139) How to check GUID is null or empty in SQL Server
140) Dynamic SQL in SQL Server
141) Implement search web page using ASP.NET and Stored Procedure
142) Implement search web page using ASP.NET and Dynamic SQL
143) Prevent sql injection with dynamic sql
144) Dynamic SQL in Stored Procedure
145) Sql server query plan cache
146) exec vs sp_executesql in sql server
147) Dynamic sql table name variable
148) Quotename function in SQL Server
149) Dynamic SQL vs Stored Procedure
150) Dynamic sql output parameter
151) Temp tables in dynamic sql

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment Cancel reply