Showing posts with label T-SQL. Show all posts

Friday, May 12, 2017

SQL Server Dev Programing training @ SQL Schhol Training Institute

SQL School Training Institute is an ISO Certified Organization and Microsoft Learning Partner offering real-time, practical trainings exclusively on SQL Server Technologies including SQL Server Development (SQL Dev), SQL Database Administration (SQL DBA), Microsoft Business Intelligence and Datawarehousing (MSBI / DWH) Training. Versions: SQL Server 2016, SQL Server 2014. Register Today for free demo

We offer Instructor-Led LIVE Online Training, Classroom Training and On-demand Video Training with COMPLETE REAL-TIME and INTERACTIVE Practical Sessions. All our training courses include Real-time Projects, Certifications, Weekly Mock Interviews, Placement Assistance and free 24x7 LIVE Online Lab.

SQL Server & T-SQL (DEV) Online Training (LIVE, Instructor-Led)

This impeccable SQL Server (with T-SQL Queries and Tuning) course is exclusively designed for starters as well as for experienced professionals addressing SQL Server Installation, DB Design, Queries, Joins, CTE, Stored Procedures, Triggers, Remote Queries, Transactions and Tuning options with BLOB Data and XML. Practice Material, Certification, Resume & Interview Guidance are included in this SQL Server T-SQL Course.

Stored Procedures - Purpose, Syntax, Properties and Types
Compilation, Precompilation and Query Optimization (QO)
Variables - Usage and Data Types in Stored Procedures
Parameters - Usage and Data Types in Stored Procedures
Stored Procedure Executions - Syntax, Alternate Options
Stored Procedures for Data Validations & Missing Identity
Stored Procedures for Dynamic SQL Queries. Views & SPs
Stored Procedures for Data Reporting. Advantanges, Tuning
Important System Procedures For Metadata Access. Usage
Important Extended Procedures For Application Operations
IF.. ELSE, IF .. ELSE IF, IIF Conditions. PRINT statements
Error Handling Techniques in T-SQL: TRY, CATCH, THROW
Dynamic Parameters and Variables. Examples with Views
Default Parameter Values, Data Types and NULL Values
Batch Executions with Stored Procedures. Variants
Unicode Data and Dynamic SQL Queries. sysname Data

Stored Procedures for Sub Queries, Dynamic Sub Queries
Stored Procedures for Recursive and Nested Queries
OUTPUT Parameters in Stored Procedures. Usage Options
Common Table Expressions (CTE) and In-Memory - Syntax
Row Number and Rank Generation, Sub Queries, Self Joins
Stored Procedures for Parameterized CTE (Sub) Queries
Using CTE for Table Data Operations - DML & Retrieval
CTE for DML and DDL Operations in Stored Procedures
Using Recursive CTEs and Self Joins with Stored Procedures
Precautions for Recursive CTEs - Performance Impact
Query Tuning Operations with CTEs. Query Store Options
CTE Advantages and Limitations - Precompilations
Dynamic SQL Queries with Parameters and Variables
Cached Plans and Memory Store for Stored Procedures
RECOMPILE Options and ENCRYPTION Options - Scenarios
Identity Inserts - Manual Sequence. Dynamic Inserts
ANCHOR Members and RECURSIVE Members. Termination

SQL Injection Attacks and Parameter Sniffing - Solutions
SQL Injection Vulnerables - Data Types and Validations
Table Value Parameters (TVP) - Purpose, Types and Syntax
User Defined Table Data Types and TVP Usage in SProcs
READONLY Parameters, Table Data Type (User Defined)
Error Handling with Table Valued Parameters in SProcs
Startup Stored Procedures: Configuration, Server Property
Server Startup, Auto Log Options with Stored Procedures
Extended Stored Procedures - Purpose, Options & Usage
Stored Procedures for Dynamic Values, Calendar Data
Cursors - Benefits, Syntax. Using SProcs with Cursors
FORWARD_ONLY and SCROLL Cursors Types. Limitations
STATIC and DYNAMIC Cursors Types. ABSOLUTE Fetch
LOCAL and GLOBAL Cursor Types & Scope, Reusability
KEYSET DRIVEN Cursor Types & Performance Options
Embedding Cursors in Procedures and User Functions
SPs with Cursors @ Dynamic Data Loads, Data Formatting

SQL School (SequelGate (I) Technologies Pvt. Ltd.)

OFFICE 1:

#108/2RT, Road No: 1, Beside Bus Stop,
SR Nagar, Ameerpet, Hyderabad - 38 (India). Map

OFFICE 2:

Sai Anu Avenue, Street Number 3, Patrika Nagar,
Patrika Nagar, HITEC City, Hyderabad - 81 (India). Map

contact@sqlschool.com

India: 0091 (0)9666440801 USA: 001 (510) 400-4845

Saturday, December 3, 2016

SQL DBA(With T-SQL) Live Online Training

SQL DBA Online Training (LIVE, Instructor-Led)

Real-time Practical SQL DBA LIVE Online Training designed to work with all major SQL Database Administration activities including DB Design, Normalized Views, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24x7 Online Lab, Certification, Job Support with One Realtime Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.

Please register free demo @ sqlschool.com/register.html

SQL School (SequelGate (I) Technologies Pvt. Ltd.)

