It is very common for databases to be part of a company’s I.T. infrastructure. In this course, SQL Server: Understanding Database Fundamentals (98-364), you will learn the information and skills necessary to pass the 98-364 exam. First, you will learn core database concepts around database structure and how data is stored, along with statements used to create objects and manipulate data. Next, you will discover database design concepts and relational integrity, plus the impact of primary, foreign, and composite keys. Finally, you will explore how to administer a database, including authentication methods, regular database maintenance, and how to back up and restore databases. When you are finished with this course, you will have the skills and knowledge to start creating and using databases, and to pass the 98-364 Understanding Database Fundamentals exam.
Author Name: Tim Radney
Author Description:
Tim has worked with SQL server for the past 25 years, in a variety of roles including DBA, Lead DBA, and multi-department manager, which have given him extensive experience planning and implementing large-scale environment changes and upgrades. Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passi… more

Table of Contents

• Course Overview
  1min
• Introduction
  6mins
• Understanding Core Database Concepts
  13mins
• How to Create Database Objects
  27mins
• Manipulating Data
  16mins
• Understanding Data Storage
  10mins
• How to Administer a Database
  49mins