Updated May 2008
Microsoft SQL Server 2005 Video CBT Course by Examples
for DBA and Developers.
1 .Introduction SQL Server Overview Transact SQL
Installing SQL Server 2005
sql, T-SQL
tables, procedure,functions,index, views,
transactions ,cursor,
xml, service
principal ,securables ,permissions
Administrative Tools
2. Using Transact-SQL on a SQL Server Database
introduces you
to Transact-SQL and provides details about how to create and execute Transact-
SQL statements in order to manage a SQL Server database and its data. The
chapter also introduces you to the SQL Server programming tools that allow
you to use Transact-SQL to interface with the database.
3. Designing a SQL Server Database
introduces you to the process
of creating a SQL Server database. It describes the basic concepts of database
design and provides information about planning a database, identifying system
requirements, and developing a logical data model.
4. Implementing SQL Server Databases and Tables
explains how to
create and manage a SQL Server database. It then discusses data types and how
to identify which ones to use when creating a table. The chapter also describes
how to create these tables¡ªusing the data type information¡ªand how to modify
the tables after they have been created.
5. Implementing Data Integrity
provides an overview of the various
methods that you can use to maintain data integrity and a description of the types
of data integrity that you will find in a SQL Server database. The chapter also
provides detailed information about the various types of integrity constraints that
you can use to enforce data integrity and how to implement them in a database.
6. Accessing and Modifying Data
provides detailed information
about four Transact-SQL statements (SELECT, INSERT, UPDATE, and
DELETE) and describes how each statement is used in Query Analyzer to
retrieve and modify data. This chapter also introduces you to other methods for
adding, modifying, and deleting data.
7. Managing and Manipulating Data
describes more techniques for
managing and manipulating data, including how to import and export data, how
to manipulate heterogeneous data, how to use Transact-SQL cursors, and how
to extract data in XML format.
8.Implementing Stored Procedures.
introduces you to the types of
stored procedures available in SQL Server and how to create, execute, and
alter them. You are also introduced to programming stored procedures.
9. Implementing Triggers
introduces you to triggers and how to use
them to extend data integrity and implement complex business logic. You will
learn when it is appropriate to implement triggers and when basic constraints
will suffice. You will also learn how to program triggers and how to use system
commands and functions commonly used in trigger programming.
10. Implementing Views
introduces you to views and the various
functionality that they support. You will learn how to use views to insert,
update, and modify data.
11. Implementing Indexes
introduces you to the structure and purpose
of indexes and the types and characteristics of indexes. You will learn how
to determine when an index is appropriate, the type of index to create, and how
to create it.
12. Managing SQL Server Transactions and Locks
introduces you to
the fundamentals of transactions and locks and describes how transactions and
locks are used to process data modifications.
13. Designing and Administering SQL Server Security.
introduces
you to SQL Server security. You will learn how to design SQL Server
security to accommodate user requirements and protect the database from
unauthorized access.
14. SQL Server Monitoring and Performance Tuning
examines how to use SQL
Profiler to monitor a database system and explores methods of improving database
performance through partitioning and index tuning.
15. Distributed database
Distributed daatbase design and implementation
16. Database Backups
Restoring Data , maintenance,Data Storage
SQL Profiler ,High Availability
and more
.....
-----------------------------------------------------------------
System requirements
It is regular DVD format. It can be played on a regular home DVD player . It can also be played on a computer with DVD rom.
License Agreement
The price is for 1 license only . You can use by yourself or use it in a classroom as long as the main user is at the scene. You are not allowed to duplicate any part of the video.