Software Developer‎ > ‎SQL Querying‎ > ‎

Advanced SQL (T-SQL)

Alignment:

  • This course covers most of the topics required for the Microsoft Certification Exam 70-433 SQL Server 2008 Database Developer


Brochure :

 


  • You may download a brochure of this course at the bottom of this page. 


 

Course Material :


  • Official MS Book for the course, or alternative, covering most topics for the exam 70-433.


Bookings:

 

  • You can download the course registration form on our home page or by clicking here 

 

Duration and pricing:

  • 5 days full-time (R6995 excl VAT)
  • 5 weeks part-time (2 nights per week, 3 hour sessions) (R7995 excl Vat)
 

Schedule:

  • On the calender on this page below

Intended Audience:

  • SQL Developers / Scriptors who want to prepare themselves for the Microsoft Exam 70-433
Pre-requisites:
  • It is expected that you are on the level of Beginning SQL Querying and should ideally have approx 1 year experience working with it.

Certificate:
  • Upon successfully completion of this course we will issue you with an attendance certificate.
  • You will also write a test and if you score more than 75% you will get an additional academic certificate.

Course Contents: 
Day 1:
  • Background
  • Single table Queries
Day 2:
  • Joins
  • Subqueries
Day 3:
  • Table expressions
  • Set Operations
Day 4:
  • Pivot, Unpivot and Grouping Sets
  • Data Modification
Day 5:
  • Transactions and Concurrency
  • Programmable Objects


SQL Adv