Instructor Led Database Administration Training in United States

SQL Server Programming and Database Administration Beginner to Advanced This is an extensive training course for SQL Server Database management System. It is divided into three levels: Basics, Intermediate and Advanced. For the basics level no prior experience with SQL Server Databases is expected. Some Computer Systems and Software Programming background is helpful to understand these topics. You may register for all three modules (Basic, intermediate and  more...

PostgreSQL Administration PostgreSQL Administration (5 days) As the most advanced PostgreSQL course in the industry, this course covers a broad range of diverse topics of importance to administrators. Students attending this course will learn how to administer and performance tune a database, and learn how to leverage other useful modules, such as connection pooling, full text searching, and replication. Our  more...

Oracle Database 11g R2 RAC and Grid Infrastructure for Administrators ...e components necessary to create the RAC cluster, and RAC database administration in the Oracle Grid Infrastructure environment. This will include how to configure Cluster Ready Services (CRS), the Oracle Database instances, and Oracle Net in a RAC environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and  more...

Maintaining a Microsoft SQL Server 2005 Database ...ng SQL Server Agent Security.   Lab 7: Automating Database Administration Configuring the SQL Server Agent.   Creating Operators and Jobs.   Creating Alerts.   Managing Multiple Servers.   After completing this module, students will be able to: Describe automation options in SQL Server.   Configure the SQL Server Agent.   Create jobs  more...

Oracle9i Database Administration - DBA I This course provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical  more...

Oracle8i Database Administration This course provides you with the skill-set necessary to create, maintain and manage an Oracle8i database. We focus on the techniques and skills necessary for day-to-day database administration tasks. This course has been completely updated for Oracle8i. This class will prepare you for OCP DBA Exam 2 and help prepare you for OCP DBA Exam 3. (Exam 1 topics are covered in Introduction to Oracle for  more...

Oracle9i Database Administration ...cus on the techniques and skills necessary for day-to-day database administration tasks such as security, creating users, creating object (tables, tablespaces) and backup and recovery. An in-depth discussion of database architecture is provided. This course has been completely updated for Oracle9i. Working examples are included throughout the course book and students have access to  more...

DB2 for z-OS Database Administration This course begins with a review the concepts and components of DB2 for OS/ 390. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, and triggers are  more...

DB2 Database Administration Tuning You can get a complete list of other DB2 classes at http://www.wintrac.com/courses/coursesDB2.asp  more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005 This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support configure and maintain enterprise SQL Server 2005 databases and servers.  more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005 This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. Audience This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining  more...

Oracle Database 10g Administration Workshop I ...essional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various  more...

Oracle Database 10g Administration Workshop II ...ces your success as an Oracle professional in the area of database administration. In this class, you'll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also  more...

Administering a Microsoft SQL Server 2000 Database ...d SQL Server 7.0 to SQL Server 2000.   Describe routine database administration tasks.   Automate routine maintenance tasks by creating and scheduling jobs.   Create alerts and operators.   Troubleshoot automated jobs, alerts, or notifications.   Automate administrative jobs in a multiserver environment.   Module 6: Backing Up Databases The following topics are covered in this  more...