Online Database Administrator Sql eLearning

Monitoring and Diagnosing Database Problems in SQL Server 2005 Monitoring and Diagnosing Database Problems in SQL Server 2005 Microsoft To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)  more...

SQL Server 2008 Database Management SQL Server 2008: Database Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) Database maintenance is an ongoing task for SQL Server 2008 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks  more...

SQL Server 2008 Database Monitoring and Performance SQL Server 2008: Database Monitoring and Performance Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) To keep SQL Server 2008 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to  more...

Managing SSIS Packages in SQL Server 2008 Managing SSIS Packages in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course  more...

Oracle Database 11g Querying a Database with SQL Oracle Database 11g: Querying a Database with SQL Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...

Oracle 11g Conversion Funct Conditional Expressions Group Funct Joins Oracle 11g: Conversion Funct., Conditional Expressions, Group Funct. & Joins Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...

Oracle Database 11g Manipulating Queries Data Oracle Database 11g: Manipulating Queries & Data Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Oracle Database 11g Using DDL Views Schema Objects Oracle Database 11g: Using DDL, Views & Schema Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...

Oracle Database 11g Controlling User Access Managing Objects Oracle Database 11g: Controlling User Access & Managing Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Managing Data Dictionary Views Large Data Sets Oracle Database 11g: Managing Data Dictionary Views & Large Data Sets Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.  more...

Oracle Database 11g Managing Time Zones Datetime Functions Oracle Database 11g: Managing Time Zones & Datetime Functions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 11g Suqueries Regular Expressions Oracle Database 11g: Suqueries & Regular Expressions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.  more...

1Z0-047 Oracle Database 11g SQL Expert 1Z0-047 Oracle Database 11g SQL Expert Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert  more...

Oracle Database 11g R2 ASM Storage Partitioning Enhancements Oracle Database 11g R2: ASM, Storage & Partitioning Enhancements Oracle Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync,  more...

Oracle Database 11g R2 Using Change Management Solutions Oracle Database 11g R2: Using Change Management Solutions Oracle Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements Oracle Database 11g R2: Intelligent Infrastructure Enhancements Oracle Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded  more...

Oracle Database 11g R2 Diagnosability Enhancements Oracle Database 11g R2: Diagnosability Enhancements Oracle Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements Oracle Database 11g R2: SQL Monitoring & Performance Enhancements Oracle Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the  more...

Oracle Database 11g R2 Application Performance Enhancements Oracle Database 11g R2: Application Performance Enhancements Oracle Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and  more...

Oracle Database 11g R2 Oracle Scheduler Secure Backup Oracle Database 11g R2: Oracle Scheduler & Secure Backup Oracle Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing Oracle Database 11g R2: Managing Concurrency, Undo & Auditing Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented  more...

Oracle Database 11g R2 Moving Data Oracle Support Oracle Database 11g R2: Moving Data & Oracle Support Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle8 Certified Database Administrator Curriculum NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT  more...

Oracle Reports R6 Control Reports Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...

SQL Server 7 0 System Administration - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure. Understand the basics of SQL Server databases and how  more...

SQL Server 7 0 System Administration - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the concepts, interfaces and fixed roles involved in performing backups. Gain a working knowledge of database, transaction log and filegroup backups and perform these  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 Course Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data  more...

SQL and PL SQL Basic SELECT Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic  more...

SQL and PL SQL Data Retrieval Techniques Course Overview This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries.  more...

SQL and PL SQL DML and DDL Course Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify  more...

Oracle8i Performance Tuning Architecture Strategy Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,  more...

Oracle8i Performance Tuning Managing Memory Disk I O Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately.  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify  more...

SQL Server 2000 Design Implement Databases Part 2 Managing Data Course Overview This is the second course in a five part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects Course Overview This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes Course Overview This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements.  more...

SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries Course Overview This course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived  more...

Oracle9i Certified Database Administrator Track Curriculum The Complete Oracle9i Certified Database Administrator Track Curriculum includes the following curriculums: Introduction to Oracle9i: SQL Curriculum (ID#8054) Oracle9i Database: Fundamentals I Curriculum (ID#8058) Oracle9i Database: Fundamentals II Curriculum (ID#8064) Oracle9i Database: Performance Tuning Curriculum (ID#8068) To review individual curriculum descriptions, please select the  more...

Oracle9i Database Admin Manage an Instance Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are  more...

Oracle9i Database Admin Perform Database Backups Course Overview This course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard  more...

Oracle SQL PL SQL Using Procedure Builder Curriculum The courses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 1 Course Overview This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft  more...

Oracle8 Backup and Recovery - Strategies and Backups Course Overview This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will  more...

Oracle8i Database Admin Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

IBM DB2 Universal Database V6 1 Admin Curriculum Course Overview The Complete IBM DB2 Universal Database V6.1 Administration Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 510. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL.  more...

IBM DB2 Universal Database V6 1 Admin Curriculum Course Overview The Complete IBM DB2 Universal Database V6.1 Administration Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 510. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL.  more...

IBM DB2 Universal Database V6 1--Administration Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement  more...

IBM DB2 Universal Database V6 1--Administration Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement  more...