| MS SQL Server 2000/2005 Training
Who should take this course?
Students who like to become SQL Server DBA for enterprises and get certified as a SQL Server 2000 certified DBA, in this course you’ll learn the foundation in basic database administration, how to install and maintain multiple instances of SQL Srever database, gain a complete understanding of the SQL Server database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including creating (new tables, columns, keys, views, indexes) database security, user management, DTS packages, Creating Multiple step jobs, Replication, backup/recovery and performance monitoring (SQL Profiler) techniques. You will also learn Transact SQL from basic to mid level to query data, joins, creating views, creating indexes, creating store procedures.
As a bonus you will get the introduction to SQL Server 2005 and its enhanced features.
Course Description:
Introduction (Database Architecture)
Describe course objectives
Explore the SQL Server database architecture
Installing the SQL Server 2000 Database Software
Explain core DBA tasks and tools
Plan a SQL Server installation
Install multiple instances
Creating an SQL Database
Create a database with the Enterprise Manager
Create a database design template with Enterprise Manager
Create a database with the Enterprise Manager
Managing the SQL Server Instance
Start and stop the SQL Server database and components
Use Enterprise Manager (EM)
Access a database with Enterprise Manager and Query analyzer
Modify database initialization parameters
Understand the stages of database startup
View the Alert log
Managing Database Storage Structures
Describe table data storage (in blocks)
Define the purpose of tablespaces and data files
Understand and utilize Oracle Managed Files (OMF)
Create and manage tablespaces
Obtain tablespace information
Describe the main concepts and functionality of Automatic Storage Management (ASM)
Administering User Security
Create and manage database user accounts
Create Logins
Create Roles
Grant and revoke privileges | Managing Data and Concurrency
Manage data through SQL
Identify and administer T-SQL Objects
Describe triggers and triggering events
Monitor and resolve locking conflicts
Implementing SQL Server Database Security
Describe DBA responsibilities for security
Apply the principal of least privilege
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail
Backup and Recovery Concepts
Identify the types of failure that may occur in an SQL Database
Learn Recovery Models
Full, simple and bulk logged
Configure Full and Transaction logs
Performing Database Backups
Create consistent database backups
Back your database up without shutting it down
Create Full and Transactional backups
Automate database backups
Monitor the backups
Performing Database Recovery
Recover databases
Recover from last full backup and transaction logs
Performance and Tuning
Learn to troubleshoot slow running queries
Usage of SQL Profiler
Using SQL query analyzer to troubleshoot
Usage of DBCC Commands
Using Query optimizer
Replication Implementation
Learn different kind of replication concepts
Implementing replication
Setting up replication agents
Monitoring replication
Creating Jobs and Alerts
Create Multiple step jobs
Configure SQL Agent
Setting up SQL mail
Creating alerts and operators associated with jobs
Monitor the alerts
| Learn T-SQL
Learn T-SQL and Query analyzer usage
Create queries to retrieve data
Create queries to manipulate data
From basics SELECT to JOINS
Learn to create views, indexes and store procedures
Moving Data
Describe available ways for moving data
Create and use DTA Packages
Explain the general architecture of DTS Pacakages
Use DTS Export and Import to move data between SQL Server databases
Usage of BCP utility for Bulk Data move
Lean SQL Server 2005 enhanced features
Learn new enhanced management studio
Learn new High availability tools like Database Mirroring
Learn new Enhanced security features
New DTS and Reporting services features
|
