Sql Server

$400.00 $240.00

Description

Introduction to SQL Server

Database

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

Joins

Sub-queries

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

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)

Database

a) Creating Database

b) Altering Database

c) Deleting Database

d) Constrains

Table
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

Normalization

 

 

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. June 9, 2018.

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

Reviews

There are no reviews yet.

Be the first to review “Sql Server”

LEARNTEK

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



Hello. Add your message here.
Memorial Day Discount Offer. Up to 40% Off Ends in
Learn More