SQL SERVER TRAINING:

 

Course Content Details:

 

Database and Data Modeling:

 

  Data Modeling using ERWIN

  ER and Relational Model

  Normalization and Demoralization

  Data Relationship

 

Management and Administration:

  Installation of SQL Server 2005/2008

  Quick introduction to the tools

  Creating/Altering databases and transaction logs

  Server/ Database configuration

  Backup and recovery

 

Managing Tables with DDL:

Creating schemas:

 

  Managing schemas

  Referencing schemas versus using the default schema

  Hiding schemas with synonyms

 

Building tables:

 

  Selecting appropriate SQL Server data types

  Constructing tables with CREATE TABLE

 

Adding constraints:

  Enforcing uniqueness using PRIMARY KEY and UNIQUE constraints

  Validating relationships using FOREIGN KEY

 

Retrieving Data with Transact-SQL Stored Procedures:

  Batch and stored procedure processing

  Minimizing network traffic using batches and procedures

  Stored procedure compilation and execution

  Using scalar functions

Selecting data Using SELECT:

  Developing stored procedures that extract data from multiple servers

  Retrieving data from two or more table using INNER JOIN,OUTER JOIN and CROSS JOIN

  Executing dynamic queries using OPENROWSET and OPENQUERY

  Combining tabular results with UNION, INTERSECT and EXCEPT

  Executing remote procedures

  Sub-query

  Producing cross tabulations using PIVOT

  CTE

 

Declaring variables and parameters:

 

  Creating and utilizing local variables

  Passing input and output parameters

  Interrogating global variables

 

Calling built-in scalar functions:

 

  Converting data using CAST and CONVERT

  Ordering data with ranking functions

 

Text Manipulation:

  Substring, Charindex, LEFT, LTRIM

 

Modifying data:

 

  Inserting, updating and deleting data

  Ensuring data consistency with transactions and distributed transactions

  Managing concurrency with isolation levels

  SQL Server locking fundamentals

  Avoiding blocking problems with read-committed snapshot isolation

  Managing locks using hints

 

Programming procedural statements:

 

  Implementing conditions with IF...ELSE

  Looping with WHILE and GOTO

  Creating code blocks with BEGIN...END

  Debugging with PRINT

  Returning data using RETURN

  Debugging T-SQL in Management Studio

 

Handling errors:

  Communicating problems to the client with RAISERROR

  Intercepting errors with TRY...CATCH

  Dealing with open transactions when an exception occurs

 

Producing server-side result sets:

 

  Building and using temporary tables

  Processing rows on the server with a cursor

  Taking advantage of table variables

 

Developing Views, Functions and Triggers:

  Storing queries on the server

  Concealing complexity with views

  Solving business problems using multistatement table-valued functions

 

Creating user-defined functions:

  Calculating values with scalar functions

  Processing multiple rows returned from a table-valued function

  Taking advantage of schema binding

 

Formulating triggers:

 

  INSTEAD OF vs. AFTER triggers

  Detecting row changes using the inserted and deleted tables

  Tracking metadata changes with DDL triggers

  Auditing user access using a LOGON trigger

  Tracking data changes with the OUTPUT clause

 

SQL Server Integration Services (SSIS):

 

SSIS Architecture and Tools

Extract, Transform and Load (ETL) capabilities of SSIS

Configuring connection managers

Adding data flow tasks to packages

Transforming with the Data Flow Task

Reviewing progress with data viewers

Copying, moving and deleting files

Sending messages through mail

Error Handling, Logging and Transactions

 

SQL Server Reporting Services (SSRS):

 

SQL Server Reporting Services (SSRS) Architecture

Creating basic reports

Grouping and sorting data

Building parameters into reports

Deploying and Delivering Reports

Creating reports with Report Builder

 

SQL Server Analysis Services (SSAS) :

 

Building and Modifying an OLAP Cube

Choosing between ROLAP, MOLAP and HOLAP

Customizing Properties of Measures and Attributes.

Creating KPI and Calculated Measures

Action, Translation and Perspectives

Creating Partition and Aggregations in cube for improved performance

 

For Inquiries you can walk-in to our Co-operate office (485 US Highway 1 South, Building C, Suite # 105,Iselin,NJ-08830) between 9 am to 6 pm.

Please Email to Training@VForceInfoTech.com OR Call On 732-218-5912 Ext 7008/7010