SQL Server: Understanding Database Fundamentals (98-364)

Learn the fundamentals of designing, using, and maintaining a SQL Server database. This course is applicable to anyone preparing for the 98-364 exam: Understanding Database Fundamentals.
Course info
Level
Beginner
Updated
Oct 29, 2019
Duration
2h 7m
Table of contents
Course Overview
Introduction
Understanding Core Database Concepts
How to Create Database Objects
Manipulating Data
Understanding Data Storage
How to Administer a Database
Description
Course info
Level
Beginner
Updated
Oct 29, 2019
Duration
2h 7m
Description

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.

About the author
About the author

Tim is a Principal Consultant with SQLskills. He has worked with SQL server for the past 15 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.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hello, My name is Tim Rodney and welcome to my course sequel Server Understanding Database Fundamentals. I am a sequel server consultant with sequel skills as well as a Microsoft data platform. N v P. I've been fortunate to meet in network with I T professionals all over the world from speaking at events, doing in person training, Twitter and more meeting so many people, I often find myself mentoring others. Many ask, Where can I get started working with sequel server? Well, this course was built for just that reason. This course will help individuals gain an understanding of database fundamentals and help prepare individuals for the Microsoft Exam Understanding Database Fundamentals Exam 98-364 This course will begin with an introduction into what is sequel server. It's versions in additions as well as explaining what a database is. Then we'll move into core database concepts, detail ing how databases reformed and how data is stored within the database. You'll easily grasp these concepts, and then we'll move into the statements used to create objects and manipulate data from their will. Jump into high level database design concepts and how that has an impact on data storage, you learn about relations, integrity and the impact of primary foreign and composite keys. Then we'll wrap up with how to administer a database by learning authentication methods, how users can log in various maintenance that needs to be done within sequel server and how to back up in restore databases. They'll be demos all along the way to show you how all this works. You can also download sequel, server, developer Edition, sequel, server management studio and the Adventure Works database to follow along. I hope you'll join me as we explored getting started sequel server and building your knowledge of database fundamentals.