Courses
Courses Designed For Beginners, Seasoned IT Pros & Everyone In Between
Microsoft MTA: Database Administration Fundamentals
View All CoursesThis is a practical course for someone new to relational databases that moves you through basic concepts right into real-world usage, demonstrating core tasks in Microsoft SQL Server itself. You'll not only gain new knowledge, but cement that knowledge by seeing it in action and being able to follow along at home.
Lessons
-
Lesson Clips
- Introduction
-
Lesson Clips
- Introduction
- What's a Database?
- Flat-File Databases
- Hierarchical Databases
- Relational Databases
- What We Covered
-
Lesson Clips
- Introduction
- Tables, Rows, and Columns
- Normalization Overview
- Indexes
- Storage: Pages and Physical Files
- What We Covered
-
Lesson Clips
- Introduction
- Data Types
- Data Type Storage
- Data Conversions
- What We Covered
-
Lesson Clips
- Introduction
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Control Language
- What We Covered
-
Lesson Clips
- Introduction
- Where to Get It
- Exploring the Interface and Identifying Key Objects
- Executing Queries
- Other Tools
- What We Covered
-
Lesson Clips
- Introduction
- Creating Tables in the GUI
- Creating Tables by Using DDL
- Reviewing Existing Table Designs
- System Tables
- What We Covered
-
Lesson Clips
- Introduction
- The Purpose of Views
- Creating Views in the GUI
- Creating Views by Using DDL
- Views vs. Tables
- What We Covered
-
Lesson Clips
- Introduction
- The Purpose of Stored Procedures
- Creating Stored Procedures in the GUI
- Creating Stored Procedures by Using DDL
- Executing Stored Procedures
- Understanding SQL Injection
- What We Covered
-
Lesson Clips
- Introduction
- SELECT...FROM
- WHERE
- ORDER BY
- Column Aliases
- What We Covered
-
Lesson Clips
- Introduction
- Operators
- Combining Conditions
- IN
- LIKE
- BETWEEN
- UNION
- EXCEPT and INTERSECT
- What We Covered
-
Lesson Clips
- Introduction
- The JOIN Clause
- Performance and Multi-Table Queries
- INNER JOIN
- OUTER JOIN
- What We Covered
-
Lesson Clips
- Introduction
- INSERT INTO
- UPDATE
- DELETE
- TRUNCATE TABLE
- DROP TABLE
- Overview: Referential Integrity
- What We Covered
-
Lesson Clips
- Introduction
- 1NF: Eliminate Repeating Groups
- 2NF: Eliminate Redundant Data
- 3NF: Eliminate Non-Dependent Columns
- 4NF: No Independent Multiple Relationships
- 5NF: Isolate Semantically Related Relationships
- Denormalization
- What We Covered
-
Lesson Clips
- Introduction
- Primary Keys
- Foreign Keys and Composite Keys
- Understanding Constraints
- What We Covered
-
Lesson Clips
- Introduction
- Clustered Indexes
- Non-Clustered Indexes
- Page Index Splits
- Index Maintenance Concepts
- What We Covered
-
Lesson Clips
- Introduction
- Server-Level Security and Database-Level Security
- Windows vs. SQL Security
- Object Permissions
- Ownership Chains
- What We Covered
-
Lesson Clips
- Introduction
- Recovery Models
- Database Backups
- Backup Devices
- Restoration Process
- What We Covered
-
Lesson Clips
- Introduction
- Statistics
- Indexes
- Backups
- Maintenance Plans
- What We Covered
-
Lesson Clips
- Introduction
-
Lesson Clips
- Introduction
Instructor
Don Jones
Don Jones' broad IT experience comes from 20 years in the business, with a strong focus on Microsoft server technologies. He's the author of more than 45 technology books, including titles on administration and software development, and writes monthly columns for the industry's leading periodicals. He's an in-demand speaker at technical conferences and symposia worldwide, and is widely recognized as one of the top trainers in the Microsoft sector.
