SQL Server Online Training

SQL Server Online Training

0 STUDENTS ENROLLED

    Introduction

    SQL Server Training makes you proficient in SQL Server and T-SQL and enhance all features and capabilities of SQL Server and T-SQL. It helps manage and store information in an efficient manner.

    Course Content

    1.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

    2.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

    3.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

    4.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

    5.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

    6.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

    7.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

    8.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

    9.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

    10.Cursors – Memory Limitations

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

    11.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 operationsSQL 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

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED