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.
What you'll learn
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.
Table of contents
- Introduction and What Are Data Types? 2m
- Exact and Approximate Numerics 4m
- Unicode and Binary Strings 2m
- Date/Time, Character Strings, and Other Data Types 4m
- Demo: Data Types 3m
- Tables and Views 1m
- Demo: Tables and Views 4m
- Stored Procedures and Functions 3m
- Demo: Stored Procedures and Functions 3m
- Module Summary 1m
- Introduction and Authentication 3m
- Users 3m
- Database Permissions 2m
- Objects and Permissions 2m
- Database Roles 2m
- Demo: Users, Roles, and Permissions 6m
- Maintenance Tasks 5m
- Demo: Maintenance Processes 6m
- Backups and Disaster Recovery 4m
- Demo: Backup, Restore, and Recovery Models 13m
- Module and Course Summary 3m
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. Tim is a SQL Server 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 S... more