Database Administration Fundamentals

    $0.00
    *
    *
    *

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

    Prerequisites

    • 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.