Database Administration Fundamentals


Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is an innovative certification track designed to provide a pathway for future success in technology courses and careers.

The MTA program curriculum helps teach and validate fundamental technology knowledge. Database Administration Fundamentals covers introductory knowledge and skills including: relational databases; core database concepts; relational database concepts; security requirements for databases and the data stored in them; database objects -- such as tables and views; graphical tools and T-SQL scripts; database queries; and stored procedures.

Course Outline

Lesson 1:
Understanding Core Database Concepts 1

Objective Domain Matrix 1
Key Terms 1
Understanding Database Concepts 2
Understanding Flat-Type Databases 3
Understanding Hierarchical Databases 3
Understanding Relational Databases 4
Understanding Database Fundamentals 5
Understanding Relational Database Concepts 7
Using the SQL Server Management Studio Interface 9
Understanding Data Manipulation
Language (DML) 12
Understanding Data Definition Language (DDL) 12
Using DDL Statements 13
Skill Summary 16
Knowledge Assessment 17
Competency Assessment 19
Proficiency Assessment 19

Lesson 2:
Creating Database Objects 20

Objective Domain Matrix 20
Key Terms 20
Defining Data Types 20
Using Built-in Data Types 21
Using Exact Numeric Data Types 24
Using Approximate Numeric Data Types 25
Creating and Using Tables 29
Creating Views 33
Creating Stored Procedures 35
Understanding SQL Injections 38
Skill Summary 38
Knowledge Assessment 39
Competency Assessment 41
Proficiency Assessment 41

Lesson 3:
Manipulating Data 43

Objective Domain Matrix 43
Key Terms 43
Using Queries to Select Data 44
Combining Conditions 45
Using the BETWEEN Clause 46
Using the NOT Clause 47
Using the UNION Clause 47
Using the EXCEPT and INTERSECT Clauses 48
Using the JOIN Clause 48
Using Queries to Insert Data 51
Inserting Data 52
Updating Data and Databases 54
Using the UPDATE Statement 54
Deleting Data 55
Using the DELETE Statement 55
Truncating a Table with TRUNCATE TABLE 56
Deleting a Table with DROP TABLE 56
Using Referential Integrity 56
Skill Summary 57
Knowledge Assessment 57
Competency Assessment 59
Proficiency Assessment 59

Lesson 4:
Understanding Data Storage 61

Objective Domain Matrix 61
Key Terms 61
Normalizing a Database 62
Understanding Normalization 62
Understanding the First Normal Form 62
Understanding the Second Normal Form 63
Understanding the Third Normal Form 64
Understanding the Fourth Normal Form 66
Understanding the Fifth Normal Form 66
Understanding Primary, Foreign, and
Composite Keys 67
Understanding Primary Keys 70
Understanding Foreign Keys 70
Understanding Composite Primary Keys 74
Understanding Clustered and Non-clustered Indexes 74
Understanding Clustered Indexes 75
Understanding Non-clustered Indexes 76
Creating a Non-clustered Table 76
Skill Summary 80
Knowledge Assessment 80
Competency Assessment 82
Proficiency Assessment 82

Lesson 5:
Administering a Database 84

Objective Domain Matrix 84
Key Terms 84
Securing Databases 85
Understanding Server-Level Security 86
Understanding Database-Level Security 86
Understanding Windows Security 87
Understanding SQL Authentication 90
Understanding Database Server Roles 91
Granting Access to a Database 92
Understanding Fixed Database Roles 94
Understanding Object Permissions 95
Managing Roles 98
Understanding Ownership Chains 99
Reviewing a Sample Security Model 100
Backing Up and Restoring Databases 101
Understanding Recovery Models 101
Understanding Database Backups 101
Understanding Backup Devices 103
Understanding Database Restores 103
Skill Summary 106
Knowledge Assessment 107
Competency Assessment 108
Proficiency Assessment 109

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

MTA Database Administration Fundamentals / Exam(s)

Schedule for Database Administration Fundamentals
Course#Course ContentsExam#
40364AMTA Database Administration FundamentalsExam 98-364

2 Hours Daily 3 Times a Week

Total Duration 3 Months


  • Basic Knowledge of Computing
Recommended Courses and Certification:
  • MCSA: SQL Server 2012
  • Model: MTA Database Fundamentals
  • Manufacturer: Microsoft

Write Review

Note: Do not use HTML in the text.