October 2019
Beginner
6h 42m
English
Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)
Overview
6+ Hours of Video Instruction
Learn the fundamentals of databases.
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
About Pearson Video Training
Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.
Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.