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
Best SQL-T SQL Training in Hyderabad

Preview this course

  • Duration 25 Hours
  • Students 21
  • Days 40 Days
  • Resume Preparation Yes
  • Interview Guidance Yes