Mentors Inn TRANSACT-SQL ONLINE TRAINING

TRANSACT-SQL ONLINE TRAINING

For Details Contact :
Mobile: +91-8897755222
Email: [email protected]
Website : http://mentorsinn.com/

TRANSACT-SQL COURSE CONTENT
RELATIONAL DATABASE BASICS
Brief History of SQL
Relational Databases [may be compressed due to attendee experience]
Tables
Rows
Columns
Relationships
Datatypes
Prim
ary Keys
Foreign Keys
Relational Database Management System
SQL Server Objects
Valid Object References
SQL Statements
Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)
SIMPLE SELECTS WITH SQL SERVER
Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions
AND
OR
Order of Evaluation
Writing SELECTs with Multiple Conditions
ADVANCED SELECTS WITH SQL SERVER
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Aggregate Functions and Grouping
Aggregate Functions
Grouping Data
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
SUBQUERIES, JOINS, AND UNIONS WITH SQL SERVER
Subqueries
Joins
Table Aliases
Multi-table Joins
Outer Joins
Unions
UNION ALL
UNION Rules
INSERTING, UPDATING AND DELETING RECORDS WITH SQL SERVER
INSERT
UPDATE
DELETE
CREATING AND MODIFYING TABLES WITH SQL SERVER
Creating Tables
Datatypes
Altering Tables
Adding a Column
Dropping a Column
Renaming Tables
Dropping Tables
VIEWS AND STORED PROCEDURES IN SQL SERVER
Creating Views
Dropping Views
Creating Stored Procedures
Designing a stored procedure
Specifying input parameters
Returning a recordset
Returning output parameters
Testing stored procedures
CONCLUSION
ENROLL NOW