This Database SQL & PL/SQL Fundamentals training teaches you the fundamentals of relational databases, SQL & PL/SQL programming language. You’ll explore the concepts of relational databases. Learn to write queries against single and multiple tables, manipulate data in tables & create database objects.
At the end of this course, participants will be able to:
- Run data definition language (DDL) statements to create and manage schema objects
- Run data manipulation statements (DML) to update data in the Oracle Database
- Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
- Use cursors to process rows
- Create reports of sorted and restricted data
- Describe stored procedures and functions
- Describe the features and syntax of PL/SQL
- Design PL/SQL anonymous block that execute efficiently
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Create reports of aggregated data
- Employ SQL functions to generate and retrieve customized data
- Handle runtime errors
- Retrieve row and column data from tables with the SELECT statement