Training Resources for:
Maintaining a Microsoft SQL Server 2005 Database
Total 25 record(s) available.
Maintaining a Microsoft SQL Server 2005 Database This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database. A Classroom course provided by Premier IT Group in London, United Kingdom
Maintaining a Microsoft SQL Server 2005 Database (Certificate)INIXINDO has trained more than 4000 IT professionals a year from more than 1000 national and multinational companies. INIXINDO has also established strategic alliances with big multinational IT companies such as IBM, Cisco Systems, Oracle Corp, Sun Microsystems, Microsoft, Software AG and many others.
Outstanding results that has been achieved by INIXINDO was a reflection of commitment for consistent quality of training services both from its well-experienced instructors and from comprehensive training material.
A Classroom course provided by Inixindo in Bandung, Jakarta, Palembang, Yogyakarta, Indonesia
Maintaining a Microsoft SQL Server 2005 Database (Certificate)This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Who Should Attend:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
At Course Completion:
After completing this course, students will be able to: - Install and configure SQL Server 2005 - Manage database files. - Manage security. - Perform administrative tasks. - Backup databases. - Restore databases. - Monitor SQL Server. - Troubleshoot SQL Server. - Transfer data. - Maintain high availability.
Prerequisite(s) or equivalent knowledge:
2779 Implementing a Microsoft SQL Server 2005 Database
50027 Querying and Processing SQL Server Data with SQL Statements
Prerequisite Comments:
Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
Some experience with database design
Outline: Top
Lesson 1: Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Top
Lesson 2: Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.
Lesson 3: Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Lesson 4: Managing Security
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server
Lesson 5: Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Top
Lesson 6: Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.
Features of SQL Server Integration Services
Lesson 7: Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Create Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security
Lesson 8: Implementing Replication
Overview of Replication.
Implementing Replication
Configuring Replication in Some Common Scenarios
Lesson 9: Maintaining High Availability
Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.
Implementing Peer-to-Peer Replication
A Online course provided by New Horizons Singapore in Singapore, Singapore
Maintaining a Microsoft SQL Server 2005 Database (Certificate)This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Who Should Attend:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
At Course Completion:
After completing this course, students will be able to: - Install and configure SQL Server 2005 - Manage database files. - Manage security. - Perform administrative tasks. - Backup databases. - Restore databases. - Monitor SQL Server. - Troubleshoot SQL Server. - Transfer data. - Maintain high availability.
Prerequisite(s) or equivalent knowledge:
2779 Implementing a Microsoft SQL Server 2005 Database
50027 Querying and Processing SQL Server Data with SQL Statements
Prerequisite Comments:
Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
Some experience with database design
Outline: Top
Lesson 1: Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Top
Lesson 2: Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.
Lesson 3: Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Lesson 4: Managing Security
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server
Lesson 5: Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Top
Lesson 6: Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.
Features of SQL Server Integration Services
Lesson 7: Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Create Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security
Lesson 8: Implementing Replication
Overview of Replication.
Implementing Replication
Configuring Replication in Some Common Scenarios
Lesson 9: Maintaining High Availability
Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.
Implementing Peer-to-Peer Replication
A Online course provided by New Horizons Computer Learning Centers of Pakistan in Karachi, Pakistan
Pages:- 1 2 3 4 5 6 7
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]
Tips:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.
|
|
|
