Microsoft SQL Server 2019

About 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.

Course Content

Introduction

Introduction to SQL
09:00
SQL Server Data Types
10:00

Installation

SQL Commands

Column Identity

Aggregate Functions

Distinct Keyword

Set Operators

Constraints

Order By

Operators

Group By Clause

Joins

Using Where Clause

View Table

Transaction Commands

Procedures

Indexes

Backup and Restore

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction

Introduction to SQL

SQL Server Data Types

Installation

INSTALLATION AND CONNECTION SSMS INTO SERVER

SQL Server Data Types

SQL Commands

Creating Databases and Tables

Insert

Select

Update

Alter

Rename

Drop , Truncate , Delete

Column Identity

Identity

Aggregate Functions

SUM , COUNT , AVG , MAX , MIN Functions

Distinct Keyword

Distinct Key

Set Operators

Union and Union All

Intersect and Except

Constraints

Unique

Not Null

Check Constraint

Primary Key

Default

Foreign Key

Order By

Order by Clause

Operators

Between vs Like Operators

Or vs And Operators

In vs Not In Operators

Percentage Operator

Group By Clause

Group By

Joins

Left Outer Join

Right Outer Join

Full Outer Join

Inner Join

Cross Join

Self Join

Using Where Clause

Where Clause

View Table

View Table

Complex View

Transaction Commands

Rollback , Commit , SavePoint

Procedures

Stored Procedure

Stored Procedure with Parameter

Indexes

Index

Clustered vs Non – Clustered Index

Backup and Restore

Creating backup and Restoring Databases

Student Ratings & Reviews

Quick Links

Legal