Oracle Database 11g SQL Fundamentals I (1Z0-051) Online Training Course
Course Topics: 10
Estimated Time Needed: 15 hour(s)
Audience: This training course is for anyone who is preparing for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Course Description: The Oracle Database 11g: Fundamentals I study guide will prepare you to become certified as an Oracle Database 11g Administrator Certified Associate. This online course 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.
Click here to watch a preview from one Oracle Database 11g SQL Fundamentals I (1Z0-051) lesson
Course Tutorials Include:
Oracle Database 11g SQL Fundamentals I (1Z0-051): 1 Introduction to SQL
Description
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.
Objectives
- 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
- Use ampersand substitution to restrict and sort output at runtime
Oracle Database 11g SQL Fundamentals I (1Z0-051): 2 Using Single-Row Functions
Description
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.
Objectives
- 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
- Apply conditional expressions in a SELECT statement
Oracle Database 11g SQL Fundamentals I (1Z0-051): 3 Using Group Functions
Description
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.
Objectives
- Identify the available group functions
- Describe the use of group functions
- Group data by using the GROUP BY clause
- Include or exclude the grouped rows by using the HAVING clause
Oracle Database 11g SQL Fundamentals I (1Z0-051): 4 Using Joins and Subqueries
Description
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.
Objectives
- 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
- Control the order of rows returned
Oracle Database 11g SQL Fundamentals I (1Z0-051): 5 Manipulating Data
Description
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.
Objectives
- Describe each data manipulation language (DML) statement
- Insert rows into a table
- Update rows in a table
- Delete rows from a table
- Control transactions
Oracle Database 11g SQL Fundamentals I (1Z0-051): 6 Creating Tables and Constraints
Description
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.
Objectives
- 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
- Describe how schema objects work
Oracle Database 11g SQL Fundamentals I (1Z0-051): 7 Creating Schema Objects
Description
This course covers creating and maintaining four types of schema objects: views, sequences, indexes, and synonyms.
Objectives
- Create simple and complex views
- Retrieve data from views
- Create, maintain, and use sequences
- Create and maintain indexes
- Create private and public synonyms
Oracle Database 11g SQL Fundamentals I (1Z0-051): 8 Practice Exam 1
Description
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Objectives
- Complete the practice exam questions
Oracle Database 11g SQL Fundamentals I (1Z0-051): 9 Practice Exam 2
Description
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Objectives
- Complete the practice exam questions
Oracle Database 11g SQL Fundamentals I (1Z0-051):10 Practice Exam 3
Description
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Objectives
- Complete the practice exam questions
Features
- Audio accompanies each lesson page throughout the course.
- MindNotes provide printable quick-reference sheets and other files to be used as learners apply their skills on the job.
- Instructional audio with graphics highlighting key points.
- Activities allow learners to apply course concepts in an interactive questioning environment.
- Exercises allow learners to practice in the actual application being studied.
- A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
- Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
- Search text enables learners to rapidly search all text within a course to easily retrieve information required.
- Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
- A skill assessment generates a customized learning path based on the results of a pre-test.
- A glossary provides a reference for definitions of unfamiliar terms.
- Bookmarking tracks the learner's progress in a course.