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 a new and innovative certification track designed to provide a pathway for future success in technology courses and careers. The MTA program curriculum helps instructors teach and validate fundamental technology knowledge and provides students with a foundation for their careers as well as the confidence they need to succeed in advanced studies. Through the use of MOAC MTA titles you can help ensure your students future success in and out of the classroom. 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.

Those beginning studies in technology need a strong foundation in the basics before moving on to advanced technology courses and certification programs. MTA Database Administration Fundamentals is a new and innovative certification track that provides a pathway for future success in technology courses and careers. The MTA program curriculum helps teach and validate fundamental technology concepts, thus providing a foundation for careers as well as confidence needed to succeed in advanced studies. MOAC supports the MTA certification as well as any course where foundational technology concepts are taught.

"Database administration, design and development continue to be some of the most sought-after skills in Information Technology, but where do you start to learn such a big topic? In this course, Mark Long teaches you the fundamentals about Microsoft's SQL Server database management system to help you take the first step on a path to becoming part of this exciting field. Mark has worked with SQL Server for almost 20 years and brings his experience along to present database fundamentals in an easy to understand manner to get you started. This course will also help you prepare to take Microsoft's 98-364 Database Fundamentals MTA exam so you can become Microsoft certified right away."--Resource description page.

Complete coverage of the Microsoft Technology Associate exam 98-364. Starting form zero, this book is intended for everyone studying for the MTA Database Fundamentals exam, and everybody interested in learning about SQL Server in general. Using screen shots and sample code, this book delivers all the relevant information in the easiest way. It also includes test questions and exam tips. After studying this book, you'll have learnt a lot about databases in general, SQL Server in particular and be ready for the exam!

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

The Microsoft Technology Associate MTA certification is an entry-level certification which serves as a good starting point for students and educators who may eventually progress to the higher programs. Simply put, it assesses the foundational knowledge necessary to pursue MCSE, MCSD and the like. The MTA certification focuses more on knowledge and a little less on skills. However, the knowledge areas are all based on MS products so you must know those products inside and out. Questions on the general knowledge are relatively easy. Product and technology specific technical questions, however, are way more difficult. This is why we developed this study product - we focus on those difficult topics that involve difficult technical skills. We want you to be able to answer these difficult questions and secure exam success accordingly. Exam 98-364: Database Fundamentals is designed to allow candidates to assess their knowledge of and skills with SQL Server databases and operations. Topics covered include: Understanding Core Database Concepts Creating Database Objects Manipulating Data Understanding Data Storage Administering a Database

Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Create database objects Work with data Modify data Troubleshoot and optimize queries You also get an exam discount voucher—making this book an exceptional value and a great career investment.