This SQL training is prepared for beginners/professionals to help them understand the basic as well as the advanced concepts related to MS SQL languages.
This training will give you enough understanding on the various components of SQL along with suitable examples
MS SQL Server Training Course Pre-Requisite
Before you will start practicing with various types of examples given in this training. I am assuming that you are already aware about what a database is, especially the RDBMS and what is a computer programming language.
What is SQL?
SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.
SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.
Also, they are using different dialects, such as −
MS SQL Server using T-SQL,
Oracle using PL/SQL,
MS Access version of SQL is called JET SQL (native format) etc.
Why SQL?
SQL is widely popular because it offers the following advantages −
Allows users to access data in the relational database management systems.
Allows users to describe the data.
Allows users to define the data in a database and manipulate that data.
Allows embedding within other languages using SQL modules, libraries & pre-compilers.
Allows users to create and drop databases and tables.
Allows users to create view, stored procedure, functions in a database.
Allows users to set permissions on tables, procedures and views.
MS SQL SERVER COURSE CONTENT
COURSE OBJECTIVE
Learn Database models
Overview of MS SQL Server Management Studio and Transact-SQL language
Master writing simple and complex queries that retrieve data from the database
Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
Insert, update, and delete data
Retrieve data from tables
Joins
Sub-queries
Working with Data Types
Procedure and Functions
Understand the different Views
Working with Triggers
Design a database
Maintain databases, tables, and sequences with SQL statements
Create and manage views
Ensure the integrity of multiple, related database updates by using transactions
Retrieve data using cursors
Manage binary data using BLOBs
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)
Network Data Model (NDBMS)
Relational Data Model (RDBMS)
Object Data Model (ODBMS)
Object Relational Data Model (ORDBMS) Conceptual Data Models
Entity – Relationship (E-R) Model
INTRODUCTION TO MS SQL Server
Advantages and Drawbacks Of MS SQL Server Compared To Oracle And DB2
Connecting To Server
Server Type
Server Name
Authentication Modes
MS SQL Server Authentication Mode
Windows Authentication Mode
Login and Password
MS SQL Server Management Studio and Tools In Management Studio
Object Explorer
Object Explorer Details
Query Editor
TSQL (TRANSACT-STRUCTURED QUERY LANGUAGE) | 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
Constrains
Procedural Integrity Constraints
Declarative Integrity Constraints
Not Null, Unique, Default and Check constraints
Primary Key and Referential Integrity or foreign key constraints
Data Types In TSQL
Table
Creating Table
Altering Table
Deleting Table
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
Where clause
Order By Clause
Distinct Keyword
Isnull() function
Column aliases
Predicates
Between … And
In
Like
Is Null
BUILT IN FUNCTIONS
Scalar Functions
Numeric Functions
Character Functions
Conversion Functions
Date Functions
Aggregate Functions
Convenient Aggregate Functions
Statistical Aggregate Functions
Group By and Having Clauses
Super Aggregates
Over(partition by …) Clause
Ranking Functions
Common Table Expressions (CTE)
TOP N CLAUSE | SET OPERATORS
Union
Intersect
Except
JOINS
Inner Join
Equi Join
Natural Join
Non-Equi Join
Self Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
SUB QUERIES
Single Row Sub Queries
Multi Row Sub Queries
Any or Some
ALL
Nested Sub Queries
Co-Related Sub Queries
Exists and Not Exists
INDEXES
Clustered Index
NonClustered Index
Create , Alter and Drop Indexes
Using Indexes
SECURITY
Login Creation
MS SQL Server Authenticated Login
Windows Authenticated Login
User Creation
Granting Permissions
Revoking Permissions
Roles
VIEWS
Purpose Of Views
Creating , Altering and Dropping Indexes
Simple and Complex Views
Encryption and Schema Binding Options in creating views
TRANSACTION MANAGEMENT
Introduction
Begin Transaction
Commit Transaction
Rollback Transaction
Save Transaction
Role Of Log File In Transaction Management
Implicit Transactions
TSQL PROGRAMMING
Drawbacks Of TSQL that leads to TSQL Programming
Introduction To TSQL Programming
Control statements In TSQL Programming
Conditional Control Statements
If
Case Looping Control Statements
While
CURSORS
Working With Cursors
Types Of Cursors
Forward_Only and Scroll Cursors
Static, Dynamic and Keyset Cursors
Local and Global Cursors
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
Scalar Functions
Table Valued Functions
Inline Table Valued Functions
Multi Statement Table Valued Functions
Permissions On 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 MS SQL Server Error Messages List
" I had a wonderful learning experience. Classes are scheduled well on time. Course is taught as per the content. Teachers are well qualified. Best training experience !!. I will recommend 'EduGrowUP'. "
SANJAY
" 'EduGrowUP' is the Best .NET training. EduGrowUP training has finest .NET trainers. I did my .NET placement training. I will recommend 'EduGrowUP' training for others. "
SUMANT
" I attended ASP.NET C# training by Vivek Sir, it was good. He covers each and every topic in depth with real time examples. I appreciate his effort in making the course interesting. Thanks a lot... "
NEHA
" I have been meaning to write and thank you for the days training you delivered. I learned ASP.NET C# from 'EduGrowUP' and it was really a very good course and a great learning training session. "
AMIT
" The training was excellent and the teaching was excellent from the Vivek Sir. Vivek Sir having the expert level knowledge and he having the capability to answer the questions for the candidates. "
DIKSHA
" I am Jaydev P from Delhi. I got admission in ASP.NET training course in EduGrowUP training institute. I would like to say that it is the first-rate institute. Thank you EduGrowUP!!. "
JAYDEV PANCHAL
" I am also getting training from this institute. Faculties are professional they have real time and industry oriented experience. I recommended to others who are ready to get training and job. "
AMIT KUMAR
" This is one of the best platform to achieve your goal.Teachers have awesome knowledge to make you sharp and confident and develop a positive thought about your goal... "
ABHISHEK MISHRA
" Hi guys!!! I am Gulshan from Nangloi. By my friends reference I took admission in EduGrowUP training institute. Truly very good institute, now I am working in a MNC Company. "
GULSHAN SHARMA
" I had a wonderful learning experience. Classes are scheduled well on time. Course is taught as per the content. Teachers are well qualified. Best training experience !!. I will recommend 'EduGrowUP'. "
SANJAY
" 'EduGrowUP' is the Best .NET training. EduGrowUP training has finest .NET trainers. I did my .NET placement training. I will recommend 'EduGrowUP' training for others. "
SUMANT
" I attended ASP.NET C# training by Vivek Sir, it was good. He covers each and every topic in depth with real time examples. I appreciate his effort in making the course interesting. Thanks a lot... "
NEHA
" I have been meaning to write and thank you for the days training you delivered. I learned ASP.NET C# from 'EduGrowUP' and it was really a very good course and a great learning training session. "
AMIT
" The training was excellent and the teaching was excellent from the Vivek Sir. Vivek Sir having the expert level knowledge and he having the capability to answer the questions for the candidates. "
DIKSHA
" I am Jaydev P from Delhi. I got admission in ASP.NET training course in EduGrowUP training institute. I would like to say that it is the first-rate institute. Thank you EduGrowUP!!. "
JAYDEV PANCHAL
" I am also getting training from this institute. Faculties are professional they have real time and industry oriented experience. I recommended to others who are ready to get training and job. "
AMIT KUMAR
" This is one of the best platform to achieve your goal.Teachers have awesome knowledge to make you sharp and confident and develop a positive thought about your goal... "
ABHISHEK MISHRA
" Hi guys!!! I am Gulshan from Nangloi. By my friends reference I took admission in EduGrowUP training institute. Truly very good institute, now I am working in a MNC Company. "
GULSHAN SHARMA
" I had a wonderful learning experience. Classes are scheduled well on time. Course is taught as per the content. Teachers are well qualified. Best training experience !!. I will recommend 'EduGrowUP'. "