Microsoft MTA Certification Bundle With 3 Exams: Software Development, Database Admin, Security

Microsoft MTA Certification Bundle With 3 Exams: Software Development, Database Admin, Security

From: £159.00 Inc. VAT per month for 6 months

Clear

Description

The Microsoft Technology Associate (MTA) is an entry-level certification aimed at individuals looking to gain their first professional Microsoft certification. MTA certification areas cover a variety of technologies such as windows operating systems, server, networking, security, database administration, software development, and HMTL application development. All of which are taught at a fundamental level.
 
The MTA validates fundamental technology skills and knowledge among learners and job-seekers who are pursuing a career in technology. MTA addresses a wide range of critical technology concepts with exams that are designed to assess and validate core technical concepts in three primary areas: Developer, Database, and IT Professional.
 

An example of an MTA certification you can gain through this course bundle.

 

The MTA is normally the starting point to progress onto more advanced Microsoft certifications such as the Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Expert (MCSE), and Microsoft Certified Solutions Developer (MCSD). This bundle gives individuals an opportunity to explore and certify in three areas: windows operating systems, server, and networking. Prospective students may already be working in an IT capacity and are looking to advance their career or wish to better understand key technologies within their company.

 

Considering working toward an MCSE? Find out what it means to have this certification.

 
What’s included in this certification bundle?
 
This bundle contains three separate MTA certification courses and three official Microsoft MTA certification exams, all of which are valid for 12 months from the time of enrolment. As part of this bundle, you will get access to a MeasureUP practice test for each Microsoft certification course.
 
Certification courses included:
 
Click on a course title to see the areas covered.



Lesson 1: Introduction to Programming
• Objective Domain Matrix
• Key Terms
• Understanding Computer Programming
• Introducing Algorithms
• Introducing C#
• Understanding Decision Structures
• The If Statement
• The If-Else Statement
• The Switch Statement
• Understanding Repetition Structures
• Understanding the While Loop
• Understanding the Do-While Loop
• Understanding the For Loop
• Understanding the Foreach Loop
• Understanding Recursion
• Understanding Exception Handling
• Handling Exceptions
• Using Try-Catch-Finally
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 2: Introduction to Object-Oriented Programming
• Objective Domain Matrix
• Key Terms
• Understanding Objects
• Thinking in an Object-Oriented Way
• Understanding Classes
• Understanding Values and References
• Understanding Structs
• Understanding Memory Allocation
• Understanding Encapsulation
• Understanding Access Modifiers
• Understanding Inheritance
• Understanding Abstract and Sealed Classes
• Inheriting from the Object Class
• Casting between Types
• Understanding Polymorphism
• Understanding the Override and New Keywords
• Understanding Interfaces
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 3: Understanding General Software Development
• Objective Domain Matrix
• Key Terms
• Understanding Application Lifecycle Management
• Understanding Requirements Analysis
• Understanding the Design Process
• Understanding Software Development
• Understanding Software Testing
• Understanding Release Management
• Understanding Testing
• Understanding Testing Methods
• Understanding Testing Levels
• Understanding Data Structures
• Understanding Arrays
• Understanding Queues
• Understanding Stacks
• Linked Lists
• Understanding Sorting Algorithms
• Understanding BubbleSort
• Understanding QuickSort
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 4: Understanding Web Applications
• Objective Domain Matrix
• Key Terms
• Understanding Web Page Development
• Understanding HTML
• Understanding Cascading Style Sheets
• Understanding JavaScript
• Understanding Client-Side vs. Server-Side Programming
• Understanding ASP.NET Application Development
• Understanding ASP.NET Page Life Cycle and Event Model
• Understanding State Management
• Understanding IIS Web Hosting
• Understanding Internet Information Services
• Creating Virtual Directories and Web Sites
• Deploying Web Applications
• Understanding Web Services Development
• Introducing SOAP
• Introducing WSDL
• Creating Web Services
• Consuming Web Services
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 5: Understanding Desktop Applications
• Objective Domain Matrix
• Key Terms
• Understanding Windows Forms Applications
• Designing a Windows Form
• Understanding the Windows Form Event Model
• Using Visual Inheritance
• Understanding Multiple Document Interface (MDI) Applications
• Understanding Console-Based Applications
• Working with Command-Line Parameters
• Understanding Windows Services
• Creating a Windows Service
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 6: Understanding Databases
• Objective Domain Matrix
• Key Terms
• Understanding Relational Database Concepts
• Understanding Databases
• Understanding Relational Database Concepts
• Understanding Relational Database Design
• Understanding Entity-Relationship Diagrams
• Understanding Data Normalization
• Understanding Database Query Methods
• Working with SQL Queries
• Working with Stored Procedures
• Understanding Database Connection Methods
• Working with Flat Files
• Working with XML
• Working with DataSet
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment


