Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print Page
Click here for other MS SQL CoursesMicrosoft SQL Server 2000 System Administration (MCP)
Description:
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000.
- Cost: €1295.00
- Duration: 4 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Experience using the MS Windows 2000 O.S.. An understanding of basic relational database concepts, including:
Logical and physical database design.
Data integrity concepts.
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
How data is stored in tables (rows and columns).
Logical and physical database design.
Data integrity concepts.
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
How data is stored in tables (rows and columns).
Introduction to Microsoft SQL Server:
Exploring the Components of SQL Server
Administering SQL Server
Administering SQL Server
Installing SQL Server:
Identifying the Requirements for Installing SQL Server
Installing the SQL Server
Exploring the SQL Sever Installation
Troubleshooting the SQL Server Installation
Installing the SQL Server
Exploring the SQL Sever Installation
Troubleshooting the SQL Server Installation
Designing and Implementing Databases:
Developing a Strategy for Implementing Databases
Creating Databases
Managing Databases
Creating Databases
Managing Databases
Creating and Managing Tables:
Creating Tables
Using Transact-SQL to Work with Tables
Using Transact-SQL to Work with Tables
Designing and Configuring SQL Server Security:
Identifying the Security Features of SQL Server
Creating Login Accounts
Assigning Login Accounts as Database Users
Implementing statement and object Permissions
Defining Linked Servers
Creating Login Accounts
Assigning Login Accounts as Database Users
Implementing statement and object Permissions
Defining Linked Servers
Importing and Exporting Data:
Introduction to Data Transfer
Bulk Data Transfers
Configuring XML Support
Bulk Data Transfers
Configuring XML Support
Backing Up SQL Server Databases:
Planning Backups
Performing a Backup
Designing Your Backup Strategy
Performing a Backup
Designing Your Backup Strategy
Restoring SQL Server Databases:
Restoring User-defined Databases
Recovering System Databases
Recovering System Databases
Automating SQL Server Administration:
Configuring SQL Server to Send Mail
Defining SQL Operators
Managing Jobs
Managing Alerts
Defining SQL Operators
Managing Jobs
Managing Alerts
Designing, Configuring and Managing Replication:
Introduction to Replication
Configuring Replication
Monitoring and Maintaining Replication
Troubleshooting Replication
Configuring Replication
Monitoring and Maintaining Replication
Troubleshooting Replication
Implementing Fault Tolerance:
Configuring Fault Tolerance in SQL Server 2000
Monitoring SQL Server:
Designing a Strategy for Monitoring SQL Server
Using Monitoring Tools
Using Monitoring Tools