Welcome to ONLC Training Centers
Welcome to ONLC Training Centers


Database Fundamentals - 40364 Course Outline

 (2 days)

Voucher Notice
Please note, this class is not eligible for payment through Software Assurance Training Vouchers funded by Microsoft.

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
Appendix A 110
Index111
View outline in Word

A40364

Attend hands-on, instructor-led Database Fundamentals - 40364 training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Database Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $750

Savings options:

 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com