About this course
Koorsadan waxaad si waafi ah uga bogan doontaa qaabka loo isticmaalo mid kamid ah softiweerada loogu adeegsiga badan yahay marka ay timaaddo xog-maamulidda (Data Manipulation) inaga oo adeegsanayna SQL Server 2019, waxaanad ku baran doontaa qaybaha kala duwan ee loo isticmaalo softiweerkan.
Comments (0)
Introduction
2 Parts
Introduction to SQL
-
SQL Server Data Types
-
Installation
2 Parts
INSTALLATION AND CONNECTION SSMS INTO SERVER
-
SQL Server Data Types
-
SQL Commands
7 Parts
Creating Databases and Tables
-
Insert
-
Select
-
Update
-
Alter
-
Rename
-
Drop , Truncate , Delete
-
Column Identity
1 Parts
Identity
-
Aggregate Functions
1 Parts
SUM , COUNT , AVG , MAX , MIN Functions
-
Distinct Keyword
1 Parts
Distinct Key
-
Set Operators
2 Parts
Union and Union All
-
Intersect and Except
-
Constraints
6 Parts
Unique
-
Not Null
-
Check Constraint
-
Primary Key
-
Default
-
Foreign Key
-
Order By
1 Parts
Order by Clause
-
Operators
4 Parts
Between vs Like Operators
-
Or vs And Operators
-
In vs Not In Operators
-
Percentage Operator
-
Group By Clause
1 Parts
Group By
-
Joins
6 Parts
Left Outer Join
-
Right Outer Join
-
Full Outer Join
-
Inner Join
-
Cross Join
-
Self Join
-
Using Where Clause
1 Parts
Where Clause
-
View Table
2 Parts
View Table
-
Complex View
-
Transaction Commands
1 Parts
Rollback , Commit , SavePoint
-
Procedures
2 Parts
Stored Procedure
-
Stored Procedure with Parameter
-
Indexes
2 Parts
Index
-
Clustered vs Non - Clustered Index
-
Backup and Restore
1 Parts
Creating backup and Restoring Databases
-
0
0 Reviews
.png)
