SQL Server Online Training

  • (25 REVIEWS )

SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems and a relational database management Platform. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). Its primary query languages are T-SQL and ANSI SQL.

Description

The Main Objective of this course covers all of the SQL Server Database performance tuning topics including global tuning with SQL Server parameters, SQL tuning, file and tablespace management, user administration and security and table and index management.

Prerequisites

TStudents must be familiar with the Concepts in Database.

Prepare for Certification!

Our training and certification program gives you a solid understanding of the key topics covered by Foundation and Advanced Level Certification exams. This is aimed at students who have recently completed, and experienced professionals to enhance their practical knowledge in SQL Server modules. In addition to boosting your income potential, getting certified, demonstrates your knowledge and the skills, understanding of the fundamentals of SQL Server along with processes, tools, techniques, and management methodology.

How will I perform the practical sessions in Online training?

For online training, US GlobalSoft provides a virtual environment that helps in accessing each other’s system. The complete course material in pdf format, reference materials, course code is provided to trainees. US GlobalSoft conductes online sessions through any of the available requirements like Skype, WebEx, GOTOMeeting, Webinar, etc.

SQL Server Course Syllabus

  • SQL SERVER 2008
    TRANSACT-SQL

    • RELATIONAL DATABASE BASICS
    • Brief History of SQL
    • What is New in SQL Server 2008
    • SQL Server Editions
    • Relational Databases
    • Creating Database
    • Tables
    • Rows
    • Columns
    • Relationships
    • Data types
    • Primary Keys
    • Foreign Keys
    • Relational Database Management System
    • SQL Server Objects
    • Valid Object References
    • SQL Statements
    • Database Manipulation Language (DML)
    • Database Definition Language (DDL)
    • Database Control Language (DCL)

    SIMPLE SELECTS WITH SQL SERVER

    • Introduction to the “Adventure Works DW” Database
    • Some Basics
    • Comments
    • Case Sensitivity
    • SELECTING All Columns in All Rows
    • Union Queries
    • Exploring the Tables
    • Using Group and Having
    • SELECTING Specific Columns
    • Sorting Records
    • Sorting By a Single Column
    • Sorting By Multiple Columns
    • Sorting By Column Position
    • Ascending and Descending Sorts
    • The WHERE Clause and Operator Symbols
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • WHERE and ORDER BY
    • The WHERE Clause and Operator Words
    • The BETWEEN Operator
    • The IN Operator
    • The LIKE Operator
    • The NOT Operator
    • Checking Multiple Conditions
    • AND
    • OR
    • Order of Evaluation
    • Writing SELECTs with Multiple Conditions

    ADVANCED SELECTS WITH SQL SERVER

    • Calculated Fields
    • Concatenation
    • Mathematical Calculations
    • Aliases
    • Aggregate Functions and Grouping
    • Aggregate Functions
    • Grouping Data
    • Where Clause
    • Order By Clause
    • Using Group by and Having
    • Built-in Data Manipulation Functions
    • Common Math Functions
    • Common String Functions
    • Common Date Functions

    SUBQUERIES, JOINS, AND UNIONS WITH SQL SERVER

    • Sub queries
    • Joins
    • Table Aliases
    • Multi-table Joins
    • Outer Joins
    • Unions
    • UNION ALL
    • UNION Rules

    INSERTING, UPDATING AND DELETING RECORDS WITH SQL SERVER

    • INSERT
    • UPDATE
    • DELETE

    CREATING AND MODIFYING TABLES WITH SQL SERVER

    • Creating Tables
    • Data types
    • Altering Tables
    • Adding a Column
    • Dropping a Column
    • Renaming Tables
    • Dropping Tables

    AND STORED PROCEDURES IN SQL SERVER

    • Creating Views
    • Dropping Views
    • Creating Stored Procedures
    • Designing a stored procedure
    • Specifying input parameters
    • Returning a recorded
    • Returning output parameters
    • Testing stored procedures

    TRIGGERS

    • Creating DML Triggers
    • Altering DML Triggers
    • Using the Inserted and Deleted Tables
    • Creating DDL Triggers

    CONCLUSION

  • Certification

    Certification assistance provided with proper guidance and certification notes.