Contact Us

MSBI Certification Training

INR USD

SQL Server

Microsoft SQL Server Training is a complete training in SQL Developer and Server. As part of the training you will manage the database solutions, manage various operations on databases, migrate it to the cloud and scale on demand. You will work on real world projects

Why this course ?

This Microsoft sql training course is an online in class training for Microsoft SQL Server and is meant for developers to help them master the descriptive learning language on database concepts for working for relational databases. The important topics included in this course are SQL introduction, relational databases, queries, Subqueries, joins and unions. You will gain considerable proficiency in the theory of optimization, indexing, transactions, database administration, installation of SQL server and clustering.

Courses Curriculum

  • Why Sql Server, DDL commands

    Goal: Data Definition Commands defines the syntax of a database and manipulate database objects. 
     
    Module Objectives: 
    • RDBMS (Relational Database Management System) Introduction
    • Normalization in RDBMS
    • Create database objects i.e. Create Table
    • Delete database objects i. e. Delete Database
    • Alter database objects i.e. Change Column Name
    • Create, alter and delete constraints 
     
    Topics:
    • Relation Database Management System (RDBMS)
    • Normalization
    • Create Database objects
    • Data Types in SQL
    • Alter Table Statements
    • Drop Table Statements
    • Various Constraints
    • Creating Views
     
    Hands-on/Demo/Use-case:
    • Create Table With Predefine Columns
    • Add New Column to Existing Table
    • Check the constraints on a table
    • Add Primary Key and Foreign Key on Table
    • Remove Unique Constraint
     

     

  • DML Commands

    Goal: DML Commands help to work with existing data. Using these commands we can add, modify, or delete the data. 
     
    Module Objectives: 
    • Insert record/data in tables
    • Modify/Update the existing data
    • Retrieve the data from database from single table
    • Use of operators for data retrieval
    • Delete the data from tables
     
    Topics:
    • Insert Statements
    • Insert – As- Select Statement
    • Update Statements
    • Delete Statements
    • Truncate Statements
    • Select Statement
    • Sorting and Filtering
    • SQL wildcard
    • CASE Expression
     
    Hands-on/Demo/Use-case:
    • Insert the records in an existing table
    • Delete selective records
    • Update data in the table based on data from another table
     

  • Joining Tables

    Goal: To combines columns from multiple tables in a database by using values common to tables
     
    Module Objectives: 
    • Retrieve records from multiple tables
     
    Topics:
    • Self-Join
    • Inner Join
    • Left Join
    • Right Join
    • Cross Join
     
    Hands-on/Demo/Use-case:
    • Retrieve data from multiple tables
     

Project

  • Project

    Below are the projects you will work on as part of this course:
    Building a Multi table Relational Database
    Problems and exercises based on given schema. 25 exercises will be given as a part of the project.

FAQ's

  • What If I Miss Any Session ?

    You will never miss a lecture with us ! You can choose either of the two options:

    View the recorded session of the class available in your LMS.
    You can attend the missed session, in any other live batch.

  • Can i attend a demo session before enrollment ?

    We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

  • Who are the Instructors ?

    All the instructors are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by edureka for providing an awesome learning experience to the participants.

Enroll Now

Recruiter
x

Forgot Password !
Cancel

Job Seeker
x

Forgot Password !
Cancel

Apply Job
x