Lesson 1: Understanding Core Database Concepts
• Objective Domain Matrix
• Key Terms
• Understanding Database Concepts
• Understanding Flat-Type Databases
• Understanding Hierarchical Databases
• Understanding Relational Databases
• Understanding Database Fundamentals
• Understanding Relational Database Concepts
• Using the SQL Server Management Studio Interface
• Understanding Data Manipulation Language (DML)
• Understanding Data Definition Language (DDL)
• Using DDL Statements
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 2: Creating Database Objects
• Objective Domain Matrix
• Key Terms
• Defining Data Types
• Using Built-in Data Types
• Using Exact Numeric Data Types
• Using Approximate Numeric Data Types
• Creating and Using Tables
• Creating Views
• Creating Stored Procedures
• Understanding SQL Injections
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 3: Manipulating Data
• Objective Domain Matrix
• Key Terms
• Using Queries to Select Data
• Combining Conditions
• Using the BETWEEN Clause
• Using the NOT Clause
• Using the UNION Clause
• Using the EXCEPT and INTERSECT Clauses
• Using the JOIN Clause
• Using Queries to Insert Data
• Inserting Data
• Updating Data and Databases
• Using the UPDATE Statement
• Deleting Data
• Using the DELETE Statement
• Truncating a Table with TRUNCATE TABLE
• Deleting a Table with DROP TABLE
• Using Referential Integrity
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 4: Understanding Data Storage
• Objective Domain Matrix
• Key Terms
• Normalizing a Database
• Understanding Normalization
• Understanding the First Normal Form
• Understanding the Second Normal Form
• Understanding the Third Normal Form
• Understanding the Fourth Normal Form
• Understanding the Fifth Normal Form
• Understanding Primary, Foreign, and Composite Keys
• Understanding Primary Keys
• Understanding Foreign Keys
• Understanding Composite Primary Keys
• Understanding Clustered and Non-clustered Indexes
• Understanding Clustered Indexes
• Understanding Non-clustered Indexes
• Creating a Non-clustered Table
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment
Lesson 5: Administering a Database
• Objective Domain Matrix
• Key Terms
• Securing Databases
• Understanding Server-Level Security
• Understanding Database-Level Security
• Understanding Windows Security
• Understanding SQL Authentication
• Understanding Database Server Roles
• Granting Access to a Database
• Understanding Fixed Database Roles
• Understanding Object Permissions
• Managing Roles
• Understanding Ownership Chains
• Reviewing a Sample Security Model
• Backing Up and Restoring Databases
• Understanding Recovery Models
• Understanding Database Backups
• Understanding Backup Devices
• Understanding Database Restores
• Skill Summary
• Knowledge Assessment
• Competency Assessment
• Proficiency Assessment


Lesson 1: Understanding Security Layers
• Key Terms
• Introducing Core Security Principles
• Understanding Physical Security as the First Line of Defense
• Performing Threat Modeling
• Skill Summary
• Knowledge Assessment
• Business Case Scenarios
• Workplace Ready
Lesson 2: Understanding Authentication, Authorization, and Accounting
• Key Terms
• Starting Security with Authentication
• Introducing Directory Services with Active Directory
• Comparing Rights and Permissions
• Understanding NTFS
• Sharing Drives and Folders
• Introducing the Registry
• Using Encryption to Protect Data
• Understanding IPsec
• Introducing Smart Cards
• Configuring Biometrics, Windows Hello, and Microsoft Passport
• Using Auditing to Complete the Security Picture
• Skill Summary
• Knowledge Assessment
• Business Case Scenarios
• Workplace Ready
Lesson 3: Understanding Security Policies
• Key Terms
• Using Password Policies to Enhance Security
• Protecting Domain User Account Passwords
• Skill Summary
• Knowledge Assessment
• Business Case Scenarios
• Workplace Ready
Lesson 4: Understanding Network Security
• Key Terms
• Using Dedicated Firewalls to Protect a Network
• Using Isolation to Protect the Network
• Protecting Data with Protocol Security
• Understanding Denial‐of‐Service (DoS) Attacks
• Securing the Wireless Network
• Skill Summary
• Knowledge Assessment
• Business Case Scenarios
• Workplace Ready
Lesson 5: Protecting the Server and Client
• Key Terms
• Protecting the Client Computer
• Managing Client Security Using Windows Defender
• Protecting Your Email
• Securing Internet Explorer
• Configuring Microsoft Edge
• Protecting Your Server
• Using Security Baselines
• Locking Down Devices to Run Only Trusted Applications
• Managing Windows Store Apps
• Skill Summary
• Knowledge Assessment
• Business Case Scenarios
• Workplace Ready

 Certification exams included:
 

  1. Microsoft 98-361 Software Development Fundamentals
  2. Microsoft 98-364 Database Administration Fundamentals
  3. Microsoft 98-367 Security Fundamentals

 
