Colleges and Universities Offering MCSA/MCSE Querying Microsoft SQL Server 2012/2014 Course in South Africa

Institutions Offering MCSA/MCSE Querying Microsoft SQL Server 2012/2014 Course

•  MasterGrade IT, Cape Town  
  Course duration
  (i) Instructor Led Learning
  -5 Days
  
  (ii) Video Learning
  - 5 Days
  
  Course content
  -Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  -Understand the similarities and differences between Transact-SQL and other computer languages.
  -Write SELECT queries
  -Query multiple tables
  -Sort and filter data
  -Describe the use of data types in SQL Server
  -Modify data using Transact-SQL
  -Use built-in functions
  -Group and aggregate data
  -Use subqueries
  -Use table expressions
  -Use set operators
  -Use window ranking, offset and aggregate functions
  -Implement pivoting and grouping sets
  -Execute stored procedures
  -Program with T-SQL
  -Implement error handling
  -Implement transaction

---

More Certificate Courses in South Africa

---

View all courses in South Africa

---