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

  • Course Name: MCSA/MCSE Querying Microsoft SQL Server 2012/2014 Course()
  • Major Subject:
  • Course Category: Certificate Courses

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

  • MasterGrade IT 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