Free Online Courses for Software Developers - MrBool
×

Click here to login

If you don't have a registration, click here to register

Mrbool Courses

Online course

Oracle PL SQL Course

In this course we will talk about the Oracle PLSQL, the Oracle is one of the leaders in the database market. With years of industry experience and a solid technology, this database is used in various companies: from those that have little data to multinationals with thousands of terabytes. In this course we will study a key aspect for those who want to begin working with Oracle Database: the PL/SQL language, which is the dialect of the SQL language used to manipulate data. The course is designed for those who never work with any database and is divided into 30 video lessons that address topics such as the installation of the product, views, constraints, indexes, variables, control structures, functions, stored procedure, packages, triggers, and others. Focusing on the novice user, this course provides step by step each of the examples and demos used during the videos, allowing detailed tracking of what is being displayed for all video course lectures to a total of 10 hours.

Rating
551
  • Statements

    • 4

      Filtering and sorting data

      In this video we will see some examples of the operators AND, OR and NOT to control how more than one filter can be used to filter the rows in a SELECT statement. Watch this video
    • 5

      Single-Row Functions

      This video explain the character, number, date, conversion and general categories of functions manipulates the data about Single-Row Functions in Oracle PLSQL. Watch this video
    • 7

      Aggregating data

      This video explain how to work the aggregation functions AVG(), COUNT(), MAX(), and MIN() in order to obtain a data summary. Watch this video
    • 8

      Subqueries

      The video explain the context, the details, the requirements and the usage of subqueries with aggregated functions and with the operators IN(), ANY(), and ALL(). Watch this video
    • 9

      SQLPlus options

      This video shows how to connect to an Oracle instance, work with SQLplus variables, show and set parameters, and run scripts inside SQLPlus. Watch this video
    • 10

      Manipulating Data

      This video shows examples of how to insert the data with and without the columns names, how to update the values of columns with the UPDATE statement and how to remove some rows of the tables with the DELETE statement. Watch this video
    • 14

      PLSQL Views

      This video will explains how views can be used and how to create them, which are the basic usage scenario and how to work with views in PLSQL. Watch this video
    • 16

      Declaring Variables

      This video explains the concept and components of a PL/SQL and focus on how to work with normal variables created in the DECLARE session. You can also see the two other types of variables that can be used only SQLPlus: host and bind variables. Watch this video
    • 19

      Control Structures

      This video shows how to use the IF, ELSE, ELSEIF, CASE, LOOP, WHILE and FOR statements inside a PL/SQL block by explaining the purpose, the syntax and how these commands can be used in very simple examples. Watch this video
    • 21

      Working with Cursors

      This video shows how to create, open, manipulate and close implicit and explicit cursor inside a PL/SQL block to perform row-based operations. Watch this video
    • 22

      Handling exceptions

      This video discusses how to proper handle the messages generated by Oracle when an error happens inside PL/SQL block by using the EXCEPTION clause. Watch this video
    • 23

      Creating procedures

      This video discuss about the following advantages of procedures in Oracle: modularity, reusability, extensibility, maintainability, data security, integrity, improved performance and code clarity. Watch this video
    • 24

      Creating Functions

      This video will discuss the details about the creation of functions in Oracle: the differences from procedures, the type of return values, what can and cannot be inside a function, the parameters types and how to execute the functions. Watch this video
    • 26

      Packages

      This video shows how to organize the objects inside packages by describing and showing how to create package specifications and package bodies. Watch this video
    • 28

      Triggers

      This video explain the trigger concept and show the details of timming, event, type, when clause, firing sequence, :NEW and :OLD qualifiers, and the internal DELETING, INSERTING and UPDATING variables. Watch this video
    • 31

      Table Statistics

      This video explain how are statistics and histograms and how why they are important. The examples show how to gather the statistics using the ANALYZE command and check the blocks size allocation in the DBA_TABLES and the DBA_INDEXES views. Watch this video
    • 35

      Managing dependencies

      This video explain the scenarios and situations where object dependency is an issue in Oracle and provide some examples that show how an object can be invalid because of a broken chain on dependency. Watch this video
    • 36

      User Access

      This video explains the authorization aspects of Oracle by describing the privilege and access management for system privileges and object privileges. Watch this video
    • 37

      Job Mechanism

      This video explains how to create a job in Oracle to be executed once using the procedures and functions of the DBMS_JOB package. Watch this video
    • 38

      Importing and exporting data

      Oracle has many tools and utilities to perform the import and export data into and from a database. This video shows how to use the IMP and EXP command line utilities to import and export, respectively, data to and from Oracle tables. Watch this video
    • 39

      The SQL*Loader

      Importing files with textual data in CSV format into the Oracle is performed by utility called SQL*Loader. This video shows how to work with these files using the import control files of SQL*Loader by using examples. Watch this video
    • 40

      Database Links

      This video discuss the details demanded to setup the environment to establish a remote connect to a database server, which can be another Oracle instance or any other database that has an ODBC driver. Watch this video