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 *

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. keen Technologies also 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.

    If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

    You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

    Our Trainers 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, India and other parts of the world.

    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

    Job Support

    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

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    IBM® is a registered trademark of IBM in the United States.

    Popular Courses

    Countries

    Keen Technologies offering training in cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Texas, Chicago, San Francisco, Dallas, Washington, New York, Houstan, Atlanta, Orlando, Boston, Toronto, Ottawa, Windsor, Australia, Dubai, Leeds.


    ONLINE MEETING PARTNERS

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