toggle menu

T-SQL Online Training

  1. Velocity Infosystems ›
  2. T-SQL Online Training

T-SQL Online Training

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

Drop your query

Most Popular Courses

Achieve your career goal with industry recognised learning paths

What my Client's Say?

 

  • It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand

  • All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin

  • It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla

  • Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig

  • Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala

  • It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar

  • The course was really good because it was a practical course.~ M.Radha patel

  • I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria

Request a Call Back