Vi ste ovdje
Overview/Description
SkillSoft Mentors are available to help students with their studies for exam 1Z0-047 Oracle Database SQL Expert. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.
Expected Duration (...
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...
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...
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...
Overview/Description
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
1.9
Lesson ObjectivesOracle Database 11g: Getting Started With PL/SQL
recognize the features and capabilities of SQL...
Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
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.3
Lesson ObjectivesOracle Database 11g: Managing Data in Different Time Zones
recognize the steps for managing time zones and time intervals.
recognize the...
Overview/Description
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and
portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 11g: Packages, Dynamic SQL, and Coding Considerations
recognize the steps for overloading subprograms, using forward...
Overview/Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
1.3
Lesson ObjectivesOracle Database 11g: PL/SQL Code and Dependency Management
identify the steps for selectively including PL/SQL source code by using conditional compilation, and for...
Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 11g: Subprograms, Packages, and Exception Handling
identify the benefits of modularized and layered subprogram design.
recognize the...
Overview/Description
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.
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.9
Lesson ObjectivesOracle Database 11g: Subqueries, Set Operators, and...
- 1 od 2
- ››
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
