Oracle Database 12c: SQL and PL/SQL Fundamentals (CO-80198) Torque IT
Price: TBA

    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
    Updated on 22 August, 2016

    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 courses
    Are you from Torque IT ? Claim your course!
    Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or