4 Weeks SQL Server training for Beginners is being delivered from April 6, 2020 - April 29, 2020 for 16 hours over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.
4 Weeks SQL Server Training Schedule
Features and Benefits
None
Course Objectives
1. Introduction to DBMS
File Management System And Its Drawbacks
Database Management System (DBMS) and Data Models
Physical Data Models
Logical Data Models
Conceptual Data Models
Entity – Relationship (E-R) Model
2. Introduction to SQL Server
Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
Connecting To Server
3. TSQL (Transact-Structured Query Language)
1) 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
2) Data Manipulation Language
Insert
Identity
Creating A Table From Another Table
Inserting Rows From One Table To Another
Update
3) Data Query Language (DQL)
Select
Where clause
Order By Clause
Distinct Keyword
Isnull() function
Column aliases
Predicates
Between … And
In
Like
Is Null
4) Built In Functions
Scalar Functions
Numeric Functions
Character Functions
Conversion Functions
Date Functions
Aggregate Functions
5) Top n Clause
6) Set Operators
Union
Intersect
Except
7) Joins
Inner Join
Equi Join
Natural Join
Non-Equi Join
Self Join
Outer Join
8) Sub Queries
Single Row Sub Queries
Multi Row Sub Queries
Any or Some
ALL
Nested Sub Queries
Co-Related Sub Queries
9) Indexes
Clustered Index
NonClustered Index
Create , Alter and Drop Indexes
Using Indexes
10) Security
Login Creation
SQL Server Authenticated Login
Windows Authenticated Login
User Creation
Granting Permissions
Revoking Permissions
Roles
11) Views
Purpose Of Views
Creating , Altering and Dropping Indexes
Simple and Complex Views
Encryption and Schema Binding Options in creating views
12) Transaction Management
Introduction
Begin Transaction
Commit Transaction
Rollback Transaction
Save Transaction
Role Of Log File In Transaction Management
Implicit Transactions
13) T-SQL Programming
Drawbacks Of TSQL that leads to TSQL Programming
Introduction To TSQL Programming
Control statements In TSQL Programming
Conditional Control Statements
Looping Control Statements
While
14) Cursors
Working With Cursors
Types Of Cursors
Forward_Only and Scroll Cursors
Static, Dynamic and Keyset Cursors
Local and Global Cursors
15) Stored Sub Programs
Advantages Of Stored Sub Programs compared to Independent SQL Statements
Stored Procedures
Creating , Altering and Dropping
Optional Parameters
Input and Output Parameters
Permissions on Stored Procedures
User Defined Functions
Creating, Altering and Dropping
Types Of User Defined Functions
Triggers
Purpose of Triggers
Differences Between Stored Procedures and User Defined Functions and Triggers
Creating, Altering and Dropping Triggers
Magic Tables
Instead Of Triggers
Exception Handling
Implementing Exception Handling
Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
Raising Exceptions Manual
16) CLR Integration
What is CLR Integration and The Steps For Implementing It
A Simple Example With CLR Integration
17) Working With XML Data Type
18) Backup and Restore Of Database
19) Attach and Detach of Database
20) Normalization