OFFICE 1:

#108/2RT, Road No: 1, Beside Bus Stop,
SR Nagar, Ameerpet, Hyderabad - 38 (India). Map

OFFICE 2:

Sai Anu Avenue, Street Number 3, Patrika Nagar,
Patrika Nagar, HITEC City, Hyderabad - 81 (India). Map

contact@sqlschool.com

India: 0091 (0)9666440801 USA: 001 (510) 400-4845

Tuesday, September 30, 2014

COMPLETE PRACTICAL TRAINING ON T-SQL AND SQL SERVER BASICS at SQL School

SQL School is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We have been providing Online and Classroom Trainings for the last SEVEN years. All our trainings are COMPLETELY PRACTICAL.

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Detailed Course Curriculum at http://sqlschool.com/TSQL-Classroom-Training.html

SQL School Training Institute
contact@sqlschool.com
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://www.sqlschool.com

Sunday, September 28, 2014

LIVE ONLINE TRAINING ON SQL Server 2012 T-SQL at SQL School

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Detailed Course Curriculum: http://sqlschool.com/TSQL-Online-Training.html

SQL School Training Institute
contact@sqlschool.com
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://www.sqlschool.com

Saturday, September 27, 2014

MICRSOFT SQL SERVER CLASSROOM TRAINING at SQL SCHOOL

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Thursday, September 25, 2014

LIVE ONLINE TRAINING ON SQL Server 2012 T-SQL COURSE at SQL School

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Tuesday, September 23, 2014

BEST PRACTICAL MS SQL REALTIME CLASSROOM TRAINING AT SQL SCHOOL.

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Monday, September 22, 2014

COMPLETE PRACTICAL TRAINING ON T-SQL AND SQL SERVER BASICS

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Saturday, September 20, 2014

CLASSROOM TRAINING ON SQL Server 2008 & 2012 COURSE

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Friday, September 19, 2014

LIVE ONLINE TRAINING ON SQL Server 2008 & 2012 at SQL School

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Friday, September 12, 2014

BEST PRACTICAL MS SQL REALTIME CLASSROOM TRAINING

SQL School is one of the pioneers IT Institutions providing specialized in SQL Server DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SEVEN years. All our sessions are completely Practical and Real-time.

SQL DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):

Basic SQL Server Administration (SQL DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
SQL Profiler & Troubleshooting
Tuning & Issue Troubleshooting
Deadlock Graphs & Monitoring
Database Cloning and Issues
Indirect Checkpoints and Use
Import - Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management

Advanced SQL Server Administration (SQL DBA)

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Database Maintenance Plans
Database Repairs, Object Repairs
CPU, IO and Memory Issues
Tuning Text and Image Data
Smoke Test Procedures
Policy Based Management (PBM)
Contained Databases Usage
DB Mail & Alert System with Notifications
Upgrades, Migrations and Service Pack Installations
SQL Server Failover Cluster Configuration
Active Directory Configurations and Storage (SAN) Management
Active/Active and Active/Passive Cluster Configuration Issues
SQL Server Cluster Management Operations
MSDTC and Resource Governor Importance and Usage
Contained Databases and Always-On Availability Groups

Course Fee for complete practical SQL DBA Classroom Training: INR 10000/- (payable in installments).
For free Demo and further training details, please visit www.sqlschool.com or contact us.

SQL School Training Institute
contact@sqlschool.com
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com/

Wednesday, September 10, 2014

LIVE ONLINE TRAINING ON SQL Server 2012 T-SQL COURSE

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Monday, September 8, 2014

PRACTICAL SQL Server 2012 REALTIME CLASSROOM TRAINING

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Thursday, September 4, 2014

PRACTICAL SQL Server 2012 CLASSROOM TRAINING at SQL School

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Tuesday, September 2, 2014

COMPLETE PRACTICAL TRAINING ON T-SQL AND SQL SERVER BASICS

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Sunday, August 31, 2014

MICRSOFT SQL SERVER CLASSROOM TRAINING @ SQL SCHOOL

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Friday, August 29, 2014

LIVE ONLINE TRAINING ON SQL Server 2008 & 2012

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Thursday, August 28, 2014

BEST PRACTICAL MS SQL REALTIME CLASSROOM TRAINING

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Tuesday, August 26, 2014

PRACTICAL SQL SERVER ONLINE TRAINING

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Sunday, August 24, 2014

PRACTICAL SQL Server 2008 R2 CLASSROOM TRAINING

SQL Server Classroom Training Course Details:

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 - Installation
Service Accounts and Authentication
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity Concepts and Column Value Consistency
PRIMARY KEY, UNIQUE and IDENTITY Constraints
CHECK and DEFAULT Constraints
SQL Server Views and Schemabinding of Views
Updatable Vies adn ALTER consequences
Schema depedancy and Encryptions
JOINS, Sub Queries and Nested Queries
Nested and Linking Tables
Uses of Indexes and Performance
Query Execution Plans and QO Components
Stored Procedures and OUTPUT Parameters
Dynamic SQL and Usage
User Defined Functions, Table Return Values and Parameters
Table Valued Parameters and Variables
DDL Triggers and DML Triggers
Cursors Usage and Limitations
TEMP Tables and Table Variables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012