Microsoft Virtual Academy provides free, online training to help Developers, IT and Data Professionals, and students learn the latest technology, build their skills, and advance their careers.
Direct Link: https://mva.microsoft.com/en-US/training-courses/database-fundamentals-8243?l=TEBiexJy_5904984382
The 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 database skills and knowledge today.
Introduction to Core Database Concepts
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.
Creating Databases and Database Objects
This module describes data types, database objects, DDL statements, and creating scripts.
Using DML Statements
This module covers DML statements, using the SELECT statement; using INSERT, UPDATE, and DELETE to manage data; and indexes and triggers.
SQL Server Administration Fundamentals
In this module you’ll find out about SQL Server security; securing database and objects; and performing database backups and database restores.
Recommended Resources & Next Steps for Database Fundamentals
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.