MCSA MCSE MTA SQL Server Office Desktop Programming MOC On-Demand

MTA Database introduction to SQL training: 98-364

The Microsoft Technology Associate (MTA) is a entry-level certification designed to help people to learn the fundamentals of databases and SQL

Want to know more about our SQL training classroom, click here to see more information about our Microsoft SQL training.

What is Database Fundamentals MTA SQL training?

Our introduction SQL training course are for candidates seeking to prove introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server also how to use SQL statements and SQL queries such as SELECT,UNION and INTERSECT. Our SQL training will also help you understanding different key types primary,composite and foreign keys.

There are no specific prerequisites that you must have for this SQL training. But this SQL training course will rapidly give you a thorough grounding in the basics of SQL. It will show you the key features and capabilities of SQL and get you using it as quickly as possible. The course covers elements of ANSI SQL using SQL Server as an example database. After you pass the Database Fundamentals exam, you will have earned your Microsoft Technology Associate (MTA) Certification.

If you are not sure what level of SQL you are and what level of SQL training you need please feel free to speak to or e-mail our Microsoft Certified Trainers (MCT) who will be happy to guide you to where you need to be by filling out the form at the bottom of the page

Want to know more about our SQL training and what people think click here

  • Understanding core databse 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
    • Utilize 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 normalization
    • Understand the reasons for normalization, the five most common levels of normalization, how to normalize 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
Access to Remote Connection
24/7 Access for 12 Months
Official Microsoft Partners

Training Solution Breakdown:

Free Brochure, Syllabus & Costing

Sign up using the appropriate form below to receive a SQL training information pack and free online training demo.

  • Information Pack

    Your Information will never be shared with any third party
  • Speak directly with a course advisor

    If you are not sute you level of SQL you need and would like to speak with one of advisors to fine out what level of SQL training you need please Give us a call:

    Talk to one of our friendly and professional course advisors about your training requirements.
    0800 677 1232

Want to Learn about SQL training?

Looking to get into Business Analyst, SQL programming, Sql Server Developer or somthing else with SQL? Speak to a course advisor today!

To find out more about Microsoft SQL training please click below to...

Find out more »

Find your closest testing center

Looking to get certifed? Help us locate your nearest/local testing center:

Request a brochure, with a free demo

Please Fill in the form below:

Request a brochure, with a free demo

Please Fill in the form below: