Facebook Instagram Linkedin Trustpilot
Online IT Training Courses through IT Academy UK CompTIA | Microsoft | Cisco | AWS | PMI | ITIL | ISTQB | Google | EC-Council | Linux | Prince2 | Oracle | ISACA | HRCI Free Course Demo
Online IT Training Courses through IT Academy UK CompTIA | Microsoft | Cisco | AWS | PMI | ITIL | ISTQB | Google | EC-Council | Linux | Prince2 | Oracle | ISACA | HRCI Free Course Demo

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: £119 / €119 Incl. VAT

You will receive immediate access to your courses upon registration and course purchase. Our on-demand cloud based training courses are accessible on a computer, laptop, tablet/smartphone for a period of 12 months. You will need to obtain 70% and above to receive your Certificate. Assessments may be retaken at no additional cost. 

  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

3-6 Month Payment Plan available.

Career Ready Education. Register Now for our award winning Cloud based training courses led by Industry Experts. 24/7 Access, Mobile Compatible, Student Support - 99% success rate!

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

What’s Included

Replace-trainer-img
  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

Reviews:

STARTING AN IT CAREER OR UPSKILLING?

Click here to view All Courses or call a Career Consultant on 020 7770 6431 or e-mail info@it-academy.uk

Click here to request a free 5 day Trial Course or proceed to STEP 3

Select your course here and click BUY NOW to proceed to checkout 

Register your details and arrange payment via EFT/Credit Card or PayPal

Receive your login details and start immediately

WHAT SETS US APART:

  • Official Partnerships

Partners with IT certification vendors CompTIA, Microsoft & Skillsoft who are the global leaders in online learning

  • We are IT Experts

With over 13 years experience, we have 13 000+ students graduate through IT Academy

  • Award Winning

Latest-in-Market Online Cloud Based Courses 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 Industry Experts

  • Practice Tests

Take Practice Tests designed to mimic the actual exam

Accredited by and Partnered with: