|
Provided by: Insider Training Live Online:MCDBA +LIVEMCDBA Certification |
 |
Training
Provided by Insider Training
Presented online by a live instructor - Online ILT
Presented online with a live expert instructor (online ilt)
Our complete MCDBA 2003 packages give you the expert knowledge and hands-on experience you need to master Windows 2003 and SQL Server and pass all four Microsoft exams. For one low price, you'll tap into the most powerful learning system available anywhere. The Insider Training Multi-Path Learning System will maximize what you learn, and more importantly, how much you retain.
This course provides a comprehensive learning track for systems administrators and developers to understand both the database administration and design processes using Microsoft SQL Server 2000. The course initially focuses on developing a strong background in both Windows 2003 Server and network design. After addressing the underlying architecture that SQL Server relies upon, the second half of the course focuses intensely on database administration and the fundamentals of database programming and design.
|
|
||||||||||||||
Live Online:MCDBA +LIVE
Windows 2003 Server Administration
- Overview
- Installation and Deployment
- Active Directory Overview
- Managing Local and Domain Users
- Managing Local and Domain Groups
- Introduction to TCP/IP
- Sharing Resources
- NTFS File and Directory Permissions
- Group and Local Security Policy
- Introduction to Group Policy
- Security Policies and Templates
- Security Tools
- Designing and Implement an Effective IPSec Strategy
- Advanced Security Strategies
- Auditing
- Data Storage
- Managing File and Print Servers
- Managing Application Servers
- Reliability and Availability
- Backup and Restore
- Introduction to Routing and Remote Access
- Command Line Management Tools
- Overview of Important 3rd Party Tools
- Overview
- TCP/IP Architecture and Addressing
- Subnetting
- Planning Server Roles and Security
- Planning Network Traffic Monitoring
- Designing DHCP
- Designing DNS
- Designing WINS
- Designing Remote Access
- Designing Internet Connectivity
- Designing Microsoft VPNs
- Routing Protocols
- Analyze Protocol Security Requirements
- Designing NAT
- Planning Microsoft Clustering
- Planning Microsoft Load Balancing
- Plan Backup and Recovery Strategies
- Planning IPSec Policies
- Planning Certificate Services
- Command Line Management Tools
- Overview of Important 3rd Party Tools
- Overview of SQL 2000 Features
- Installing SQL 2000
- Upgrading to SQL 2000
- Installing in a clustered environment
- Configuring a SQL 2000 cluster
- Using graphical administration tools
- Using command-line administration tools
- Introduction to the T-SQL language
- Understanding Transactions and Logs
- Managing Database Files
- Managing Transaction Logs
- Managing File Groups
- Security Design and Administration
- Automating SQL Tasks
- Creating and Troubleshooting Jobs, Alerts and Operators
- Integrating SQL 2000 with Exchange
- Designing a backup strategy
- Understanding disaster recovery
- Implementing disaster recovery procedures
- Importing and exporting data
- Understanding Data Transformation Services (DTS)
- Creating complex data transfer jobs
- Monitoring SQL 2000 Performance
- Using the SQL 2000 Profiler
- Optimizing SQL 2000 Performance
- Understanding Capacity Planning
- Managing SQL 2000 in a clustered environment
- Using Standby Servers and Log Shipping
- Understanding Data Replication
- Selecting a replication type
- Selecting a replication model
- Designing Secure Internet Access to SQL 2000
- Overview of SQL 2000 Programming
- Understanding Data Structures
- Selecting and Creating Data Types and Tables
- Generating Object Scripts
- Understanding Data Integrity
- Designing and Creating Constraints
- Designing and Creating Rules
- Understanding Indexes
- Planning Indexes
- Creating and Troubleshooting Indexes
- Understanding Views
- Designing and Creating Views
- Understanding Stored Procedures
- Creating and Implementing Stored Procedures
- Understanding User-defined functions
- Creating and Implementing User-defined Functions
- Understanding Triggers
- Creating and Implementing Triggers
- Understanding Query Optimization
- How to Analyze SQL 2000 Queries
- Understanding the impact of operators within queries
- Understanding Joins
- Understanding Distributed Queries
- Partitioning Views Across Servers
- Managing Locks
- Advanced T-SQL Topics
About The Training Provider: Insider Training
Insider Training - When has an IT training company done all this for you?
GUARANTEE industry expert instruction by trainers with at least 10 years of experience
DIGITALLY RECORD every class session, enabling you to review records as often as you like for up to one full year
ALLOW YOU to miss a class day and not fall behind on the material
GIVE YOU access after class to a video library of useful...
