Best SQL-T SQL Training

SQL DATA

• Data And Database
• What is data
• Types of Data
• How Is Data Collected
• Importance Of Data
• Data Storage
• What is Data Base
• Types of Database
• What is DBMS
• What is RDBMS

INTRODUCTION TO SQL AND SQL SERVER

• What is SQL?
• History of SQL
• Introduction to Microsoft SQL Server
• SQL Server versions And Editions
• Default Instance
• Named Instance
• Starting and Stopping SQL Server Services/li>
• Overview SQL Server components

SQL BASICS

• How to use SQL Server Management Studio
• Connecting to SQL Server
• Windows Authentication
• SQL Server Authentication
• System Databases
• Master database
• Msdb Database
• Model Database
• Temp Database
• DDL Commands
• Create
• Alter
• Drop
• User Defined Database
• Create, Alter, Drop a database using SQL script and Tool

SYSTEM TABLES

• What are system tables?
• Use of system tables
• User Defined Tables
• Create, Alter and Drop a table using SQL Script and Tool
• DQL Command
• Introduction to Select
• DML Commands
• Insert
• Update
• Delete

SQL SERVER CONSTRAINTS

• SQL Server constraints
• NULL constraint
• Primary Key constraint
• Foreign key constraint
• Unique key constraint
• Check constraint
• Default constraint

CLAUSES

• From clause
• WHERE clause
• Relational operators and Wild Characters
• Order By clause
• Group By clause
• Having Clause
• IN Clause
• Between Clause
• Identity property

SQL JOINS

• Introduction to joins
• Types of joins
• Inner join
• Left outer join
• Right outer join
• Full outer join
• Cross join
• Self join

INTO AND UNIONS

• Select Into
• Union All and Union
• Intersect and Except
• Top and Distinct
• Truncate
• Sub queries
• Correlated Sub queries
• Conditional Statements
• If, case, and While loops
• MERGE Statement

INDEXES

• Introduction to Indexes
• Use of Index
• Types of Index
• Clustered Index
• Non Clustered Index
• Covering Index
• Column Store Index

Views

• Introduction to Views
• Catalog Views
• User defined Views
• Create Alter and Drop Views
• Partitioned Views
• Indexed Views
• Advantage and Disadvantage of views

SQL CURSORS

• Dynamic SQL
• Introduction to Cursors
• Types of Cursors
• Advantages of cursors

FUNCTIONS

• Introduction to functions
• Built in functions
• Aggregate functions
• String functions
• Date functions
• Ranking functions
• User defined functions
• Create Alter and Drop functions
• Scalar Functions
• Inline table valued functions
• Multi statement Table valued functions
• Uses of functions

TRIGGERS

• Introduction to triggers
• Types of triggers
• Create Alter and Drop a trigger
• DML Triggers
• DDL Triggers
• Logon Triggers
• Use of Triggers

STORED PROCEDURES

• Declare and Set commands
• System stored procedures
• User defined stored procedures
• Create Alter and Drop Stored Procedures
• Executing Stored Procedures
• Grant and Revoke Permissions to Stored Procedures
• Input and output parameters
• Capturing the stored procedure output
• Advantages of Stored Procedures

Implementing Error Handling

• Redirecting errors with TRY/CATCH
• Creating error handling routines in a CATCH block with ERROR functions
• Using THROW to pass an error message back to a client

Implementing Transactions

• Commit
• Roll back
• Save point

Improving Query Performance

• Viewing query execution plans
• Using SET STATISTICS statements
• Viewing index usage