Module 1: Introduction To Oracle 12c SQL Fundamentals

1. Introduction
2. Intro To Oracle 12c-SQL Fundamentals
3. Structure Of SQL
4. Basic Select Statements
5. Basic Select Statements Demo

Module 2: Retrieving Data

1. Modifying Reported Output
2. The Where Clause
3. The Order By Clause
4. Left And Right Outer Joins
5. The Where Clause Demo
6. Multi-Table Selection Demo

Module 3: SQL Functions

1. Single Row Functions
2. Aggregate Functions
3. Single Row Functions Demo
4. Muiltrow Functions Demo
5. Group By
6. Grouping Demo
7. Conversion Functions
8. Conversion Functions Demo
9. Datetime Functions
10. Datetime Functions Demo

Module 4: Subqueries

1. Single-Row Subqueries
2. Single-Row Subqueries Demo
3. Multi-Row Subqueries
4. Multi-Row Subqueries Demo
5. Other Subquery Types
6. Other Subquery Types Demo

Module 5: Data Manipulation Language

1. Adding Data
2. Changing Data
3. Deleting Data
4. DML Demo

Module 6: Data Control Language

1. Security
2. Object Privileges
3. DCL Demo

Module 7: Data Definition Language

1. Creating Objects In The Database
2. Creating Objects In The Database Demo
3. Sequences
4. Sequenced Demo
5. Indexes
6. Views

Module 8: Combining Queries

1. Combining Queries

Module 9: Oracle 12C SQL Fundamentals Review

1. Oracle 12c SQL Fundamentals Review – Part 1
2. Oracle 12c SQL Fundamentals Review – Part 2
3. Oracle 12c SQL Fundamentals Review – Part 3
4. Conclusion

Who this course is for:

Candidates for the Oracle Database 12c: SQL Fundamentals (OCA) exam are developers, database administrators, system analysts, and functional implementers with familiarity with data process concepts and techniques, and programming languages. This certification is a prerequisite to Oracle Database 11g Administrator Certified Associate, Oracle PL/SQL Developer Certified Associate, and Oracle Database 12c Administrator Certified Associate.

Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:

1. Data retrieval using the SQL SELECT statement
2. Restricting and sorting data
3. Single-row functions
4. Using conversion functions and conditional expressions
5. Reporting aggregated data with the group functions
6. Displaying data from multiple tables with joins
7. Using subqueries to solve problems
8. Using the set operators
9. Manipulating data with DML statements
10. Using DDL statements to create and manage tables

Electronic content includes:

1. 150+ practice exam questions with detailed answers and explanations
2. Score report performance assessment tool
3. PDF copy of the book

This course will teach students about multitenant architecture and Cloud provisioning using an Oracle Database. Students will also learn about the retrieval of data, data manipulation language, the combination of queries and SQL functions.

What you’ll learn

1. The Full track of Oracle Database 12c: Introduction to SQL Ed 2.
2. You will be prepared 100% to pass exams Oracle Database SQL 1Z0-071 And also exam Oracle Database 12c: SQL Fundamentals 1Z0-061
3. Very strong introduction to make you understand the oracle database and RDBMS.
4. Oracle Database 12c Architecture
5. Downloading and installing oracle database 12c in details
6. Connecting to the Database
7. Retrieving data using the select statement / Restricting and Sorting Data