T-SQL Advanced

Home > Courses
Interested in attending ths course? Register your interest here and we'll keep you informed of planned dates

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 Advanced Course Outline

  1. About this Course
  2. SQL Server Management Studio
  3. OFFSET
  4. XML Data
  5. VIEWS
  6. Connecting Views to Excel
  7. USER-DEFINED Functions (UDF)
  8. CREATE DATABASE
  9. CREATE TABLE
  10. INSERT
  11. INSERT INTO
  12. BULK INSERT
  13. UPDATE
  14. DELETE
  15. TRY/CATCH ERROR Handling
  16. TRANSACTIONS
  17. DROP TABLE
  18. DROP DATABASE
  19. STORED PROCEDURES
  20. PARAMETERISED STORED PROCEDURES
  21. Connecting Parameterised SQL Stored Procedures to Excel

Related Courses

SQL Server 2hr Short Course - Backup and Restore
T-SQL Essentials
T-SQL Intermediate
SSRS Reporting Services