SQL  Server

SQL-T SQL Training

Mail: info@eclasess.com

Mob:9885245722

Services:    Duration: 25 hours

Resume Preparation

Interview Questions and Answers

Real Time Project Explanation

Day 1: INTRODUCTION, INSTALLATION
  • 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

  • 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, Overview SQL Server components

Day 2: SQL BASICS (DONE)
  • How to use SQL Server Management Studio, Connecting to SQL Server

  • Windows Authentication, SQL Server Authentication, System Databases

  • Master database, Msdb DatabaseModel database, Temp Database

  • DDL Commands, Create, Alter, Drop

  • User Defined Database, Create, Alter, Drop a database using SQL script and Tool

Day 3: SQL BASICS AND CONSTRAINTS
  • 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

  • NULL constraint, Primary Key constraint

  • Foreign key constraint, Unique key constraint, Check constraint, Default constraint

Day 3: CLAUSES 
  • From clause, WHERE clause

  • Relational operators and Wild Characters

  • Order By clause

  • Group by clause

  • Having Clause

  • IN clause

  • Between Clause

  • Identity property

Day 5: JOINS
  • Introduction to joins

  • Types of joins

  • Inner join

  • Left outer join

  • Right outer join

  • Full outer join

  • Cross join

  • Self join

Day 6: 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

Day 7: INDEXS
  • Introduction to Indexes

  • Use of Index

  • Types of Index

  • Clustered Index

  • Non Clustered Index

  • Covering Index

  • Column Store Index

Day 8: VIEWS
  • Introduction to Views

  • Catalog Views

  • User defined Views

  • Create Alter and Drop Views

  • Partitioned Views

  • Indexed Views

  • Advantage and Disadvantage of views

Day 9 : CURSORS
  • Dynamic SQL

  • Introduction to Cursors

  • Types of Cursors

  • Advantages of cursors

Day 10: 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

Day 11: TRIGGERS
  • Introduction to triggers

  • Types of triggers

  • Create Alter and Drop a trigger

  • DML Triggers

  • DDL Triggers

  • Logon Triggers

  • Use of Triggers

Day 12: 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

Day 13:  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

Day14 :IMPLEMENTING TRANSACTIONS
  • Commit

  • Roll back

  • Save point

Day 15:
IMPROVING QUERY PERFORMANCE
  • Viewing query execution plans

  • Using SET STATISTICS statements

  • Viewing index usage

coming soon.....

  Contact :9885245722

 

#50, Kamala Nivas, Sap Street Gayatri Nagar, Behind Mytrivanam, Building,Ameerpet, Kumar Basti, Srinivasa Nagar, Ameerpet, Hyderabad, Telangana 500038

  • Facebook - Grey Circle
  • LinkedIn - Grey Circle
Get a quote: 9885245722