SQL Server Database Fundamentals: Design Principles and Data Manipulation
SQL Server Database Fundamentals: Creating, Optimizing, and Securing Databases
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
perators and Expressions in SQL Server 2016
Database Programmability Objects and Non-Relational Data
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Using Basic SELECT statements
Conversion Functions & Conditional Expressions
Displaying Data from Multiple Tables
Using the Set Operators
Managing Objects with Data Dictionary Views
Managing Schema Objects
Data Definition Language (DDL)
SQL*Plus
Restricting & Sorting Data
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Using Subqueries to Solve Queries
Creating Other Schema Objects
Oracle Database 12c R2 SQL: Controlling User Access
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
DP-900 Azure Data Fundamentals: Data Workloads
DP-900 Azure Data Fundamentals: Data Analytics
DP-900 Azure Data Fundamentals: Relational Data Workloads
DP-900 Azure Data Fundamentals: Relational Data Management
DP-900 Azure Data Fundamentals: Provisioning & Configuring Relational Data Services
DP-900 Azure Data Fundamentals: Azure SQL Querying Techniques
DP-900 Azure Data Fundamentals: Non-relational Data Workloads
DP-900 Azure Data Fundamentals: Non-relational Data Services
DP-900 Azure Data Fundamentals: Azure Cosmos
DP-900 Azure Data Fundamentals: Non-relational Data Management
DP-900 Azure Data Fundamentals: Azure Analytics Workloads
DP-900 Azure Data Fundamentals: Modern Data Warehousing
DP-900 Azure Data Fundamentals: Azure Data Ingestion & Processing
DP-900 Azure Data Fundamentals: Azure Data Visualization
DP-100 Azure Data Scientist Associate: Machine Learning
DP-100 Azure Data Scientist Associate: Machine Learning Services
DP-100 Azure Data Scientist Associate: Machine Learning Regression Models
DP-100 Azure Data Scientist Associate: Machine Learning Classification Models
DP-100 Azure Data Scientist Associate: Project Jupyter & Notebooks
DP-100 Azure Data Scientist Associate: Azure Machine Learning Workspaces
Course Fee: £595.00 / €595.00 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.
Meet your Instructor:

Simon Tavasoli
Instructor: Technology and Developer
Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer
- 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
Quick View Of Our Platform:

OR
GET STARTED FROM £49 PER MONTH - UNLIMITED ACCESS TO 7,000+ COURSES
Choose a plan. Complete the 3 step enrolment process, start training today!
GET STARTED FROM £49 PER MONTH - UNLIMITED ACCESS TO 7,000+ COURSES
Choose a plan. Complete the 3 step enrolment process, start training today!
Unlimited access to all courses£49
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATES
BUY NOWUnlimited access to 7,000+ courses£65
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATES
BUY NOWUnlimited access to 7,000+ courses£79
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATES
BUY NOWREQUEST A FREE 5 DAY TRIAL, NO CREDIT CARD REQUIRED!
SQL Server Database Fundamentals: Design Principles and Data Manipulation
SQL Server Database Fundamentals: Creating, Optimizing, and Securing Databases
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
perators and Expressions in SQL Server 2016
Database Programmability Objects and Non-Relational Data
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Using Basic SELECT statements
Conversion Functions & Conditional Expressions
Displaying Data from Multiple Tables
Using the Set Operators
Managing Objects with Data Dictionary Views
Managing Schema Objects
Data Definition Language (DDL)
SQL*Plus
Restricting & Sorting Data
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Using Subqueries to Solve Queries
Creating Other Schema Objects
Oracle Database 12c R2 SQL: Controlling User Access
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
DP-900 Azure Data Fundamentals: Data Workloads
DP-900 Azure Data Fundamentals: Data Analytics
DP-900 Azure Data Fundamentals: Relational Data Workloads
DP-900 Azure Data Fundamentals: Relational Data Management
DP-900 Azure Data Fundamentals: Provisioning & Configuring Relational Data Services
DP-900 Azure Data Fundamentals: Azure SQL Querying Techniques
DP-900 Azure Data Fundamentals: Non-relational Data Workloads
DP-900 Azure Data Fundamentals: Non-relational Data Services
DP-900 Azure Data Fundamentals: Azure Cosmos
DP-900 Azure Data Fundamentals: Non-relational Data Management
DP-900 Azure Data Fundamentals: Azure Analytics Workloads
DP-900 Azure Data Fundamentals: Modern Data Warehousing
DP-900 Azure Data Fundamentals: Azure Data Ingestion & Processing
DP-900 Azure Data Fundamentals: Azure Data Visualization
DP-100 Azure Data Scientist Associate: Machine Learning
DP-100 Azure Data Scientist Associate: Machine Learning Services
DP-100 Azure Data Scientist Associate: Machine Learning Regression Models
DP-100 Azure Data Scientist Associate: Machine Learning Classification Models
DP-100 Azure Data Scientist Associate: Project Jupyter & Notebooks
DP-100 Azure Data Scientist Associate: Azure Machine Learning Workspaces
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
Quick View Of Our Platform:

Course Fee: £595.00 / €595.00 Incl. VAT
OR
GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY
Choose a plan. Complete the 3 step enrolment process, start training today!
GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY
Choose a plan. Complete the 3 step enrolment process, start training today!
ProfessionalUnlimited access to all courses£49
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATE
BUY NOWProfessionalUnlimited access to all courses£65
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATE
BUY NOWProfessionalUnlimited access to all courses£79
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATE
BUY NOWREQUEST A FREE 5 DAY TRIAL, NO CREDIT CARD REQUIRED!
Your Quick Course Guide
Certification: Microsoft
Study Time: 12 Months to complete 80 hours eg Study 1 hour per day and complete your courses in less than 3 months | Full Time or Part Time
Vendor: Microsoft
Provider: IT Academy
Student support: One-on-One Mentoring
Pre-requisite: None
Assessment: 98-364, 70-761, 1Z0-071, DP-900, DP-100
Resources: Laptop, Tablet or Smartphone & Internet Connection
Expertise Level: Beginners
Salary Indicator
SALARY PROJECTION
Average
salary after
completing
High
£39k
You can earn an average
of £39,000 a year
What’s Included

- 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?
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:















