Excellent		3 Reviews
Good		6 Reviews
medium		1 Reviews
Acceptable		1 Reviews
Not Good		0 Reviews

تحميل SQL Server for beginners

Programming 2022-02-12

روابط التحميل

لمشاهدة الكورس مباشر بدون تحميل اضغط هنا

عدد الدروس 150

قسم Programming

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

Programming
2022-02-12