Expertizing SQL Server

Having an edge over others is something everybody vies for professionally if not personally. Being an IT professional, you would have to update yourself constantly so as to be conversant with the latest development in the platforms that you work in or in the technologies that you work with. If not as part of the job, you would have to do it as a matter of survival in an industry that is famous for its cut throat competition. If you aspire to be in the software profession, then again you need to be up to date with all the latest developments or at least learn something about a technology that matters the most or be trained in it. This would give you the edge over others and help launching your career.

When you come to think of, SQL server is one such important area wherein training will come in handy. If you wish to work with databases, this is one relational database management system that you should know well. Learning about SQL server would give you an idea as to how to implement your database and manage it including the migration aspects of data. You could become a Database Administrator and work entirely with data and its management which is a key and fundamental area in any system. Be it migrating data from one system to another or generating reports or scheduling tasks, knowledge of SQL Server is important. Having established that getting trained in SQL Server would be to your advantage, we would now tell you about the training courses that we offer in this regard.

We at Future in Hands, offer Expertizing SQL Server course that covers almost everything that you need to know about SQL Server. From DBMS concepts to writing code in SQL, we cover all the important topics. By the end of the training, you would be able to query a DB and retrieved relevant data by using sub queries, correlated sub queries and advanced Stored Procedures.

Coverage

Introduction

  • SQL Server Overview and Version History
  • Basic RDBMS Concepts

SQL Overview

  • Outlining SQL as the cornerstone of database activity
  • Applying the ANSI/ISO standards
  • Describing the fundamental building blocks: tables, columns, primary keys and foreign keys

Building the Database Schema

  • Creating tables and columns
  • Building tables with CREATE TABLE
  • Modifying table structure with ALTER TABLE
  • Adding columns to an existing table
  • Removing tables with DROP TABLE

Data Retrieval – SELECT STATEMENT

Querying Data

  • SELECT Statement syntax
  • Manipulating Result Set

Joining Related Data

  • Types Of Joins
  • INNER Join
  • OUTER Join

Implementing Related Queries

  • Working with Aggregate Functions
  • Using GROUP BY Clause
  • Using the WITH ROLLUP and WITH CUBE operators
  • Using the GROUPING Aggregate Function
  • Using the HAVING Clause

Combining Datasets

  • Using the UNION and UNION ALL Operators
  • Using the EXCEPT and INTERSECT Commands
  • Using the APPLY Operator

Applying Built in Scalar Functions

  • Using Built-in Scalar Functions

Modifying Data – INSERT, UPDATE and DELETE STATEMENT

Modifying data using Insert, Update and Delete statement

  •  Inserting Data
  • Updating Data
  • Deleting Data

Enhancing DML Functionality with the Output clause and Merge statement

  • Using the OUTPUT Clause
  • Using the MERGE Statement

Managing Transactions

  • Understanding Transactions
  • Defining Explicit Transactions
  • Understanding Special ROLLBACK Scenarios
  • Gathering Information about Transactions
  • Understanding Locking

Tables, Data Types, and Declarative Data Integrity

Working with Tables and Data Types

  • Data Types
  • Table Basics
  • Compressions

Declarative Data Integrity

  • Validating Data

Using Additional Query Techniques

Building Recursive Queries with CTEs

  • Common Table Expressions

 Implementing Subqueries

  • Non-correlated Subqueries
  • Running Aggregates
  • Correlated Subqueries

Applying Ranking Functions

  • Ranking Data

Programming SQL Server with T-SQL User Defined Stored Procedures, Functions, Triggers and Views

Stored Procedures

  • Creating Stored Procedures
  • Commenting Code
  • Variables, Parameters and Return Codes
  • Control Flow Constructs
  • Error Messages
  • Errors Handling
  • Executing Stored Procedures
  • Module Executing Context
  • Cursors
  • Compilation and Recompilation

User-Defined Functions

  • System Functions
  • User-Defined Functions
  • Retrieving Data from a Function

Triggers

  • DML Triggers
  • DDL Triggers
  • Logon Triggers

Views

  • Creating a View
  • Modifying Data Through a View
  • Partitioned Views
  • Creating an Indexed View
  • Determinism
  • Query Substitution

Techniques to Improve Query Performance

Tuning Queries

  • Evaluating Query Performance
  • Tuning Query Performance
  • Table-Valued UDFs
  • Cursors
  • Finding Out Which Queries to Tune
  • Creating Indexes
  • Improving Performance with Covered Indexes
  • Using Clustered Indexes
  • Read Performance vs. Write Performance
  • Using Computed Columns
  • Using Indexed Views
  • Analyzing Index Usage
  • Partitioning
  • Tuning Indexes Automatically

 Tests and Query Session