This database training for beginners introduces and defines the terminology, concepts, and skills you need to understand database objects, security requirements, graphical tools, T-SQL scripts, and writing database queries, in addition to executing stored procedures. It also helps you prepare for Exam 98-364, part of a Microsoft Technology Associate (MTA) certification. The database training course is designed for individuals seeking to learn database fundamentals, including relational databases, database management systems, and database components. Take this free course and expand your knowledge today.
Associated Exam(s) | 98-364: Database Fundamentals Related Certification | MTA Associated Course(s) | 40364A: Database Administration Fundamentals: MTA Exam 98-364
This module defines databases, provides examples of relational database tables, and introduces common database terminology.
In this module you’ll learn about normalization, referential integrity, and constraints.
This module describes data types, database objects, DDL statements, and creating scripts.
This module covers DML statements, using the SELECT statement; using INSERT, UPDATE, and DELETE to manage data; and indexes and triggers.
In this module you’ll find out about SQL Server security; securing database and objects; and performing database backups and database restores.
Please peruse this section for additional information that supports this course. This is an opportunity for you to dive deeper into Database Fundamentals at your own pace.
Free Microsoft Training Delivered by Experts