SQL Server Online Training

 >>  SQL Server Online Training

SQL Server Online Training


 (5) | 1500 Ratings


Introduction


SQL Server Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 25 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

SQL Server Introduction & Installation

  • 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 Server 2012 Database Design

  • 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 Tables & Data

  • 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

Data Validations and Constraints Need for Data Integrity

  • 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

Views and Row Data Security

  • 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

Indexes and Query Tuning

  • 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

Stored Procedures and Benefits

  • 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

User Defined Functions and Usage

  • 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

Triggers and Cursors – Memory Limitations

  • 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

Cursors – Memory Limitations

  • Cursor declaration and Life cycle
  • STATIC
  • DYNAMIC
  • SCROLL Cursors
  • FORWARD_ONLY and LOCAL Cursors
  • KEYSET Cursors with Complex SPs

Transaction Types and Real-world Scenario

  • 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

Practice Test & Interview Questions

SQL Server project

Exam & Certification

0

Course Review

(5)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

SQL Server Introduction & Installation

  • 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 Server 2012 Database Design

  • 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 Tables & Data

  • 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

Data Validations and Constraints Need for Data Integrity

  • 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

Views and Row Data Security

  • 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

Indexes and Query Tuning

  • 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

Stored Procedures and Benefits

  • 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

User Defined Functions and Usage

  • 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

Triggers and Cursors – Memory Limitations

  • 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

Cursors – Memory Limitations

  • Cursor declaration and Life cycle
  • STATIC
  • DYNAMIC
  • SCROLL Cursors
  • FORWARD_ONLY and LOCAL Cursors
  • KEYSET Cursors with Complex SPs

Transaction Types and Real-world Scenario

  • 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

Practice Test & Interview Questions

SQL Server project

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry