Oracle Database 12c: SQL and PL/SQL Fundamentals
Duration : 5 Days (40 Hours)
Oracle Database 12c: SQL and PL/SQL Fundamentals Course Overview:
The Oracle Database 12c: SQL and PL/SQL Fundamentals training course covers the fundamentals of SQL and PL/SQL. Participants will learn how to create database objects and handle data in tables, along with writing queries for single and multiple tables. This course not only introduces the basics of SQL and PL/SQL but also emphasizes the benefits of using these languages with Oracle Database technology.
The training explores the concepts of relational databases and highlights the practical applications of these powerful programming languages in real-world scenarios. Enroll in the Oracle Database 12c: SQL and PL/SQL Fundamentals course by checking the available dates below and start building your skills today.
Intended Audience:
- Software Developers
- System Analysts
- Implementers
- PL/SQL Developers
- Form Developers
- Designers of User Interfaces
- Application Developers
- Coding of Reports
- Expert Technical Advisors
- Maker of Portals
- Data Administrators
- Professionals who are looking to gain a basic understanding of Oracle Database 12c with SQL and PL/SQL
- Professionals who are looking to sit for the Oracle Database 12c: SQL and PL/SQL Fundamentals certification exam.
Learning Objectives of Oracle Database 12c: SQL and PL/SQL Fundamentals:
- Execute DML commands to modify information in Oracle.
- Design PL/SQL anonymous blocks that execute efficiently.
- Please outline PL/capabilities SQL and syntax.
- Take care of programming errors.
- Specify the features of stored functions and procedures.
- Make use of PL/conditional SQL’s execution features (loops, control structures, and explicit cursors).
- Row processing with cursors.
- Learn to recognise the key building blocks of the Oracle Database 11g.
- In SQL, the SELECT command is used to get information from tables.
- Generate restricted and sorted data reports.
- Create and retrieve unique data with the use of SQL functions.
- Use the ANSI SQL 99 JOIN syntax to display information from many tables.
- Make summaries of collected information.
- Execute DDL commands to construct and manipulate schema objects
- Create database objects, perform table manipulations, and write queries against single or multiple tables.
- The output can be tailored with the use of single row functions.
- Utilize evaluation functions and if/then statements.
- If you need to report on aggregated data, use group functions.
- Make reusable PL/SQL code blobs for your forms, reports, and database management software.
- Create anonymous PL/SQL procedures, functions, and blocks.
- Make use of variable declarations and error handling.
- Manage your data with DML statements.
- Manage database objects via DDL statements.
- Set PL/SQL Variable Declarations.
- Using if/else statements to regulate programme flow (loops, control structures).
- Specify the features of stored functions and procedures.
- Learn how to get table information in rows and columns.
Module 1: Introduction
Module 2: Retrieve Data using the SQL SELECT Statemen
Module 3: Restricted and Sorted Data
Module 4: Usage of Single-Row Functions to Customize Output
Module 5: Conversion Functions and Conditional Expressions
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: Stored Procedures and Functions
Oracle Database 12c: SQL and PL/SQL Fundamentals Course Prerequisites:
- Knowledge of data processing principles and procedures
- Knowledge of computer programming principles
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
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!