USA: +1 734 418 2465 | India: +91 40 4018 1306 | info@learntek.org

Setup Menus in Admin Panel

brunch (14)

SQL SERVER

Inquiry Now

Product 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.

Course Fee : $300    Discount Offer  

Training Type: Online Live Interactive Session.

Faculty: Experienced.

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

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

Reviews

There are no reviews yet.

Be the first to review “SQL SERVER”

About Learntek

Learntek is global online training provider on Big Data, Hadoop, Data Analytics and other IT and Management courses. We are dedicated to designing, developing and implementing training programs for students, corporate employees and business professional.

Our job is to make sure your training and learning experience is everything it should be – exciting, enjoyable, stimulating and successful.
top
Copyright @ 2017 Learntek. All Rights Reserved