eLearning Courses by Practice Area Courses

Concepts and components of an Oracle Database 11g database, how to retrieve information from it using SQL, and the steps for sorting, limiting, modifying, and formatting this information

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

Steps for manipulating queries to return the data you need, using subqueries and set operators, and manipulating the actual data using INSERT, UPDATE, DELETE, and other data manipulation language (DML) statements

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

Steps for controlling user access to objects and for maintaining these objects by dropping columns and adding constraints and indexes

Steps for querying data dictionary views to view schema objects and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows

Steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions

Steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings