Database Fundamentals

This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

Czas trwania

3 dni

cena szkolenia netto

 Skontaktuj się z nami

Kod szkolenia


Profil uczestnika

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.


Understanding Core Database Concepts

  • 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 

Creating Database Objects 

  • 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 

Manipulating Data 

  • 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 

Understanding Data Storage 

  • Using Queries to Select Data 
  • 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 

Administering a Database 

  • 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


After completing this course, students will be able to:

  • Understand Core Database Concepts
  • Create Database Objects
  • Manipulate Data
  • Understand Data Storage
  • Administer a Database
Zapisz się