on-demand course

Learning Path: Beginner Oracle Developer

with Dan Hotka

June 2016

Beginner

14h 49m

English

Addison-Wesley Professional

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Oracle SQL: Introduction
6m 20s
Learning objectives
32s
1.1 Understand the course pre-requisites
49s
1.2 Utilize the course download
1m 36s
1.3 Understand the course database objects
1m 36s
1.4 Introduce the Database Relational Model
7m 10s
1.5 Introduce the Oracle Architecture
8m 10s
Put it all together
45s
Learning objectives
55s
2.1 Work with SQL*Plus
5m 56s
2.2 Utilize SQL*Developer
5m 30s
2.3 Explore Toad
5m 0s
Put it all together
1m 0s
Learning objectives
16s
3.1 Understand Simple SQL queries
3m 41s
3.2 Work with Where clauses
5m 46s
3.3 Hands-on Lab
6m 55s
Put it all together
21s
Learning objectives
37s
4.1 Discover available tables/columns
3m 15s
4.2 Use the tools to create SQL without typing
9m 10s
4.3 Understand multiple table joins
8m 9s
4.4 Work with ANSI syntax
3m 1s
4.5 Use Oracle12 new ANSI join syntax
59s
4.6 Explore sorting options
1m 47s
4.7 Hands-on Lab
4m 45s
Put it all together
56s
Learning objectives
43s
5.1 Utilize pseudocolumns
2m 37s
5.2 Review character/string functions
2m 19s
5.3 Explore date functions
7m 28s
5.4 Understand number functions
2m 11s
5.5 Work with Decode/Case/regular expressions/pattern matching functions
3m 34s
5.6 Work with Group By functions
2m 34s
5.7 Use multiple functions
5m 47s
5.8 Use the functions from the tools
2m 40s
5.9 Hands-on Lab
6m 15s
Put it all together
54s
Learning objectives
25s
6.1 Understand sub-queries
9m 33s
6.2 Work with in-line views
4m 12s
6.3 Utilize SQL coding tips and techniques
2m 35s
6.4 Hands-on Lab
5m 5s
Put it all together
35s
Learning objectives
40s
7.1 Understand how to create tables
14m 19s
7.2 Utilize subsets of tables
1m 24s
7.3 Work with inserting data
3m 57s
7.4 Explore updating data
1m 57s
7.5 Utilize deleting data
3m 59s
7.6 Use the MERGE command
45s
7.7 Utilize the tools to perform DML and DDL operations
8m 49s
7.8 Hands-on Lab
10m 15s
Put it all together
45s
Learning objectives
26s
8.1 Work with sequences
5m 12s
8.2 Understand identity columns
1m 58s
8.3 Explore creating views
3m 21s
8.4 Understand permissions
6m 0s
8.5 Use indexes to increase SQL performance
8m 55s
8.6 Introduce SQL performance tuning
4m 5s
8.7 Hands-on Lab
4m 26s
Put it all together
44s
Learning objectives
29s
9.1 Learn what referential integrity is
2m 27s
9.2 Explore your data relationships
1m 3s
9.3 Use entity-relationship diagrams
3m 35s
9.4 View related data
1m 21s
9.5 Save related data (useful for test data/reports)
1m 51s
9.6 Live Demonstration
6m 27s
Put it all together
32s

Content preview from Learning Path: Beginner Oracle Developer

6.2 Use the query viewer

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Learning Path: Professional Oracle Developer

Dan Hotka

Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional

Ben Brumm

Introduction to Oracle Database 11g Administration LiveLessons (Video Training)

Michael McLaughlin

Learning Path: C# 6 Developer

Paul Deitel

Publisher Resources

ISBN: 9780134664033

Introduction

Lesson 1: Oracle SQL Course Overview

Lesson 2: Introduction to the Course Tools

Lesson 3: Introduction to SQL

Lesson 4: Table Joins

Lesson 5: Functions and Pseudocolumns

Lesson 6: Advanced Queries Using Sub-Queries

Lesson 7: Oracle Data Manipulation and Definition Language

Lesson 8: Database Management

Lesson 9: Data Relationships

Lesson 10: Analytical SQL

Lesson 11: Simple Reports Using SQL*Plus

Lesson 12: Toad and SQL Developer Reports

Lesson 13: Spreadsheets and Saving the Data Using the Tools

Lesson 14: Microsoft Office Programs with Oracle SQL

Summary

Introduction

Lesson 1: PL/SQL Course Overview

Lesson 2: Oracle PL/SQL Overview

Lesson 3: PL/SQL Basics and Variables

Lesson 4: Logic Flow

Lesson 5: PL/SQL Cursors

Lesson 6: PL/SQL Exception Handling

Lesson 7: PL/SQL Procedures and Functions

Lesson 8: PL/SQL Packages

Lesson 9: PL/SQL Triggers

Lesson 10: PL/SQL New Features

Lesson 11: PL/SQL Collections

Lesson 12: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips

Oracle PL/SQL Programming Fundamentals LiveLessons: Summary

Introduction

Lesson 1: Toad for Oracle Course Overview

Lesson 2: Toad Configuration and Setup Option

Lesson 3: SQL and the Editor Window

Lesson 4: The Schema Browser

Lesson 5: PL/SQL Tips and Techniques

Lesson 6: Toad as a SQL Tuning Tool

Lesson 7: Toad for the Database Administrator

Lesson 8: Other Useful Features of Toad

Lesson 9: Object and Data Relationship Features, Query Builder Features

Summary

Content preview from Learning Path: Beginner Oracle Developer

6.2 Use the query viewer

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Learning Path: Professional Oracle Developer

Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional

Introduction to Oracle Database 11g Administration LiveLessons (Video Training)

Learning Path: C# 6 Developer

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.