24 hours

Book Free Demo »

View Schedule »

Shared batch: Rs. 7500 ($99 USD)

1 to 1: Rs. 22500 ($299 USD)

On-demand/Offline: Rs. 7500 ($99 USD)

Pay using Indian cards

Send payment via PayPal

View Bank transfer details

GPay, PhonePe, Paytm or Amazon Pay on +91-8888092582. 100% money back!

Best Oracle SQL Database Foundations (Exam 1Z0-006) queries training in Pune, Pimpri Chinchwad, India

This course of introduces students to basic relational database concepts. The course teaches students relational database terminology, as well as data modeling concepts, building Entity Relationship Diagrams (ERDs), and mapping ERDs.

Leveraging project-based learning techniques, students will create and work with projects which challenge them to design, implement, and demonstrate a database solution for a business or organization.

This course is best for novice programmers, as well as those at advanced levels, who prefer to start learning the basis for the SQL programming language at an introductory level. This foundational course is suitable for computer science majors and non-majors alike.

Syllabus

Please check the syllabus tab above. ☝

This training syllabus is based on the Oracle Database Foundations (Exam 1Z0-006):

What is a Database?
- Database Concepts
  - Describe the components of a database system
  - Explain the purpose of a database
- Types of Databases Models
  - Describe types of database models (relational, object oriented, flat, network…)
  - Compare the differences between the different types of databases
- Relational Database Concepts
  - Describe the characteristics of a relational database
  - Explain the importance of relational databases in business
  - List the major transformations in database technology
- Defining Levels of Data Abstraction
  - Define the terminology used for database storage
  - Describe levels of data abstraction used in relational databases
- Gathering Requirements for Database Design
  - Gather requirements to implement a database solution
  - Explain business rules
The Language of Database and Data Modeling
- Defining a Table in a Database
  - Describe the structure of a single table
  - Using Conceptual Data Modeling
- Describe a conceptual data model
  - Explain the components of a conceptual/logical model
  - Defining Instance and Schema in Relational Databases
- Examine examples of an entity and a corresponding table
  - Examine examples of an attribute and a corresponding column
  - Explain instances and schemas in a relational database
  - Using Unique Identifiers, Primary and Foreign Keys
- Identify unique identifiers and a corresponding primary key
  - Define composite and compound primary keys
  - Define relationships and corresponding foreign keys
  - Define barred relationships and the corresponding primary keys
Introduction to SQL
- Using Structured Query Language (SQL)
  - Explain the relationship between a database and SQL - Using Data Definition Language (DDL)
- Describe the purpose of DDL
  - Use DDL to manage tables and their relationships
  - Using Data Manipulation Language (DML) and Transaction Control Language (TCL)
- Describe the purpose of DML
  - Use DML to manage data in tables
  - Use TCL to manage transactions
  - Defining and using Basic Select statements
- Identify the connection between an ERD and a Relational Database using SQL SELECT statements
  - Build a SELECT statement to retrieve data from an Oracle Database table
  - Use the WHERE clause to the SELECT statement to filter query results
  - Displaying Sorted Data
- Use the ORDER BY clause to sort SQL query results
  - Defining Table Joins
  - Describe the different types of joins and their features/strong>
  - Use joins to retrieve data from multiple tables

Oracle SQL Queries
- SELECT and WHERE
  - Columns, Characters, and Rows
  - Limit Rows Selected
  - Comparison Operators
- WHERE, ORDER BY, and Intro to Functions
  - Logical Comparisons and Precedence Rules
  - Sorting Rows
  - Introduction to Functions
- Single Row Functions Part I
  - Case and Character Manipulation
  - Number Functions
  - Date Functions
- Single Row Functions Part II
  - Conversion Functions
  - NULL Functions
  - Conditional Expressions
- JOINs
  - Cross Joins and Natural Joins
  - Join Clauses
  - Inner versus Outer Joins
  - Self-Joins and Hierarchical Queries
  - Oracle Equijoin and Cartesian Product
  - Oracle Nonequijoins and Outer Joins
- Group Functions
  - Group Functions
  - Oracle Nonequijoins and Outer Joins
  - Using Group By and Having Clauses
  - Using Rollup and Cube Operations, and Grouping Sets
  - Using Set Operators
- Subqueries
  - Fundamentals of Subqueries
  - Single-Row Subqueries
  - Multiple-Row Subqueries
  - Correlated Subqueries
- DML
  - INSERT Statements
  - Updating Column Values and Deleting Rows
  - DEFAULT Values, MERGE, and Multi-Table Inserts
- DDL
  - Creating Tables
  - Using Data Types
  - Modifying a Table
- Constraints
  - Intro to Constraints; NOT NULL and UNIQUE Constraints
  - PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
  - Managing Constraints
- Views
  - Creating Views
  - DML Operations and Views
  - Managing Views

After completing this training, you can appear the "Oracle Database Certified Foundations Associate" certification exam. Here are the exam details for Oracle Database Certified Foundations Associate: