MS SQL - Server - DATANALYTICS

0 (0 Ratings)

MS SQL – Server

Download Broucher

Categories Analyst, Development

Wishlist

Course Curriculum

Introduction To DBMS

File Management System And Its Drawbacks

00:00
Database Management System (DBMS) and Data Models

00:00
Physical Data Models

00:00
Logical Data Models

00:00
Hierarchical Data Model (HDBMS)

00:00
Object Data Model (ODBMS)

00:00
Network Data Model (NDBMS)

00:00
Relational Data Model (RDBMS)

00:00
Object Relational Data Model (ORDBMS)

00:00
Conceptual Data Models

00:00
Entity – Relationship (E-R) Model

00:00

Introduction To SQL Server

Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2

00:00
Connecting To Server

00:00
Server Type

00:00
Server Name

00:00
Authentication Modes

00:00
Sql Server Authentication Mode

00:00
Windows Authentication Mode

00:00
Login and Password

00:00
Sql Server Management Studio and Tools In Management Studio

00:00
Object Explorer and its details

00:00
Query Editor

00:00

Introduction To TSQL

History and Features of TSQL

00:00
Types Of TSQL Commands

00:00
Data Definition Language (DDL)

00:00
Data Manipulation Language (DML)

00:00
Data Query Language (DQL)

00:00
Data Control Language (DCL)

00:00
Transaction Control Language (TCL)

00:00
Database

00:00
Creating Database

00:00
Altering Database

00:00
Deleting DataBase

00:00
Constraints

00:00
Procedural Integrity Constraints

00:00
Declarative Integrity Constraints

00:00
Not Null

00:00
Unique

00:00
Default and Check constraints

00:00
Primary Key and Foreign Key constraints

00:00
Data Types in TSQL

00:00
Creating, Altering and Deleting Tables

00:00

Data Manipulation Language

Data Query Language (DQL)

Built In Functions

Scalar functions

00:00
Numeric Functions

00:00
Character Function

00:00
Date Function

00:00
Aggregate Function

00:00
Convenient aggregate function

00:00
Statistical Aggregate Functions

00:00
Super Aggregates

00:00
Over(partition by …) Clause

00:00
Ranking Functions

00:00
Common Table Expressions (CTE)

00:00

Set Operators

Joins

Inner Join

00:00
Equi Join

00:00
Natural Join

00:00
Non-Equi Join

00:00
Self Join

00:00
Outer Join

00:00
Left Outer Join

00:00
Right Outer Join

00:00
Full Outer Join

00:00
Cross Join

00:00

Sub Queries

Indexes

Security

Views

Cursors

Stored Sub Programs

Advantages Of Stored Sub Programs compared to Independent SQL Statements

00:00
Stored procedures

00:00
Creating , Altering and Dropping

00:00
Optional parameters

00:00
Input and Output Parameters

00:00
Permissions on Stored Procedures

00:00
User Defined Functions

00:00
Creating, Altering and Dropping

00:00
Types Of User Defined Functions

00:00
Scalar Functions

00:00
Table Valued Functions

00:00
Inline Table Valued Functions

00:00
Multi Statement Table Valued Functions

00:00
Permissions On User Defined Functions

00:00
Triggers

00:00
Purpose of Triggers

00:00
Differences Between Stored Procedures and User Defined Functions and Triggers

00:00
Creating, Altering and Dropping Triggers

00:00
Magic Tables

00:00
Instead Of Triggers

00:00
Exception Handling

00:00
Adding and removing User Defined Error Messages To And From SQL Server Error

00:00

Working With XML Data Type

Backup and Restore Of Database

Attach and Detach of Database

Normalization

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

Level

Intermediate
Duration

90 hours
Last Updated

October 21, 2024
Certificate

Certificate of completion

A course by

datanalytics@gmail.com

MS SQL – Server

Download Broucher

Course Curriculum

Introduction To DBMS

File Management System And Its Drawbacks

Database Management System (DBMS) and Data Models

Physical Data Models

Logical Data Models

Hierarchical Data Model (HDBMS)

Object Data Model (ODBMS)

Network Data Model (NDBMS)

Relational Data Model (RDBMS)

Object Relational Data Model (ORDBMS)

Conceptual Data Models

Entity – Relationship (E-R) Model

Introduction To SQL Server

Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2

Connecting To Server

Server Type

Server Name

Authentication Modes

Sql Server Authentication Mode

Windows Authentication Mode

Login and Password

Sql Server Management Studio and Tools In Management Studio

Object Explorer and its details

Query Editor

Introduction To TSQL

History and Features of TSQL

Types Of TSQL Commands

Data Definition Language (DDL)

Data Manipulation Language (DML)

Data Query Language (DQL)

Data Control Language (DCL)

Transaction Control Language (TCL)

Database

Creating Database

Altering Database

Deleting DataBase

Constraints

Procedural Integrity Constraints

Declarative Integrity Constraints

Not Null

Unique

Default and Check constraints

Primary Key and Foreign Key constraints

Data Types in TSQL

Creating, Altering and Deleting Tables

Data Manipulation Language

Insert

Identity

Creating A Table From Another Table

Inserting Rows From One Table To Another

Update

Computed Columns

Delete

Truncate

Differences Between Delete and Truncate

Data Query Language (DQL)

Select Clause

Where Clause

Order By Clause

Distinct Keyword

IsNull() function

Column alias

Between and , In, Like, Is Null

Built In Functions

Scalar functions

Numeric Functions

Character Function

Date Function

Aggregate Function

Convenient aggregate function

Statistical Aggregate Functions

Super Aggregates

Over(partition by …) Clause

Ranking Functions

Common Table Expressions (CTE)

Set Operators

Union