|
|
 |
MS SQL Database Administrator
Summary:
Microsoft's SQL Server 2005 meets the most demanding database management system requirements of the world's largest organizations. It offers increased ease of use and scalability, and provides extensive administration capabilities that improve the scalability, reliability and availability of the enterprise DBMS.
In this hands-on course, you explore many of the SQL Server 2005 capabilities using the graphical tools provided by Microsoft. You will gain a solid foundation on which to build specific SQL Server 200 database development or administration skills.
Module 1: SQL Server 2005 Overview
- Overview of database concepts
- Architectural Overview
- SQL Server editions
- Client tools
Module 2: Database Design
- Normal Form
- Identifying primary keys
- Referential Integrity
- Designing a database using SQL server diagramming tool
Module 3: Constructing A Database Schema With Enterprise Manager
- Using the Create Database Wizard
- Designing tables
Module 4: Beginning Transact SQL Programming
- Retrieving data
- Modifying data
Module 5: Querying Multiple Tables
- Implementing inner and outer joins
- Writing self-joins
- Combining queries with UNION
Module 6: Scalar Functions
- System functions
- user-defined functions
Module 7: Aggregate Functions
- Aggregate Functions
- Grouping data
Module 8: Using and Implementing Stored Procedures
- Creating, Executing, Modifying, and Dropping Stored Procedures
- Using Parameters
- System Stored Procedures
- Extended Stored Procedures
- Error Handling in Stored Procedures
Module 9: Fundamental SQL Server Administration
- Setting up security
- Maintaining database
- Using Data Migration Tools
Module 10: Publishing Data On The Web
- Web Assistant Wizard
- Setting up a dynamic web site hands on
Module 11: Installing SQL Server
- SQL Server 2005 installation
- Setting up clients
Module 12: Storage Management
- Disk structures
- Space management strategies
Module 13: Backup And Recovery
- Transaction log architecture
- Choosing a recovery model
- Performing full, log and differential backups
- Recovering system and user databases
Module 14: Scheduling Jobs And Alerts
- The SQL Server Agent
- Multistep jobs
Module 15: Managing Security
- Login security
- Database security
- Object security
- Configuring linked servers
- SQL Server auditing
Module 16: Performance Tunning
- Monitoring SQL server
- Configurations that affect performance
- Database Design Issues
- Indexes
- Query Optimization
- Locks
Module 17: Implementing Replication
- Replication concepts
- Managing replication
Module 18: Converting And Migrating Data
- Data Transformation Services (DTS)
|
|
 |
Compu21 , founded in 1998, is a leading IT services company in the business of Professional Training, Job Placement, and IT/eBusiness Consulting.
 Flushing Office:
39 - 07 Prince Street ,
Unit 2C
Flushing, NY 11354
(718)762-1900
 E-mail:info@compu21.com
Web Site: www.Compu21.com
|
|
