Naslovnica
Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2
This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL.
This Database SQL & PL/SQL Fundamentals training teaches you the fundamentals of relational databases, SQL & PL/SQL programming language. Learn to write queries against single and multiple tables, manipulate data in tables & create database objects.
Što ćete naučiti
- Write queries against single and multiple tables, manipulate data in tables and create database objects.
- Use single row functions to customize output.
- Invoke conversion functions and conditional expressions.
- Use group functions to report aggregated data.
- Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
- Develop anonymous PL/SQL blocks, stored procedures and functions.
- Declare identifiers and trap exceptions.
- Use DML statements to manage data.
- Use DDL statements to manage database objects.
- Declare PL/SQL Variables.
- Conditionally control code flow (loops, control structures).
- Describe stored procedures and functions.
- Retrieve row and column data from tables.
Kome je namijenjeno
- Developer
- Implementer
Preduvjeti
-
Nastavni plan
-
Pregledaj
- Introduction
- Retrieve Data using the SQL SELECT Statement
- Restricted and Sorted Data
- Usage of Single-Row Functions to Customize Output
- Conversion Functions and Conditional Expressions
- Aggregated Data Using the Group Functions
- Display Data From Multiple Tables
- Usage of Subqueries to Solve Queries
- SET Operators
- Data Manipulation
- DDL Statements to Create and Manage Tables
- Other Schema Objects
- Introduction to PL/SQL
- PL/SQL Identifiers
- Write Executable Statements
- Interaction with the Oracle Server
- Control Structures
- Usage of Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures and Functions