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 retri
This Oracle Database 11g SQL Fundamentals I (1Z0-051) online training series provides over 15 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:
1 . Creating Schema Objects
2 . Creating Tables and Constraints
3 . Introduction to SQL
4 . Manipulating Data
5 . Practice Exam 1
6 . Practice Exam 2
7 . Practice Exam 3
8 . Using Group Functions
9 . Using Joins and Subqueries
10 . Using Single-Row Functions
Lesson Detail:
Creating Schema Objects
This course covers creating and maintaining four types of schema objects: views, sequences, indexes, and synonyms.
Creating Tables and Constraints
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.
Introduction to SQL
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.
Manipulating Data
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 tabl
Practice Exam 1
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Practice Exam 2
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Practice Exam 3
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Using Group Functions
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.
Using Joins and Subqueries
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.
Using Single-Row Functions
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, an
Certification:
Oracle Database 11g SQL Fundamentals I (1Z0-051)
Audience:
This series is for anyone who is preparing for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.
Features:
What You Get:
You will receive Unlimited Access to all of the Oracle Database 11g SQL Fundamentals I (1Z0-051) training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.
Web-Based Training Products:
You might also be interested in our Technical Package which includes all of the Oracle Database 11g SQL Fundamentals I (1Z0-051) training courses listed above plus hundreds of hours of related online training courses