Imate žicu za učenje?

Oracle Database 11g: Controlling User Access and Managing Schema Objects

Overview/Description To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI). Expected Duration (hours) 1.8 Lesson ObjectivesOracle Database 11g: Controlling User Access and Managing Schema Objects identify the steps for granting and revoking system and...

Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins

Overview/Description 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. Target Audience Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators. Prerequisites Familiarity with data processing concepts and techniques Expected Duration (hours) 2.0 Lesson ObjectivesOracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins identify the...

Oracle Database 11g: Conversion Functions, Group Functions, and Joins

Overview/Description 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. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI) Expected Duration (hours) 2.0 Lesson ObjectivesOracle Database 11g: Conversion Functions, Group Functions, and Joins identify the...

Oracle Database 11g: Data Dictionary Views and Large Data Sets

Overview/Description 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. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI). Expected Duration (hours) 1.7 Lesson ObjectivesOracle Database 11g: Data Dictionary Views and Large Data Sets identify the steps...

Oracle Database 11g: Database Architecture and ASM

Overview/Description To recognize the structural elements in Oracle Database 11g's architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I Expected Duration (hours) 1.7 Lesson ObjectivesOracle Database 11g: Database Architecture and ASM identify the characteristics of...

Oracle Database 11g: Database Architecture and Installation

Overview/Description Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators Prerequisites A working knowledge of SQL Expected Duration (hours) 2.0 Lesson ObjectivesOracle Database 11g: Database Architecture and Installation identify the main structural components of Oracle Database 11g. identify the components of the Oracle Database 11g memory structures. identify the functions of...

Oracle Database 11g: Database Auditing

Overview/Description Monitoring or auditing should be an integral part of your security procedures. Oracle Database 11g includes auditing tools for database, user, and fine-grained auditing. This course explores how to implement basic database auditing, privileged user auditing, DML and DDL auditing, and how to send audit records to the operating system files. Implementing fine-grained auditing (FGA), maintaining FGA policies, implementing an FGA audit event handler, and reading FGA audit events from the FGA audit trail are also covered. Target Audience Database administrators, security...

Oracle Database 11g: Database Creation, Instance Management, and Connectivity

Overview/Description Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators Prerequisites A working knowledge of SQL Expected Duration (hours) 2.5 Lesson ObjectivesOracle Database 11g: Database Creation, Instance Management, and Connectivity recognize the steps for creating, configuring, or deleting a database using...

Oracle Database 11g: Database Performance and Space Management

Overview/Description To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I Expected Duration (hours) 2.7 Lesson ObjectivesOracle Database 11g: Database Performance and Space Management...

Oracle Database 11g: Database Replay and Automatic SQL Tuning

Overview/Description Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database Target Audience Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g Prerequisites The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role Expected Duration (hours) 2.6 Lesson...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?