Colleges and Universities Offering Querying Data With Transact SQL (20761B) Course in South Africa

Institutions Offering Querying Data With Transact SQL (20761B) Course

•  MasterGrade IT, Cape Town  
  Course entry requirements
  -Basic computer skills
  -Computers made easy course
  
  Course duration
  (i) Instructor Led Learning
  -5 Days
  
  (ii) Video Learning
  - 5 Days
  
  Course content
  • Introduction to Microsoft SQL Server 2016
  •Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2016 Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Windows Ranking, Offset, and Aggregate Functions
  • Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions

---

More Certificate Courses in South Africa

---

View all courses in South Africa

---