Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2
Duration : 5 Days (40 Hours)
Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2 Course Overview:
The Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2 certification focuses on the fundamental concepts and implementation of Oracle Database. It covers SQL and PL/SQL programming language concepts, data manipulation, database management, and database architecture. Professionals with this certification have the necessary skills to manage and develop applications in Oracle Database. Industries use this certification to validate the proficiency of their IT staff in Oracle Database, ensuring quality of work and operational efficiency. It’s widely adopted across industries such as IT, banking and finance, healthcare, and telecoms due to Oracle’s extensive use for data management and business solutions.
- Database administrators seeking to enhance their SQL skills
- IT professionals looking to specialize in Oracle Database technologies
- Software developers wanting to improve their proficiency in database manipulation
- Graduates seeking to gain knowledge for entry-level Oracle database jobs
- Individuals preparing for Oracle SQL certification exams
- Companies training internal teams on Oracle 12c Database.
Learning Objectives of Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2:
The main objectives of the Oracle Database 12c R2: SQL and PL/SQL Fundamentals course are to equip participants with knowledge and skills pertinent to both the SQL and PL/SQL languages. Through this course, learners are expected to grasp the basic concepts of relational databases, SQL querying, Data Definition Language (DDL), Data Manipulation Language (DML), and Transaction Control Language (TCL) commands. They will also learn to write SQL statements for fetching and updating data, create and manage tables, and write PL/SQL scripts.
Moreover, the course aims to enable learners to effectively use the Oracle database for creating and managing different database objects, understanding data modeling concepts, and building transaction control language statements. By the end of the course, participants should be proficient in using SQL and PL/SQL to interact with Oracle databases, allowing them to work with data effectively and perform essential database management tasks.
Module 1: Introduction
Module 2: Retrieve Data using the SQL SELECT Statement
Module 3: Restricted and Sorted Data
Module 4: Usage of Single-Row Functions to Customize Output
Module 5: Usage of Single-Row Functions to Customize Output
Module 6: Aggregated Data Using the Group Functions
Module 7: Display Data From Multiple Tables
Module 8: Usage of Subqueries to Solve Queries
Module 9: SET Operators
Module 10: Data Manipulation
Module 11: DDL Statements to Create and Manage Tables
Module 12: Other Schema Objects
Module 13: Introduction to PL/SQL
Module 14: PL/SQL Identifiers
Module 15: Write Executable Statements
Module 16: Interaction with the Oracle Server
Module 17: Control Structures
Module 18: Usage of Composite Data Types
Module 19: Explicit Cursors
Module 20: Exception Handling
Module 21: Exception Handling
Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2 Course Prerequisites:
• Familiarity with data processing concepts and techniques.
• Knowledge of computer programming languages, specifically SQL.
• Experience with the Microsoft Windows interface.
• Basic understanding of Oracle Database technology.
• Previous experience or understanding of Oracle Database 12c R2 would be beneficial.
Discover the perfect fit for your learning journey
Choose Learning Modality
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!