MTA 98-364: Database Fundamentals LiveLessons

6 Hours
2788

Please select the start dates for your courses below.

Scheduled Start:

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.

Skill Level

  • Beginner
Learn How To
  • Understand concepts involved with database storage
  • Perform database normalization
  • Create database objects
  • Manipulate data in databases
  • Secure databases
  • Back up and restore databases
Who Should Take This Course
  • Developers and system administrators with no prior experience working with databases
Course Requirements
  • Knowledge of Windows operating system
  • IT background with no prior database experience

Meet your instructor

Eric Johnson

Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is a co-founder of Consortio Services, and the primary Database Technologies Consultant. His background in information technology is diverse, ranging from operating systems and hardware to specialized applications and development. He has even done his fair share of work on networks. Since IT is really just a way to support business processes, he has also acquired his MBA. All in all, he has 10 years of experience with IT, a great amount of which has been working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes. He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Most recently, he presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He also does a good deal of writing, including the recent four-part series, Tour de SQL, published in Redmond magazine. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users' Group.
2788

Duration

1 week

Experience Level

Introductory

Learning Partner

Pearson

Program Type

Course

Subject

IT