محتوى الدورة
Install SQL Server 2019 Step by Step | Developer Edition | Free Software | Install SSMS Connecting to SQL Server using SSMS - Part 1 Creating altering and dropping a database - Part 2 Creating and working with tables - Part 3 Adding a default constraint - Part 4 Cascading referential integrity constraint - Part 5 Adding a check constraint - Part 6 Identity Column in SQL Server - Part 7 How to get the last generated identity column value in SQL Server - Part 8 Unique key constraint - Part 9 Select statement in sql server - Part 10 Group by in sql server - Part 11 Joins in sql server - Part 12 Advanced or intelligent joins in sql server - Part 13 Self join in sql server - Part 14 Different ways to replace NULL in sql server - Part 15 Coalesce function in sql server Part 16 Union and union all in sql server Part 17 Stored procedures in sql server Part 18 Stored procedures with output parameters Part 19 Stored procedure output parameters or return values Part 20 Advantages of stored procedures Part 21 Built in string functions in sql server 2008 Part 22 LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server Part 23 Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008 Part 24 DateTime functions in SQL Server Part 25 IsDate, Day, Month, Year and DateName DateTime functions in SQL Server Part 26 DatePart, DateAdd and DateDiff functions in SQL Server Part 27 Cast and Convert functions in SQL Server Part 28 Mathematical functions in sql server Part 29 Scalar user defined functions in sql server Part 30 Inline table valued functions in sql server Part 31 Multi statement table valued functions in sql server Part 32 Important concepts related to functions in sql server Part 33 Temporary tables in SQL Server Part 34 Indexes in sql server Part 35 Clustered and nonclustered indexes in sql server Part 36 Unique and Non Unique Indexes in sql server Part 37 Advantages and disadvantages of indexes in sql server Part 38 Views in sql server Part 39 Updatable views in sql server Part 40 Indexed views in sql server Part 41 View limitations in sql server Part 42 DML triggers in sql server Part 43 After update trigger Part 44 Instead of insert trigger Part 45 Instead of update triggers in sql server - Part 46.avi Instead of delete triggers in sql server - Part 47.avi Derived tables and common table expressions in sql server Part 48 CTE in sql server Part 49 Updatable common table expressions in sql server Part 50 Recursive CTE in sql server Part 51 Database normalization Part 52 Second normal form and third normal form Part 53 Pivot in sql server 2008 Part 54 Error handling in sql server 2000 Part 55 Error handling in sql server Part 56 Transactions in sql server Part 57 Transactions in sql server and ACID Tests Part 58 Subqueries in sql Part 59 Correlated subquery in sql Part 60 Creating a large table with random data for performance testing Part 61 What to choose for performance SubQuery or Joins Part 62 Cursors in sql server Part 63 Replacing cursors using joins in sql server Part 64 List all tables in a sql server database using a query Part 65 Writing re runnable sql server scripts Part 66 Alter database table columns without dropping table Part 67 Optional parameters in sql server stored procedures Part 68 Part 69 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 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 datatable 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 in SQL Server 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

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك