|
|
Title |
Duration |
|
|
|
Series Intro
Get a quick overview of the series plus learn what to expect on the 70-443 exam for MCITP certification. Plus learn about the new features you'll see in SQL Server 2005, which version is right for you, and where you can download SQL Server 2005 online -- including a 180-day free trial of SQL Server 2005 Enterprise Edition you can use during your training.
|
00:24:34 |
|
|
|
Capacity Planning
Here's where we start getting into the real meat of the series. Databases can grow quickly and your capacity has to match your need. Learn how to plan for the capacity you need, predict the size of your growing database, and manage the size of your log files. Plus get an understanding of the SQL Server architecture and how that effects your planning.
|
00:31:50 |
|
|
|
Server-Level Security
The server hosting your database stores the company's most sensitive and critical information -- and you have to keep it secure. Learn about security requirements, managing SQL Server passwords, how encryption works in SQL Server 2005, and how to configure antivirus software and firewalls to work with SQL Server 2005.
|
00:24:00 |
|
|
|
Database-Level Security
Once you've secured your database at the server level, you have a couple more security measures to enact at the database level. In this video you'll learn to manage users, groups, and roles in SQL Server 2005 -- plus you'll learn about managing schemas, including the new distinction in SQL Server 2005 between schemas and users. Finally, you'll learn how to create Data Definition Language (DDL) triggers that react to DDL events and prevent certain types of DDL events from happening.
|
00:27:14 |
|
|
|
Encryption
You learned the basics of encryption during video 3, but now it's time to put it in action. Walk through how to encrypt database objects, enforcing encryption across the network, and how to use keys and certificates in SQL Server 2005.
|
00:28:47 |
|
|
|
Object Security
There's one more level of security you can put in place on SQL Server 2005 -- object-level security. In this video you'll develop an in-depth understanding of granting, revoking, and denying permissions to objects plus how to define execution context.
|
00:21:08 |
|
|
|
Planning Your Database
Efficiency is key to making your database perform well -- and the best way to ensure an efficient database is to plan it out as much as possible before you start. Discover what it takes to plan an efficient database, why normalization is important, how to document your schema using scripting, and finally how to diagram your database for easy reference.
|
00:26:20 |
|
|
|
Designing Tables
All your data ends up in tables. In this video you'll learn the importance of defining the right data type for the data in your tables, how to define primary keys, foreign keys, unique keys, defaults, and check constraints. Also learn how to create columns whose values are computed based on data elsewhere in your tables, and how to create your own data types when your needs go beyond what the built-in data types allow.
|
00:29:09 |
|
|
|
Files and Filegroup Management
Looking at all the data in your database, it's easy to forget that all that data is actually being stored in files somewhere. Learn how to design your file structure and -- more importantly -- your filegroups. This will help your database perform better, make backups and restoration easier, and allow for partitioning of data.
|
00:21:33 |
|
|
|
Designing Indexes
Indexes give your database a shortcut way to find data deep inside large tables. Learn how to create indexes, including clustered and non-clustered indexes, unique indexes, an index with an included column, indexed views, XML indexes, and full-text indexes. Also learn how to design your indexes for performance so you're not sitting around all day waiting for your queries to finish executing.
|
00:26:23 |
|
|
|
Highly Available Solutions
When your database is critical to day-to-day business functioning, such as in e-commerce, banking, or at a medical facility, your database has to stay up and running. Learn how to make your SQL Server database highly available, including how to avoid single points of failure and what clustering, mirroring, and log shipping can do to make sure your data stays safe and always available.
|
00:23:58 |
|
|
|
Database Mirroring
In this video we go in-depth into database mirroring -- an important database performance task. This includes understanding the basics of mirroring, knowing the difference between high performance, high protection, and high availability protection modes, and also gaining a deeper understanding of the differences between clustering and mirroring.
|
00:26:25 |
|
|
|
Replication
Replication protects your data from loss, but it also has other important benefits. You can use replication to create a test database to run applications against before they go live, do load balancing, and even to separate your data entry from reporting -- plus a lot more. Learn the different replication roles including publisher, distributor, and subscriber, as well as types of replication including snapshot, transactional, and merge. Plus learn about standalone programs that help with replication, and finally some design considerations when you're doing replication.
|
00:32:17 |
|
|
|
Archiving, Backup, and Recovery
Learn the benefits of archiving data, how to fully back up your database, and the quickest and easiest ways to recover from database failure. This includes information on log shipping for redundancy and reporting, and how to design complete backup and recovery solutions for SQL Server 2005.
|
00:33:57 |
|
|
|
Consolidating Databases
Discover the pros and cons of database consolidation. This includes server consolidation, instance consolidation, and storage consolidation, plus geographic consolidation which is a combination of those three. Plus gather the requirements for consolidating multiple SQL Server databases, and monitor the environments through the consolidation process.
|
00:22:41 |
