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.
Lesson 1: INTRODUCTION TO SQL
Lesson 2: 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
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.