Duration of the Course
- 30 Hrs
SQL Server Online Training Course Overview
Introduction to Data Store
- What is a Database?
- Data Storing in Different ways
- Books and Papers
- Data Files
- Datab
Introduction to DBMS
- Introduction to RDBMS
- Understanding CODD rules
- Understanding SEQUEL
Introduction to SQL Server
- What is the difference between SQL Server 2005 and 2008?
- Data Definition Language
- Data Manipulation Language
Constraints in SQL Server
- Not Null
- Unique
- Primary key
- Check
- Referential Integrity
- Self-Referential Integrity
Functions in SQL Server
- How to use the functions in SQL Server?
- Single Row Functions
- Group Function
Operators in SQL Server
- How many operators used in SQL Server
- Conditional operator
- Logical operator
- Set operator
Clauses in SQL Server
- Where
- Group by
- Having
- Order by
Additional Queries
- What is a sub Query?
- Building a Nested Sub Query
- Nested Queries Using Single-Value SELECT Statements
- Nested Queries Using Sub Queries That Return Multiple Values
Correlated Sub-Queries
- How Correlated Sub-Queries Work
- Correlated Sub-Queries in the where Clause
- Correlated Sub-Queries in the select List
SQL Joins
- Inner Join
- Self-Join
- Outer Join
- Cross-Join
Transaction Control Language
- Creating tables from existing table
- Indexes
- Functions
- Procedures
- Triggers
- Cursors
- Views
- Managing Security with Data Control Language
- User creation
- Controlling the permission by grant, revoke and Deny
- Disadvantages of SQL and Introduction to T-SQL
Indexes
- Clustered Index
- Non-Clustered Index
Functions
- System-Defined Functions
- User-Defined Functions
- Scalar Function
- Inline Table-valued Function
- Multi-Statement Table-Valued Function
Triggers
- DML Triggers
- DDL Triggers
Cursors
- Understanding the Cursors
- Types of Cursors
Visit for SQL Server Online Training