Summer Training
&
Jobs
تدريب صيفي - وظائف
انشاء حساب / دخول
المدونة
الدورات
إسلاميات
وظائف
تدريب صيفي
منح
بودكاست
الرئيسية
دورات تدريبية
IT Infrastructure & Security
SQL Server 2019 Full Beginner Course – Install, Connect & Build Databases
محتوى الدورة
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- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك
بحث
×