Facebook Instagram Linkedin Trustpilot
0
Learners
0
Certificates
0
Courses

Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Meet your Instructor:

Aaron Sampson
Instructor: Technology and Development

Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer

MCSA SQL Database Developer (70-761)

SQL Server 2016 delivers many new features and enhancements. This course provides an overview of the SQL Server 2016 architecture, as well as the functions and capabilities available in each edition. The fundamentals of T-SQL querying is covered in this course, as well as topics such as sets and predicate logic. This course covers the objectives for 70-761: Querying Data with Transact-SQL exam.

T-SQL Querying

Querying and Manipulating Data

Filter and Modify Data in SQL Server 2016

Using Functions in SQL Server 2016

Aggregating Data in SQL Server 2016

Subqueries and Predicate

Operators and Expressions in SQL Server 2016

Database Programmability Objects and Non-Relational Data

Course Fee: R2 495.00 or R2 995.00 on terms with R1 498.00 deposit and 3 monthly installments of R499.00.

Certification:

International exams are optional and can be written at any Pearson Vue Testing Centre in South Africa.  Discounted international exam vouchers can be purchased through IT Academy.

Courses are accessible on a Computer, Laptop, Tablet or Smartphone. Courses are designed in video with audio, printable, includes One-on-One Mentoring, Free Virtual-LABS with feedback and exam preps. Learners are assessed after each lecture, all assessments can be retaken at no additional cost. Receive a .pdf and original Certificate within 1 week which can be added to your CV. International exams are optional and can be written at anytime, Click here to view Centres in your area. e-Mail info@it-academy.co.za to arrange your exam booking.

One-on-One Mentoring

Free Virtual-LABS

Mobile Ready (Tablet/Smartphone access)

100% Pass Rate / Course Mastery Certificate

Discounted International Exam Vouchers

Free Exam Preps

Printable

12 Month Subscription

Student Card

Payment Terms

Your Quick Course Guide

Certification: MCSA SQL 2016 Databse Development: Querying Data with Transact-SQL

Study Time: 12 Months to complete 20 hours eg study 1 hour per day to complete your course in 1 month |study Full Time or Part Time

Vendor: Microsoft

Provider: IT Academy

Student support: One-on-One Mentoring

Pre-requisite: MTA Database Fundamentals

Assessment: 70-761

Resources: Laptop, Tablet or Smartphone & Internet Connection

Expertise Level: Intermediate

Register

Anytime – 24/7 Access

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
R118k
Average Salary
You can earn
R233k
Senior
R348k

High

Source: Payscale

R233k

You can earn an average
of R233,000.00 a year

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
R118k
Average Salary
You can earn
R233k
Senior
R348k

High

Source: Payscale

R233k

You can earn an average
of R233,000.00 a year

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
R118k
Average Salary
You can earn
R233k
Senior
R348k

High

Source: Payscale

R233k

You can earn an average
of R233,000.00 a year

What’s Included

Replace-trainer-img
  • One-on-One Mentoring
  • Free Virtual-LABS
  • Mobile Ready (Tablet/Smartphone access)
  • 100% Pass Rate / Course Mastery Certificate
  • Discounted International Exam Vouchers
  • Free Exam Preps
  • Printable
  • 12 Month Subscription
  • Student Card
  • Payment Terms

Testimonials

How Our Courses Work

Access your On-Demand, Cloud-Based Learning Anytime, Anywhere.

Courses are accesssible on a Laptop, Tablet or Smartphone.

Assessments after each lecture which can be retaken.

One-on-One Mentoring, Free Virtual-LABS with feedback.

IT Academy Course Mastery Certificate:

Receive a .pdf and original Certificate within 1 week which can be added to your CV.
Enquire about NQF Certification.

International Certificate:

Optional, can be written at anytime, click here to view Centres in your area. e-Mail info@it-academy.co.za to arrange your exam booking.

IT Academy Accreditation/Partners: CompTIA (512759) / Microsoft (1204038185) / MICT Seta (ACC2011/01/684)

Top Skills in demand by Companies in South Africa –
Software Development, Security, Data Analyst & Networking

What Sets Us Apart

  • Official Partnerships

Partners with IT certification vendors Cisco, CompTIA, Microsoft & MICT Seta

  • IT Experts

Courses are designed and led by Certified Professionals, Mobile Access

  • Award Winning

e-Learning content delivered via Video, Quizzes, Virtual labs & Mentoring

  • Virtual Practice Labs

Learn, Practice writing Code with instant feedback in a Live Environment

  • Live Mentoring

Free One-on-One Live Mentoring with Certified IT Experts

  • Practice Tests

Take Practice Tests designed to mimic the actual exam

How Do I Register?

Select An Individual Or Bundle Course.

Complete The Registration Form.

Start Today!

Select A Payment Plan.

Select An Individual Or Bundle Course.

Complete The Registration Form.

Select A Payment Plan.

Start Today!

Our Training Is Trusted By

Excellent

Based On 173 Reviews


What past Students say about their experience with IT Academy