MTA Database Fundamentals (Introduction to SQL) (Official Exam Included)

WHAT IS AN MTA QUALIFICATION?

An MTA (Microsoft Technical Associate) is a new entry level qualification from Microsoft that allows those new to the IT industry to get into the sector from the level of a complete beginner. If you have an interest, but lack understanding, of buzzwords like Windows Operating System, Windows Server, SQL, Databases or programming then an MTA certification is the best way for you to get your foot in the door and boost your base knowledge of technical subjects.

Whatever area of IT that you are looking to grow into an MTA can unlock the door and will ensure that employers and colleagues know that you have the fundamental skills to excel in a relevant position in the IT industry. Those who strive to complete an MTA may have some experience using computers as an end user but do not know how to delve further into the technical aspects of computing.

MTA Database track. For those intending to build a career in data platform administration or business intelligence:

• Database Fundamentals - Exam: 364

• Training from professional MTA certified trainers:

  Robust IT have been implementing professional Microsoft networking solutions across a range of companies for many years. Those consultants write and teach our MTA training courses, so their experience directly informs course content.

• Practical Projects:

  This MTA training is designed to prepare you not only for MTA certification, but also to train you for your next job. To do this, next to certification you will also work on real-world practical MTA related exercises in this MTA course. This will ensure that you can apply the knowledge gained from this course to your work environment.

• Course Material and Practice exams:

  MTA electronic notes are included in this course. You will also take practice exams as part of the course.

• Course Completion Certificate:

  After completing this training you will receive MTA course completion certificate.

• Support and Careers Advice:

  After the course if you have any problems or questions regarding MTA , do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with you career choice, please speak to one of our career consultants.

• Pass Guarantee and Train again for Free:

  We are sure that you will pass your MTA certification exam at first attempt. However, if you don’t, you can come back within a year and take the complete course for free.

• Official Course Curriculum:

  This MTA certification course is based on the official Microsoft recommended course syllabus.

Understanding Core Database Concepts (20-25%)

• Understand how data is stored in tables
  
  • Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records
• Understand relational database concepts
  
  • Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established
• Understand data manipulation language (DML)
  
  • Understand what DML is and its role in databases
• Understand data definition language (DDL)
  
  • Understand how T-SQL can be used to create database objects, such as tables and views

Create Database Objects (20-25%)

• Choose data types
  
  • Understand what data types are, why they are important and how they affect storage requirements
• Understand tables and how to create them
  
  • Purpose of tables; create tables in a database by using proper ANSI SQL syntax
• Create views
  
  • Understand when to use views and how to create a view by using T-SQL or a graphical designer
• Create stored procedures and functions
  
  • Select, insert, update or delete data

Manipulate Data (25-30%)

• Select data
  
  • Utilise SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT
• Insert data
  
  • Understand how data is inserted into a database, how to use INSERT statements
• Update data
  
  • Understand how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table
• Delete data
  
  • Delete data from single or multiple tables, ensure data and referential integrity by using transactions

Understand Data Storage (15-20%)

• Understand normalisation
  
  • Understand the reasons for normalisation, the five most common levels of normalisation, how to normalise a database to third normal form
• Understand primary, foreign and composite keys
  
  • Understand the reason for keys in a database, choose appropriate primary keys, select appropriate data type for keys, select appropriate fields for composite keys, understand the relationship between foreign and primary keys
• Understand indexes
  
  • Understand clustered and non-clustered indexes and their purpose in a database

Administer a Database (10-15%)

• Understand database security concepts
  
  • Understand the need to secure a database, what objects can be secured, what objects should be secured, user accounts and roles
• Understand database backups and restore
  
  • Understand various backup types, such as full and incremental, importance of backups, how to restore a database

Looking to start a career working with Databases and SQL?! Check out this official Starting point from Microsoft. MTA (Microsoft Technical Associate) is naturally the first step into a becoming a Database Expert. This will provide you with a strong platform of knowledge to further your career. Teaching Core Database Relations, Manipulating data and Administering a database – all backed up by a Microsoft an official Microsoft Certification!