Setup Menus in Admin Panel

Sql Server

$400.00 $250.00


Introduction to SQL Server


Database Models

Overview of SQL Server Management Studio and Transact-SQL language

Master writing simple and complex queries that retrieve data from the database

Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)

Insert, update, and delete data

Retrieve data from tables



Working with Data Types

Procedure and Functions

Understand the different Views

Working with Triggers

Design a database

Maintain databases, tables, and sequences with SQL statements

Create and manage views

Ensure the integrity of multiple, related database updates by using transactions

Retrieve data using cursors

Manage binary data using BLOBs

Introduction To DBMS

File Management System and Its Drawbacks

Database Management System (DBMS) and Data Models

a)Physical Data Models

b)Logical Data Models

Conceptual Data Model

a)Entity – Relationship (E-R) Model

Introduction to SQL Server 

Advantages and Drawbacks of SQL Server Compared to Oracle and DB2

Connecting to Server

a)Server Type
b)Server Name

Authentication Modes

a)SQL Server Authentication Mode
b)Windows Authentication Mode
c)Login and Password

SQL Server Management Studio and Tools in Management Studio

a)Object Explorer
b)Object Explorer Details
c)Query Editor

TSQL (Transact Structured Query Language)

Introduction To TSQL


Types of TSQL Commands

a) Data Definition Language (DDL)
b) Data Manipulation Language (DML)
c) Data Query Language (DQL)
d) Data Control Language (DCL)
e) Transaction Control Language (TCL)


a) Creating Database

b) Altering Database

c) Deleting Database

d) Constrains

a)  Creating Table
b) Altering Table
c)  Deleting Table

Data Manipulation Language

Data Query Language (DQL)

Built in Functions

Top n Clause
• Set Operators
• Joins
• Sub Queries
• Indexes
• Security
• Views
• Transaction Management
• TSQL Programming
• Cursors

CLR Integration

Working with XML Data Type

Backup and Restore of Database

Attach and Detach of Database




Duration & Timings :

Duration – 30 Hours.

Training Type: Online Live Interactive Session.

Faculty: Experienced.

Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. December 19, 2018.

Weekday Session – Mon – Thu 8:30 PM to 10:30 PM (EST) – 4 Weeks.  November 26, 2018.


There are no reviews yet.

Be the first to review “Sql Server”


© 2018 LEARNTEK. ALL RIGHTS RESERVED | Privacy Policy | Terms & Conditions

Hello. Add your message here.
Thanksgiving Discount Offer Ends in
Enroll Now