SQL SERVER TRAINING COURSE CONTENTS

dwnld

SQL Server Training Course Details

SQL SERVER Training In Pune & MSBI Training In Vishrantwadi

ENOSIS LEARNING provides real-time and placement focused ms sql server training in pune . Our microsoft sql Server course includes basic to advanced level and our ms sql server course is designed to get the placement in good MNC companies in pune as quickly as once you complete the microsoft sql server administration certification training course. Our ms sql server trainers are microsoft sql Server 2008 2010 2012 certified experts and 6 years experienced working professionals with hands on real time multiple MS SQL Server projects knowledge. We have designed our ms sql server course content and syllabus based on students requirement to achieve everyone's career goal.

ENOSIS LEARNING offers ms sql server training with choice of multiple training locations across pune. Our microsoft sql Server training centers are equipped with lab facilities and excellent infrastructure. We also provide microsoft sql Server certification training path for our students in pune. Through our associated ms sql server training centers, we have trained more than ms sql server students and provided placement. Our microsoft sql Server course fee is value for money and tailor-made course fee based on the each student's training requirements. ms sql server training in pune conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.

Program Objectives

  • By the end of this course you will be aware of all the techniques and processes that improves your efficiency, skills and confidence to jump start into the field of Software Testing.
  • Best material and certification guidance.
  • SQL commands Preparation for the interviews.
  • Mock Interviews will be conducted on one-to-one basis during the completion of each major topic including final interview at the end of the course duration.
  • Complete Support in assignments, even after the course is completed.

Enosis Learning Advantage

  • Trainer having more than 14 Years of experience in MS SQL Server
  • Trained 1000+ Students so far.
  • Strong Theoretical & Practical Knowledge
  • MS SQL Server certified Professionals
  • Certified Trainers from the IT industry with rigorous understanding of specialized domain.
  • Lecture contents prepared by Industry expert
  • Live Projects to work on with IT industry standards.
  • Focus on cross cultural and various onshore and offshore client oriented trainings
  • Workshops on Advanced Topics
  • An innovative teaching methodology delivers in- depth knowledge with quality tailored programs that maximize a return on your investment.
  • Strategic Association for global certification

Program Structure

The course will have regular classroom Lectures, Practical Sessions, Seminars, Tutorials, Case Studies, Assignments and Exams.

Syllabus

INTRODUCTION

  • What is SQL Server?
  • Architecture of SQL Server
  • SQL Server Editions
  • Installing SQL Server
  • Sql Server Instances
  • Internal of SQL Server Database
  • MDF & LDF Files

Basic of Database Design

  • Normalization
  • Denormalization
  • Introduction to SQL Sever Management Studio
  • Creating Database
  • Data Types
  • Designing Table Model
  • Creating Tables
  • Alteration of Table Design
  • Drop Table

WRITING QUERIES

  • Insert queries
  • UPDATE queries
  • DELETE queries
  • TRUNCATE
  • The SELECT Clause
  • The FROM Clause
  • The WHERE Clause
  • Mathematical Operator
  • Conditional Operators
  • AND , OR Operators
  • Like Operators
  • The ORDER BY Clause
  • Aggregate Functions
  • String Functions
  • Date Functions
  • Using GROUP BY and HAVING
  • Using TOP N and TOP N PERCENT

Constraint in SQL SERVER

  • What is Constraint
  • Adding constraints to columns in Tables
  • Primary Key Constraints
  • Unique Constraints
  • Check Constraints
  • Default
  • Alter Constraints
  • Drop Constraints

Relational Database

  • Introduction to RDBMS
  • Why Relational Model
  • Advantages of Relational Model
  • Master Table & Child Tables
  • Introduction to Foreign Key
  • Creating Relations between tables

JOINS IN SQL SERVER

  • Introduction to Joins
  • Types of Joins
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Self-Join
  • Writing Joins queries
  • APPLYING CLAUSES USING JOINS

Advanced SQL QUERIES

  • OFFSET & FETCH
  • SELECT INTO queries
  • SUB-QUERIES
  • UNION
  • INTERSECT
  • EXCEPT
  • ROW_NUMBER
  • RANK
  • CUBE & ROLLUP

T-SQL

  • What is T-SQL?
  • Syntax Conventions
  • Executing SQL Statements
  • Identifiers
  • Operators
  • Variables
  • Using T-SQL to Build and Alter Objects
  • If – else statements
  • Case statements
  • Looping statements
  • Identity statements

Stored Procedures, Functions

  • Introduction to Stored Procedures
  • Writing Stored Procedures
  • Alteration of Processing
  • Using/Calling Procedures
  • Using Input & Output Parameters
  • Advantage of Stored Procedures
  • Introduction to Functions
  • Writing Functions
  • Types of functions
  • Scalar Functions
  • Table Value Functions
  • Comparison between Stored Procedures & Functions

Triggers

  • Introduction to Triggers
  • Creating DML Triggers
  • Altering DML Triggers
  • Types of Trigger
  • Instead of Triggers
  • After Triggers
  • Using the Inserted and Deleted Tables
  • Auditing Data using Triggers

Types of Tables in SQL SERVER

  • Temp Tables
  • Local Temp Table
  • Global Temp Table
  • CTE
  • Table Variables
  • Comparison between Temp Tables, CTE & Table Variables

Views

  • Introduction to Views
  • Creating Views
  • Alteration of Views
  • Types of Views

Indexes

  • Introduction to Indexes
  • Types of Indexes
  • Creating Indexes
  • Best Practices of Indexes Creation

Cursors

  • Introduction to Cursors
  • Types of Cursors
  • Creating Cursors

Advanced SQL-SERVER

  • Temporary Tables
  • Table Variables
  • Error Handling
  • Transactions
  • Authentication Modes in SQL SERVER
  • Creating Users
  • Backup
  • Types of Backups
  • Restore
  • Shrinking
  • Email configuration in SQL SERVER.
  • Creating Operators
  • Automating Tasks using Jobs
  • Fragmentation
  • Query Optimization Techniques
  • Execution Plan of SQL SERVER
  • Query Lifecycle
  • Execution Lifecycle of a query