40364
Database Fundamentals

Duration: 3 days
Price: $1,557.00
Test Level: 100
Certifications: MTA: Database
Exams: 98-364

Course Overview

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

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

Prerequisites

N/A

Upcoming Classes

Click below to see more class dates with course versions
See More Dates

Have questions? Let us help you.

Name

Email Address

Comments

40364 Database Fundamentals

Course Overviewremove_circle_outline

Course Outlineadd_circle_outline

Prerequisitesadd_circle_outline