T-SQL Online Training

• admin
• 9 years ago
• Categories: Database Online Training & Placements on VelocityInfo
• Tags: learn t-sql online, online t-sql classes, t-sql certification program, t-sql jobs placements, t-sql online courses, t-sql online training

T-SQL Online Training

T-SQL Online Training Course Content:

Relational Database Basics

• Brief History of SQL
• Relational Databases [may be compressed due to attendee experience]
  • Tables
  • Rows
  • Columns
  • Relationships
  • Datatypes
  • Primary 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