C S - C.S SQL Database

Overview:


SQL is the most used Database in the Industry by web developers and this training teaches on:

How to Create & Manage your Microsoft SQL Databases

How to administer and monitor your SQL Databases

Perform Operations on the Databases

This SQL Video Course is narrated by IT Intelligence Group, the ultimate Database Guru. IT Intelligence Group walks the students through the creation and maintenance of a functional SQL Database from beginning to end, explaining important technical, maintenance, and creation aspects.

This training teaches you the basics and the advanced with and makes the subject so easy to understand and use. This training teaches you more than necessary to use and operate SQL Databases, to name a few :-

SQL Database Design


Creation of SQL Databse

Data Types in SQL

Functions and Operators in SQL

Data Integrity in SQL

CRUD in SQL

Unions and Joins in SQL

Stored Procedures and Functions in SQL

SQL Database Administration

Import and Export in SQL

SQL Monitoring of Database

SQL backup and Recovery

Security and User Management in SQL

This is a must for all web developers and database developers and DBA's. This hands-on course will make a novice a professional.The course contains walk through videos, printed documents of the course material as well as links to resources you need to be able to carry out the course.

The course is starting with the very basics and assumes no prior SQL knowledge.If you need to access any data be it online or within your own company then this course is for you.

Course Content:


Lesson 1: INTRODUCTION TO SQL

Lesson 2: SQL Overview

SQL Overview


Lesson 1: INSTALLATION OF MS SQL SERV...

Lesson 2: HOW TO CONNECT TO MS SQL SE...

Lesson 3: SAMPLE SQL DATABASE - ADVEN...

Lesson 1: CREATE DATABASE USING MS SQ...

Lesson 2: CREATE DATABASE USING COMMA...

Lesson 3: CREATE TABLE USING TEMPLATE...

Lesson 1: NORMALIZATION IN DATABASE

Lesson 2: 1NF - FIRST NORMAL FORM

Lesson 3: 2NF - SECOND NORMAL FORM

Lesson 4: 3NF - THIRD NORMAL FORM

Primary and Foreign Key - Referential Data Integrity in SQL


Lesson 1: ADDING A PRIMARY KEY IN AN ...

Lesson 1: CREATE TABLE

Lesson 2: ALIASING COLUMN

Lesson 3: DELETE STATEMENTS

Lesson 4: UPDATE STATEMENTS IN MS SQL

Transactions in MS SQL


Lesson 1: TRANSACTIONS

Lesson 2: TRANSACTIONS ACID TEST

Function and Operators in SQL

Lesson 1: STRING FUNCTIONS IN MS SQL

Lesson 2: AGGREGATE FUNCTIONS

Lesson 3: DATE FUNCTIONS IN MS SQL

Lesson 1: USING SELECT STATEMENTS - E...

Lesson 1: SELECT STATEMENT AND WHERE ...

Lesson 2: AUTOMATICALLY GENERATE A SE...

Lesson 3: WHERE CLAUSE IN MS SQL

Lesson 4: SQL SELECT CALCULATED COLUMNS

Lesson 5: CREATE A TABLE ALIAS

Lesson 6: TRANSFERING THE TABLE FROM ...

Insert and Deletes in MS SQL


Lesson 1: INSERT INTO TABLES

Lesson 2: INSERT INTO NEW SQL TABLE W...

Lesson 3: INSERT DATA USING SERVER MG...

Lesson 4: QUERY EDITOR AND GUI FOR AD...

Lesson 5: INSERT INTO USING VARIABLES

Lesson 1: JOINS IN MS SQL

Lesson 2: UNIONS IN MS SQL

Lesson 3: SUBQUERY IN MS SQL

Lesson 1: ORDER BY CLAUSE

Lesson 2: SELECT WITH ORDER BY AND WH...

Schema, Views and Indexes in SQL


Lesson 1: Remove

Lesson 2: Rimove

Lesson 3: DROP VIEWS

Lesson 4: CREATE VIEWS IN MS SQL

Lesson 5: CREATING AND ASSIGNING PERM...

Lesson 6: CREATE INDEX IN MS SQL

Lesson 7: DROP AN INDEX IN MS SQL

Lesson 8: CLUSTERED INDEX IN MS SQL

Stored Procedures in MS SQL


Lesson 1: CREATE PROCEDURE -BASIC

Lesson 2: COMMENT IN STORED PROCEDURE...

Lesson 3: STORED PROCDURE - WITH IN P...

Lesson 4: STORED PROCEDURE WITH OUTPU...

Lesson 5: INSERT INTO USING STORED PR...

Lesson 6: DROP STORED PROCEDURES IN M...

Functions and Triggers in SQL


Lesson 1: TRIGGERS IN MSSQL

Lesson 2: AFTER TRIGGER

Backup and Recovery


Lesson 1: BACKUP AND RESTORE IN SQL

Course Benefits:

This course will equip you with the knowledge you need to perform these tasks within your business or employment to improve your prospects.Most business systems utilize some form of SQL database, typically Microsoft SQL Server which is why this course focuses on that particular product.

domain