Register your product to gain access to bonus material or receive a coupon.
Video accessible from your Account page after purchase.
6+ Hours of Video Instruction
Learn the fundamentals of databases and prepare for the Microsoft Technology Associate (MTA) exam 98-364: Database Fundamentals.
Overview
In MTA 98-364 Database Fundamentals LiveLessons, you gain the knowledge required to work with and design relational databases and prepare for Microsoft MTA Exam 98-364.
Drawing on his experience as a SQL Server MVP, Eric Johnson guides you from the basic elements of databases, such as tables and indexes, and progresses into the principles of database design and layout. Building on that foundation, you learn how to perform more advanced skills, such as database administration, backup, and security.
Topics are organized into easily digestible lessons so you can learn these skills with ease. This video course, along with additional study, helps you achieve the hands-on experience recommended to take the exam and demonstrate your mastery of database fundamentals.
Customer Review
Best material and delivery of any course I've ever taken! Eric Johnson has the best manner and method for explaining and demonstrating Database "Fundamentals," which may be and unfortunate choice of words in the MTA's name: I wonder if it sounds like "Basics" or Beginner's." I soon realised that I regret not having "got" these fundamentals on my 65 hour/week job using of T-SQL support warehousing, distribution and shrinkage control for the merchandising of a global charity. I can't thank Eric enough for his thorough and smooth, non-patronising delivery. In fact this course is the main reason why I extended my 'Learning O'Reilly' subscription (paid out of my own pocket).
Skill Level
Introduction
Lesson 1: Understanding Database Concepts
Learning objectives
1.1 Understand tables
1.2 Understand and select primary keys
1.3 Understand foreign keys
Lesson 2: Understanding Database Storage
Learning objectives
2.1 Understand database normalization
2.2 Understand indexes and how they are used in databases
2.3 Configure non-clustered indexes
2.4 Configure clustered indexes
Lesson 3: Creating Database Objects
Learning objectives
3.1 Understand data definition language (DDL)
3.2 Choose appropriate data types
3.3 Create tables
3.4 Understand and create views
3.5 Understand and create stored procedures and functions
Lesson 4: Manipulating Data
Learning objectives
4.1 Understand data manipulation language (DML)
4.2 Read data using SELECT statements
4.3 Query multiple tables with join statements
4.4 Use UNION and INTERSECT statements
4.5 Add data using INSERT statements
4.6 Change data using UPDATE statements
4.7 Remove data using DELETE statements
Lesson 5: Understanding Database Security
Learning objectives
5.1 Understand the need for database security
5.2 Understand logins and users
5.3 Set permissions on database objects
5.4 Understand database roles
Lesson 6: Understanding Database Backup and Restore
Learning objectives
6.1 Understand different types of backups
6.2 Create and verify backups
6.3 Restore a database
6.4 Define a backup and recovery strategy
Summary