Course details
Introduction
This five-day instructor led course is a bundled course thqat consists of Oracle Database: SQL Workshop I and Oracle Database: PL/SQL Fundamentals and will teach you the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases.
Course Content
SQL FUNDAMENTALS I
- Lesson 1: Introduction
- Lesson 2: Retrieving Data Using the SQL SELECT Statement
- Lesson 3: Restricting and Sorting Data
- Lesson 4: Using Single-Row Functions to Customize Output
- Lesson 5: Using Conversion Functions and Conditional Expressions
- Lesson 6: Reporting Aggregated Data Using the Group Functions
- Lesson 7: Displaying Data from Multiple Tables Using Joins
- Lesson 8: Using Subqueries to Solve Queries
- Lesson 9: Using the Set Operators
- Lesson 10: Manipulating Data
- Lesson 11: Introductions to Data Definition Language
PL/SQL Fundamentals
- Lesson 1: Introduction
- Lesson 2: Introduction to PL/SQL
- Lesson 3: Declaring PL/SQL Variables
- Lesson 4: Writing Executable Statements
- Lesson 5: Using SQL Statements within a PL/SQL Block
- Lesson 6: Writing Control Structures
- Lesson 7: Working with Composite Data Types
- Lesson 8: Using Explicit Cursors
- Lesson 9: Handling Exceptions
- Lesson 10: Introducing Stored Procedures and Functions
Course Location
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT coursesOracle Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Oracle APEX (Video-Based) UplatzAED 47Duration: Upto 5 Hours
- Oracle Forms (Video-Based) UplatzAED 47Duration: Upto 10 Hours