Vi ste ovdje
Overview/Description
Oracle Database 12c provides the Flashback technologies to enable databases, tables, and transactions to be flashed back. This allows users to view data from the past and apply that data to the database, if necessary. Oracle offers Flashback Database, Flashback Table, Flashback Query, and Flashback Transaction Query. Flashback Drop can be used to reinstate a dropped table from the recycle bin. This course describes and shows how to use these Flashback technologies. This course is one of a series in the Skillsoft learning path that helps prepare the learner for the...
Overview/Description
Using Data Transport, a feature in Oracle Database 12c, tablespace can be transported to other databases on the same or different platforms. It also enables the transportation of full databases. Another feature of Oracle Database 12c is Point-in-Time Recovery. This enables the recovery of one or more objects, for example tablespaces, to an earlier time without affecting other objects within the database. Point-in-Time Recovery can be performed at three levels: Tablespace, Table, and Database. This course will discuss and demonstrate how to perform data transportation and...
Overview/Description
Oracle Database 12c allows for the duplication of a database. This can be useful for numerous reasons, including for implementing a testing environment or for doing recovery operations. To duplicate a database there are various steps you need to complete to first prepare the environment when the database will be duplicated to and then the RMAN DUPLICATE command can be used. As with any tool or feature that using resources RMAN can have performance issues. These issues need to be identified and then corrected based on performance issues that was detected. Oracle Database...
Overview/Description
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.
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.2
Lesson Objectives
Oracle Database 11g: Querying a Database with SQL
identify the...
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 Objectives
Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and...
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
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)
1.9
Lesson Objectives
Oracle Database 11g: Manipulating Queries and Data...
Overview/Description
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.
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)
1.8
Lesson Objectives
Oracle Database 11g: Using DDL, Views, and Schema Objects
recognize the steps for creating,...
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
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)
1.8
Lesson Objectives
Oracle Database 11g: Controlling User Access and Managing Objects
identify the steps for granting and revoking system and object...
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
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)
1.7
Lesson Objectives
Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets
identify the...
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
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)
1.3
Lesson Objectives
Oracle Database 11g: Managing Time Zones and Datetime Functions
recognize the steps for managing time zones and time intervals.
recognize...
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
