Course Details
Transact-SQL (T-SQL) is an extension of SQL which is closely integrated into the SQL language, but adds programming constructs that are not native to SQL. It is an extensive library of useful functions which has the flexibility to code complex logic. SQL Server training makes a note on table design with schemas, data operations, working with indexed data and can work with save-point transactions and grouping functions.
SQL Server Training Overview
SQL server training sessions are practically oriented. The sessions will start with the basics of SQL Server such as how to retrieve and manipulate data and range through advanced topics such as how to create tables, logins, users, functions, and procedures. We will conclude with a review of the functions that are proprietary to Transact-SQL help you become specialized in SQL.
SQL Server Training Curriculum
SQL Server 2012 Installation
Service Accounts & Use, Authentication Modes & Usage, Instance Configurations
SQL Server Features & Purpose
Using Management Studio (SSMS)
Configuration Tools & SQLCMD
Conventions & Collation
SQL Database Architecture
Database Creation using GUI
Database Creation using T-SQL scripts
DB Design using Files and File Groups
File locations and Size parameters
Log files and placement
Database Structure modifications
SQL Server Database Tables
Table creation using T-SQL Scripts
Naming Conventions for Columns
Single Row and Multi-Row Inserts
Table Aliases
Column Aliases & Usage
Table creation using Schemas
Basic INSERT
UPDATE
DELETE
SELECT queries and Schemas
Use of WHERE, IN and BETWEEN
Variants of SELECT statement
ORDER BY
GROUPING
HAVING
ROWCOUNT and CUBE Functions
Table creation using Constraints
NULL and IDENTITY properties
UNIQUE KEY Constraint and NOT NULL
PRIMARY KEY Constraint & Usage
CHECK and DEFAULT Constraints
Naming Composite Primary Keys
Disabling Constraints & Other Options
Benefits of Views in SQL Database
Views on Tables and Views
SCHEMA BINDING and ENCRYPTION
Issues with Views and ALTER TABLE
Common System Views and Metadata
Common Dynamic Management views
Working with JOINS inside views
Need for Indexes & Usage?
Indexing Table & View Columns
Index SCAN and SEEK
INCLUDED Indexes & Usage
Materializing Views (storage level)
Composite Indexed Columns & Keys
Indexes and Table Constraints
Primary Keys & Non Clustered Indexes
Why to use Stored Procedures?
Types of Stored Procedures
Use of Variables and parameters
SCHEMABINDING and ENCRYPTION
INPUT and OUTPUT parameters
System level Stored Procedures
Dynamic SQL and parameterization
Scalar Valued Functions
Types of Table Valued Functions
SCHEMABINDING and ENCRYPTION
System Functions and usage
Date Functions
Time Functions
String and Operational Functions
ROW_COUNT
GROUPING Functions
Why to use Triggers?
DML Triggers and Performance impact
INSERTED and DELETED memory tables
Data Audit operations & Sampling
Database Triggers and Server Triggers
Bulk Operations with Triggers
Cursor declaration and Life cycle
STATIC
DYNAMIC
SCROLL Cursors
FORWARD_ONLY and LOCAL Cursors
KEYSET Cursors with Complex SPs
ACID Properties and Scope
EXPLICIT Transaction types
IMPLICIT Transactions and options
AUTOCOMMIT Transaction and usage
SAVEPOINT and Query Blocking
Complex SPs with Transactions
Linked Server and DTC operations
Faqs
Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.
We record each LIVE class session you undergo through and we will share the recordings of each session/class.
Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.
The Training itself is Real-time Project Oriented.
Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.
There are some Group discounts available if the participants are more than 2.
As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like
Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad, San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…
- SQL Server Training in Washington, DC
- SQL Server Training in Virginia
- SQL Server Training in New Jersey
- SQL Server Training in Illinois
- SQL Server Training in North Carolina
- SQL Server Training in California
- SQL Server Training in Maryland
- SQL Server Training in Georgia
- SQL Server Training in Texas
- SQL Server Training in New York
- SQL Server Training in San Francisco
- SQL Server Training in Oregon
- SQL Server Training in Ohio
- SQL Server Training in Florida
- SQL Server Training in Seattle
- SQL Server Training in Chicago
- SQL Server Training in Dallas
- SQL Server Training in Los Angeles
- SQL Server Training in Baltimore
- SQL Server Training in Houston
- SQL Server Training in San Diego
- SQL Server Training in Santa Clara
- SQL Server Training in Columbus
- SQL Server Training in Towson
- SQL Server Training in Salt Lake City
- SQL Server Training in Austin
- SQL Server Training in Sunnyvale
- SQL Server Training in Franklin
- SQL Server Training in Orlando
- SQL Server Training in Boston
- SQL Server Training in San Jose
- SQL Server Training in St. Louis
Drop Us A Query
