O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Fundamentals Exam 98-364

Video Description

Database administration, design and development continue to be some of the most sought-after skills in Information Technology, but where do you start to learn such a big topic? In this course, Mark Long teaches you the fundamentals about Microsoft's SQL Server database management system to help you take the first step on a path to becoming part of this exciting field. Mark has worked with SQL Server for almost 20 years and brings his experience along to present database fundamentals in an easy to understand manner to get you started. This course will also help you prepare to take Microsoft's 98-364 Database Fundamentals MTA exam so you can become Microsoft certified right away.

Table of Contents

  1. Welcome
    1. Welcome 00:01:40
    2. Course Overview 00:04:16
    3. About MTA Certification 00:06:49
    4. Microsoft Certifications 00:06:29
    5. IT as a Career 00:06:47
    6. Databases as a Specialty 00:07:17
  2. Course Prep
    1. What is SQL Server? 00:06:58
    2. Understanding T-SQL 00:05:05
    3. Getting SQL Server Express 00:05:16
    4. Installing SQL Server 00:05:21
    5. Verifying the Installation 00:05:47
    6. Management Studio Tour 00:03:02
    7. SQL Books Online 00:05:43
  3. Microsoft Resources
    1. DreamSpark 00:03:30
    2. BizSpark 00:03:03
    3. Microsoft's Website 00:05:03
    4. Microsoft PressR 00:05:58
  4. Understanding Databases
    1. What is a Database? 00:05:16
    2. Data Storage Challenges 00:07:02
    3. Database Types 00:05:00
    4. Understanding Tables 00:04:57
    5. Columns and Datatypes pt. 1 00:05:47
    6. Columns and Datatypes pt. 2 00:06:01
    7. DML and DDL 00:02:34
  5. Transact SQL Language
    1. T-SQL Coding 00:06:07
    2. Let's Store Something 00:03:25
    3. Creating a Database 00:05:31
    4. The Database File 00:03:35
    5. Creating a Table 00:05:22
    6. Inserting Data 00:04:58
    7. Retrieving Data 00:04:46
    8. The USE Command 00:04:14
    9. Deleting Data 00:05:05
    10. Understanding NULL 00:06:11
    11. Graphical Queries 00:03:00
  6. Relational Basics
    1. Relational Database Basics 00:04:04
    2. What is Normalization 00:06:24
    3. Normalization Levels 00:04:20
    4. Understanding Data Integrity 00:05:33
    5. Understanding Primary Keys 00:05:53
    6. Creating Primary Keys 00:06:41
    7. Understanding Foreign Keys 00:04:29
    8. Database Diagrams pt. 1 00:05:01
    9. Database Diagrams pt. 2 00:07:07
  7. Indexes
    1. What is an Index? 00:06:14
    2. Two Types of Indexes 00:05:52
    3. Too Much of a Good Thing 00:06:29
    4. Unique Indexes 00:03:58
    5. Creating Indexes 00:05:06
  8. More Advanced T-SQL
    1. Basic SELECT Statement 00:06:28
    2. Adding Comments 00:05:24
    3. Using Order By 00:03:57
    4. Using a Column Alias 00:04:59
    5. T-SQL Concatenation 00:04:18
    6. Using Distinct 00:03:12
    7. Using TOP 00:03:08
    8. Using LIKE and IN 00:06:39
    9. Count SUM and AVG 00:05:36
    10. SELECT INTO 00:06:27
    11. Using the UNION Statement 00:06:32
    12. Using the Intersect Statement 00:03:53
  9. Stored Procedures
    1. What is a Stored Procedure? 00:05:19
    2. Your First Stored Procedure 00:04:13
    3. What's the Big Deal? 00:05:33
    4. Using Parameters pt. 1 00:05:33
    5. Using Parameters pt. 2 00:06:42
    6. Using Parameters pt. 3 00:04:50
    7. Stored Procedure Security 00:04:51
  10. SQL Server Security
    1. Security Basics 00:05:56
    2. Working with Permissions 00:06:24
    3. Working with Roles 00:05:59
    4. Fixed Server Roles 00:04:03
    5. Fixed Databse Roles 00:04:34
    6. Beware of Deny 00:04:19
  11. Database Backup and Restore
    1. Backup Basics pt. 1 00:06:39
    2. Backup Basics pt. 2 00:04:11
    3. Performing a Backup 00:04:57
    4. Performing a restore 00:04:47
  12. Conclusion
    1. Course Wrap Up 00:05:45
  13. Credits
    1. About the Author 00:03:28