Microsoft Technology Associate (MTA): Database: 98-364: Database Fundamentals

  • 6 Courses | 5h 39m 6s
  • 6 Books | 39h 41m
Likes 49 Likes 49
Discover fundamental knowledge of databases as you prepare for the MTA: Database certification.


Database Design
A Database Management System, also known as a DBMS, is used to control, store, organize, and retrieve that data. Discover databases, DBMS, and RDBMS, and explore different database models.
9 videos | 1h 14m has Assessment available Badge
DML & Multi-table Queries
A relational database stores data in tables that store data in rows or tuples and columns or attributes. Explore how to use DML statements to query data and manipulate result sets.
10 videos | 1h 10m has Assessment available Badge
Working with Data
Discover how to update and delete data from a SQL Server database and how to use transactions to ensure data and referential integrity.
6 videos | 44m has Assessment available Badge
Components, Procedures, & Functions
The Data Definition Language (DDL) is used to create databases and their components. Discover how to create databases, tables, views, and stored procedures using DDL.
8 videos | 1h 1m has Assessment available Badge
Normalization & Indexes
Data redundancy negatively affects storage, scalability, and responsiveness. Learn how to use database normalization and indexes in SQL Server to counter these negative effects.
7 videos | 44m has Assessment available Badge
Database Security
A major concern for any database administrator is data security. Explore security considerations for SQL Server databases, how to assign permissions to database objects, and how to back up and restore databases.
6 videos | 44m has Assessment available Badge


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.



Relational Database Design and Implementation, Fourth Edition
Including three case studies, each illustrating a different database design challenge, this book provides the conceptual and practical information necessary to develop a database design and management scheme that ensures data accuracy and user satisfaction while optimizing performance.
book Duration 9h 8m book Authors By Jan L. Harrington


Physical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More
Discussing the concept of how physical structures of databases affect performance, this book includes specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations.
book Duration 7h book Authors By Sam Lightstone, Toby Teorey, Tom Nadeau


Securing SQL Server: DBAs Defending the Database
Providing practical advice and engaging examples, this book will help you protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, perform threat analysis, and encrypt sensitive data as a last line of defense against compromise.
book Duration 2h 10m book Authors By Peter A. Carter


Securing SQL Server: Protecting Your Database from Attackers, Third Edition
Authored by Denny Cherry, a Microsoft SQL MVP and one of the biggest names in SQL server, this book will teach you how to properly secure an SQL server database from internal and external threats using best practices as well as specific tricks that he employs in his role as a consultant for some of the largest SQL server deployments in the world.
book Duration 8h 19m book Authors By Denny Cherry


Fundamentals of Database Management Systems, Second Edition
Offering a highly focused and applied approach, this compact, practical introduction emphasizes fundamental database concepts and presents them in a clear, easy-to-understand way.
book Duration 8h 13m book Authors By Mark L. Gillenson


Beginning Database Design: From Novice to Professional, Second Edition
Offering numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers, this book will help you learn to discover and represent the details and scope of any design problem you choose to attack.
book Duration 4h 51m book Authors By Clare Churcher


CHANNEL Data Engineer
Likes 239 Likes 239  
Likes 112 Likes 112