SQL Server Database Fundamentals: Creating, Optimizing, and Securing Databases

The Data Definition Language or DDL is used to create databases and their components. In this course, you will learn how to create databases, tables, views, and stored procedures using DDL. The learning path describes how databases can be normalized according to specific guidelines to increase storage capacity and scalability. You’ll also learn how to use indexes to make your databases more responsive. Finally, you’ll learn about the core security considerations for SQL Server databases, how to assign permissions to database objects, and how to back up and restore databases. 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 or MTA certification.