
IT Technician | Networking | Servers | Cloud | Coding | Database | Web Design | IT Management | Project Management | Microsoft Office | Data Scientist | Blockchain | Python | Machine Learning | AI
Meet your Instructor:
Aaron Sampson
Instructor: Technology and Developer
Meet your Mentor:
Carl Mullin
Mentor: Business/Technology and Developer
MCSA SQL Database Developer
Pass the 70-761 and 70-762 exams to earn your MCSA SQL 2016 Database Development Certification. Pass the 70-764 and 70-765 exams to earn your MCSA SQL 2016 Database Administrator Certification.
Querying Data with Transact-SQL
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
Database Objects
Indexes and Views
Columnstore Indexes
Programmability Objects
Triggers and Functions
Managing Database Concurrency
Optimize SQL Database Objects and Infrastructure
Course Fee: R4 495.00 or R4 995.00 on terms with R2 250.00 deposit and 6 monthly installments of R460.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: Microsoft
Study Time: 12 Months to complete 40 hours eg Study 1 hour per day and complete your courses in 1.5 months | Full Time or Part Time
Vendor: Microsoft
Provider: IT Academy
Student support: One-on-One Mentoring
Pre-requisite: MTA Database Fundamentals is included or Database experience
Assessment: 70-761 & 70-762
Resources: Laptop, Tablet or Smartphone & Internet Connection
Expertise Level: Beginners
Register
Anytime – 24/7 Access
Salary Indicator
SALARY PROJECTION
Average
salary after
completing
High
R368k
You can earn an average
of R368,000.00 a year
Salary Indicator
SALARY PROJECTION
Average
salary after
completing
High
R368k
You can earn an average
of R368,000.00 a year
Salary Indicator
SALARY PROJECTION
Average
salary after
completing
High
R368k
You can earn an average
of R368,000.00 a year
What’s Included
- 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