BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

bestwaytechnologies@gmail.com

SQL Server 2014 Training


We are Provides SQL SERVER 2014 Online Training in India with Real time working Professionals.

SQL SERVER 2014 Course Content

INTRODUCTION

  • What is a Database?
  • Database Architectures
  • SQL Server 2014 Architecture
  • Editions of SQL Server 2014
  • Installing SQL Server 2014
  • Tools and utilities in SQL Server 2014

CREATING AND MANAGING DATABASES

  • Data Storage
  • System Databases
  • Creating User-defined Databases
  • Working with Databases

SQL-The Structured Query Language

WORKING WITH TABLES

  • Types of Tables
  • Creating and Using tables
  • Using INSERT,UPDATE and DELETE
  • Differences between DELETE and TRUNCATE
  • Creating and using Partitioned Tables

DATA INTEGRITY

  • What is Data Integrity?
  • Types of Integrity Constraints
  • Enabling and Disabling Constraints
  • Rules and Defaults

RETRIEVING DATA

  • SELECT Statement
  • Using WHERE Clause
  • Using GROUP BY Clause
  • Using HAVING Clause
  • ORDER BY Clause
  • Creating a Copy Table

RETRIEVING DATA – ADVANCED

  • What is a sub query?
  • Types of Sub Queries
  • Working with CORRELATED SUBQUERIES

JOINS

  • What is a Join?
  • Types of Joins
  • Inner Join
  • Outer Joins
  • Cross Join
  • Self Join
  • Alternate syntax for joins
  • Complex Joins

BUILT-IN FUNCTIONS

  • Aggregate Functions
  • Numeric Functions
  • Date and Time Functions
  • String Functions
  • CAST and CONVERT

 

ADVANCED QUERIES

  • Operators
  • LIKE, IN, ANY, BETWEEN, UNION ALL, UNION, INTERSECT,EXIST
  • TOP and OFFSET – FETCH Filters
  • Working with CTE’s
  • Using Rank,Dense_Rank Functions
  • Using PIVOT and UNPIVOT

 

VIEWS

  • What is a View?
  • Creating and using Views
  • Using Schemabinding and Encryption
  • Materialized Views

 

NORMALIZATION

  • What is Normalization?
  • Normal Forms
  • Advantages and Disadvantages
  • Denormalization

 

T-SQL PROGRAMMING

INTRODUCTION

  • Fundamentals
  • Control-of-flow Language Statements
  • Scripts and Batches

 

TRANSACTIONS

  • ACID Properties
  • Types of Transactions
  • COMMIT, ROLLBACK, SAVE

 

STORED PROCEDURES

  • Definition
  • Types of Stored Procedures
  • Creating a Stored Procedure
  • Input and Output Parameters
  • Executing a Stored Procedure
  • Error Handling in Stored Procedures
  • Debugging a Stored Procedure

 

TRIGGERS

  • Definition
  • Creating a Trigger
  • Types of Triggers
  • DDL Triggers
  • DML Triggers
  • INSTEAD OF Triggers
  • Setting Triggering Order

 

USER-DEFINED FUNCTIONS

  • What is a UDF?
  • Creating and using UDF’s
  • UDF’s returning a table

 

CURSORS

  • What is a Cursor?
  • Types of Cursors
  • Statements in the usage of a Cursor
  • Using @@FETCH_STATUS

 

SECURITY

  • Security Basics
  • Authentication Modes
  • Creating a login
  • Providing permissions on a database
  • Providing permissions on database objects

 

PERFORMANCE TUNING

  • Tuning Queries
  • When to Tune?
  • Strategies in Tuning
  • Evaluating Query Performance
  • Tuning Query Performance
  • Finding out which queries to Tune
  • Working with Indexes
  • Index Uses
  • Types of Indexes
  • Creating Indexes
  • Index Fragmentation
  • Tuning Indexes

 

XML INTEGRATION

  • XML Datatype
  • Retrieve Related Data as XML
  • Transform XML data into Relational Data
  • Query XML Data

 

EXTENDING SQL SERVER

FUNCTIONALITIES

  • Using SQLCLR and FileStreams
  • Implementing Spacial Datatypes
  • Distributed Queries
  • Backup & Restoring Databases

INTERVIEW BASED FAQ’s

 

  • Request Demo

  • Add Your Review