SQL Server Database Fundamentals: Design Principles and Data Manipulation

A database is used to store data in electronic format. Organizations use a Database Management System, also known as a DBMS, to control, store, organize, and retrieve that data for users. There are multiple types of databases, such as flat-file and hierarchical. The most widely used database is the relational database that stores data in relations, which are tables that store data in rows or tuples and columns or attributes. In this course, you will learn what databases, DBMS, and RDBMS are and be introduced to different database models. The course covers table design for relational databases including the data types and constraints supported by SQL Server. It also demonstrates how to use DML statements to query data and manipulate result sets. It also covers how to update and delete data from a SQL Server database and how to use transactions to ensure data and referential integrity. This course can be used as part of the preparation for Microsoft’s exam 98-364, Database Fundamentals, which leads to a Microsoft Technical Associate (MTA) certification.