40364
Database Fundamentals

  • Duration: 3 days
  • Price: $1,557.00
  • Certifications: MTA: Database
  • Exams: 98-364
Course Overviewremove_circle_outline

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 Outlineadd_circle_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
Prerequisitesadd_circle_outline

N/A

Upcoming Classes
  • Click below to see more class dates with course versions
  • See More Dates
Have questions? Let us help you.