MeasureUP practice tests included:
 

  1. Microsoft 98-361 Software Development Fundamentals
  2. Microsoft 98-364 Database Administration Fundamentals
  3. Microsoft 98-367 Security Fundamentals

 
Salary and job prospect information
 
We use two excellent third-party resources to allow you to check your earning potential and job prospects before starting this course.
 

 
The first is IT JobsWatch, which allows you to check what employers are paying people on average with specific certifications, such as the one contained in this bundle. Click here and enter the name of the certification you would like to see salary information on.
 

 
The second is Payscale, which also does the above, but allows you to see what types of job titles are paying more based around the certification you enquire about. Click here and enter the name of the certification you would like to see salary and job title information on.
 
How does this course bundle work?
 
This course bundle is made up of four main resources as shown below. Each certification course has as its own set of resources, i.e. 1 x text book, 1 x practice lab, 1 x MeasureUP practice exam, 1 x official exam. Each resource is designed to work in conjunction with each other to ensure the successful path to certification. You will complete one course and exam, then repeat the process for the remaining courses. Once you have passed the exams, you will receive three MTA certifications from Microsoft. Read below to learn more about the resources that make up this course.
 
 Text Book
 
Each official Microsoft text book will be delivered to you by post. You will receive the first text book upon enrolling on the course and subsequent text books after completing the official exam for the course before. The text books are to be used in conjunction with the practice labs.
 
 Practice Lab
 
The hands-on live practice labs allow you to experience practical application of course concepts in an authentic online environment 24/7, all from the comfort of your home or office. The lab environment allows you to test and apply your skills as you learn. These labs also come with tasks challenging what you have learnt. To learn more about practice labs, click here.
 
 MeasureUP Practice Exam
 
After working your way through each text book and practice labs, you should be ready to start revising for your official exams. To do this, we provide you with MeasureUP practice tests. MeasureUP are the official provider to Microsoft for practice tests. These are the closest experience to the actual exam you’ll be taking. Scroll down to learn more about MeasureUP and the practice tests.
 
 Official Exam
 
Having confidently passed the practice tests, you will be ready to sit the official Microsoft exams – which we will book on your behalf. These are known as an ‘online, web-proctored exams’. This means they can be taken at home. One of the requirements of taking these exams is that you must have a web camera so a proctor can observe you during the exams. This is to ensure no cheating takes place.
 
How long will it take me to complete each course?

This is dependent on several factors such as your level of experience of the subject matter, the amount of time you can dedicate to the course each week, and how quickly you absorb information. Learners can finish a single course from anywhere between 1-3 months. You will have full access to the resources for 12 months and must take your exams within this period.

 
What do I need?
 
As explained above, an element of the course is delivered via text book. The remainder is online with 24/7 access. You can do it from any where in the world, any time of the day providing you have an internet connection. No apps are required to access the course resources. You simply do it from your browser. For the best user experience, we recommend Google Chrome.
 

 
MeasureUP practice tests
 
As part of this course, you will get access to MeasureUP practice tests to help prepare you for the Microsoft exams as part of this bundle. MeasureUP practice tests are endorsed by Microsoft and used as the official practice tests of Microsoft certification exams.
 
Features of MeasureUP practice tests:
 

  • Questions are similar to exam questions, allowing you to test your knowledge of exam objectives
  • Detailed explanations for both correct and distractor answers reinforce the material
  • ‘Study Mode’ covers all objectives ensuring topics are covered
  • ‘Certification Mode’ (timed) prepares students for exam taking conditions
  • Instant, drill-down score reports tell you exactly the areas to focus on

 

Watch this video to learn more about MeasureUP practice tests.

 
How do I book my exams?
 
When you’re ready to sit your exams, email [email protected] with your request along with the title of the exam you wish to take. We will then send you an email with instructions on how to complete your exam booking.
 
Non-cancellation of course
 
Please note that this course is not covered by our standard 7 day guarantee/cancellation/refund policy.

Additional information

Payment options

4 monthly installments, 5 monthly installments, 6 monthly installments, Single payment