T-SQL Intermediate

Home > Courses

No Upcoming Course Dates Scheduled

Contact us to schedule a date!

About this Course

SQL stands for Structured Query Language, and is the industry standard language for communicating with relational databases. SQL statements are used by a wide variety of users from developers to business analysts to perform tasks such as retrieve or modify data from a database.

T-SQL Intermediate Course Outline

  1. About this Course
  2. SQL Server Management Studio
  3. CASE
  4. STRING FUNCTIONS
  5. DATE Functions
  6. NULL Functions
  7. TOP, TOP WITH TIES
  8. WINDOW Functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE)
  9. Database Design Principles and Practices
  10. JOIN (One-to-Many, Multiple tables)
  11. JOIN (Many-to-many)
  12. SELF JOIN
  13. SUB-QUERIES
  14. SET Operators
  15. Common-Table Expressions (CTE's)

Related Courses

T-SQL Essentials
T-SQL Advanced
SSRS Reporting Services