Oracle Database 11g SQL Fundamentals I (1Z0-051) - Online Course

The Oracle Database 11g: Fundamentals I study guide will prepare you to become certified as an Oracle Database 11g Administrator Certified Associate. This series will cover both basic and in-depth database administration topics, such as using SQL to retrieve, restrict, and sort data, along with using functions, subqueries, and reporting.

This series is for anyone who is preparing for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam. This online course contains 7 lessons and 3 practice exams and should take approximately 15 hours to complete.

Lesson 1: Introduction to SQL (2.0) hours

Introduction to SQL teaches you how to list the capabilities of SQL SELECT statements, execute a basic SELECT statement, limit the rows that are retrieved by a query, sort the rows that are retrieved by a query, and use ampersand substitution to restrict and sort output at runtime. This course covers Oracle SQL fundamentals such as the various types of SQL statements, and it also introduces SQL*Plus and a few SQL*Plus commands. You'll also learn the uses of SELECT statements. Topics include Introduction to SQL.

Lesson 2: Using Single-Row Functions (4.0) hours

Using Single-Row Functions teaches you how to describe various types of functions available in SQL, use character, number, and date functions in SELECT statements, describe various types of conversion functions that are available in SQL, use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions, and apply conditional expressions in a SELECT statement. This course explores single-row functions that can be called from SQL statements. These functions include character, numeric, date, conversion, and miscellaneous functions. The material covers the functions that are available, the rules for using them, and additional information you need to know for the exam. Topics include Single-Row Fundamentals, Using Single-Row Character Functions, Using Single-Row Numeric Functions, Using Single-Row Date Functions, Using Single-Row Conversion Functions, and Using Other Single-Row Functions.

Lesson 3: Using Group Functions (1.0) hour

Using Group Functions teaches you how to identify the available group functions, describe the use of group functions, group data by using the GROUP BY clause, and include or exclude the grouped rows by using the HAVING clause. This course covers group function fundamentals including the use of aggregate functions such as GROUP BY and HAVING. It also addresses creating superaggregates and nesting functions. Topics include Using Group Functions.

Lesson 4: Using Joins and Subqueries (1.0) hour

Using Joins and Subqueries teaches you how to write SELECT statements to access data from more than one table using equijoins and nonequijoins, join a table to itself by using a self-join, view data that generally does not meet a join condition by using outer joins, generate a Cartesian product of all rows from two or more tables, define subqueries, describe the types of problems that the subqueries can solve, list the types of subqueries, write single-row and multiple-row subqueries, describe set operators, use a set operator to combine multiple queries into a single query, and control the order of rows returned. This course covers the use of table joins to relate two or more tables. It discusses the use of set operators to combine the results of more than one query into one. This course also examines the use of subqueries to manipulate data. Topics include Using Joins and Subqueries.

Lesson 5: Manipulating Data (1.0) hour

Manipulating Data teaches you how to describe each data manipulation language (DML) statement, insert rows into a table, update rows in a table, delete rows from a table, and control transactions. This course covers manipulating data using SQL data manipulation language (DML) statements and coordinating multiple changes using transactions. It also covers inserting new data into a table, updating existing data, and deleting existing data from a table. Topics include Manipulating Data.

Lesson 6: Creating Tables and Constraints (2.0) hours

Creating Tables and Constraints teaches you how to categorize the main database objects, review the table structure, list the data types that are available for columns, create a simple table, explain how constraints are created at the time of table creation, and describe how schema objects work. This course covers the main database objects. It also covers the use of DDL statements to create and manage tables, as well as the application of constraints to columns. Topics include Creating Tables and Constraints.

Lesson 7: Creating Schema Objects (1.0) hour

Creating Schema Objects teaches you how to create simple and complex views, retrieve data from views, create, maintain, and use sequences, create and maintain indexes, and create private and public synonyms. This course covers creating and maintaining four types of schema objects: views, sequences, indexes, and synonyms. Topics include Creating Schema Objects.

3 Practice Exams

This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.