T-SQL Advanced

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 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

T-SQL Essentials
T-SQL Intermediate
SSRS Reporting Services