الصفحة الرئيسية
من نحن
إتصل بنا
جميع الدورات
- - أنظمة التشغيل
  - BackTrack
  - Kali Linux
  - لغات البرمجة
  - C plus plus
  - python
  - pascal
  - Vb.net
  - java
  - تصفح جميع التصنيفات
- - قواعد البيانات
  - JSON
  - SQLite
  - MySQL
  - SQL Server
  - برمجة الألعاب
  - Unity
- - هاردوير
  - laptop hardware
  - mobile hardware
  - Arduino
  - شبكات الحاسوب
  - CCNP
  - CCIE
  - CCNA
- - برمجة الويب
  - CSS
  - wordpress development
  - PHP
  - JavaScript
  - AngularJS
  - HTML
  - CSS3
  - ASP.NET
  - HTML5

SQL Server tutorial for beginners (15) طالب ملتحق

معلومات الكورس

Category: SQL Server
Videos Number: 91
Language: English
Instructor: kudvenkat
Rating:

SQL Server tutorial for beginners (15) طالب ملتحق

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