The Appstation

What You Will Learn?

SQL SERVER

In The SQL Server You Will learn

INTRODUCTION TO BASIC DATABASE CONCEPTS

NORMALIZATION

INTRODUCTION TO SQL SERVER

INTRODUCTION TO SQL

DDL AND DML STATEMENTS

WORKING WITH QUERIES

AGGREGATE FUNCTIONS

JOINS AND SET OPERATIONS

WORKING WITH CONSTRAINTS

IMPLEMENTING VIEWS

DATA CONTROL LANGUAGE (DCL)

WORKING WITH INDEXES

WRITING TRANSACT-SQL (T-SQL)

WORKING WITH STORED PROCEDURES AND FUNCTIONS

IMPLEMENTING TRIGGERS

BACKUP AND RESTORE

ADVANCE FEATURES

ANALYZE PERFORMANCE

A GUIDE TO MOVING AND COPYING DATABASES

BEST PRACTICES

OTHER COURSE