Register your product to gain access to bonus material or receive a coupon.
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
6+ Hours of Video Instruction
Overview
Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database.
Description
In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples.
About the Instructor
Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com.
Skill Level
Learn How To
Who Should Take This Course
Course Requirements
Table of Contents
Introduction
Lesson 1: Oracle SQL Course Overview
Lesson 1 starts with a review of the course prerequisites and data objects used throughout the lessons.
Lesson 2: Introduction to the Course Tools
Lesson 2 illustrates the 3 tools that will be used as well. You can use any tool that works with the Oracle database but I will alternate between using Dell Software Solutions Toad tool and the free Oracle Corp SQL*Developer graphical tools. If you happen to be using one of these tools at your shop, you certainly learn more about that tool during these lessons.
Lesson 3: Introduction to SQL
Lesson 3 covers the basic SQL syntax, table joins, and use of functions.
Lesson 4: Table Joins
Lesson 4 builds on this knowledge with table joins, using both the Oracle and ANSI syntax methods and concludes with data sorting options.
Lesson 5: Functions and Pseudocolumns
Lesson 5 illustrates functions and pseudocolumns and useful coding tips and techniques involving mixing these functions to solve complex business requirements.
Lesson 6: Advanced Queries Using Sub-Queries
Lesson 6 adds to the SQL course with sub-queries and in-line views along with a variety of useful SQL coding tips and techniques.
Lesson 7: Oracle Data Manipulation and Definition Language
Lesson 7 works with creating table and modifying the data using a variety of techniques provided by the SQL language and the tool wizards.
Lesson 8: Database Management
Lesson 8 introduces a variety of related objects found in Oracle applications such as sequences, identity columns, views, and permissions. This lesson also introduces you to SQL performance tuning.
Lesson 9: Data Relationships
Lesson 9 dives into the business rules applied to the tables and data called referential integrity. This lesson covers how to view the objects and related data as well as how to save the related data for reporting and testing needs.
Lesson 10: Analytical SQL
Lesson 10 is for the business analyst working with data warehouses perhaps. This lesson introduces analytical SQL and includes a variety of analytical SQL code and useful reports. The remainder of this course focuses on reporting, scripting, and saving data into a variety of formats including popular Microsoft Office products. This course then covers some basic and advanced Oracle SQL scripting techniques. Cross-reference and pivot tables are covered in Lesson 11.
Lesson 11: Simple Reports Using SQL*Plus
Lesson 11 covers building Simple character-mode reports using SQL*Plus and illustrates how to convert these reports to web pages. This lesson also covers basic and advanced scripting topics such as SQL creating SQL, script error handling, and useful tips for building scripts for your test and application environments.
Lesson 12: Toad and SQL Developer Reports
Lesson 12 focuses on building reports using Toad and SQL*Developer.
Lesson 13: Spreadsheets and Saving the Data Using the Tools
Lesson 13 illustrates how to save the data into a variety of formats using all three course tools.
Lesson 14: Microsoft Office Programs with Oracle SQL
Lesson 14 wraps up the LiveLessons with working with Oracle SQL directly from Microsoft Office products using the ODBC environment.
Summary
These lessons cover a variety real-world examples and tips. The hands-on labs reinforce the learning environment with useful examples from real-life applications and business requirements.
About LiveLessons Video Training
The LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons
Introduction
Lesson 1: Oracle SQL Course Overview
Learning objectives
1.1 Understand the course pre-requisites
1.2 Utilize the course download
1.3 Understand the course database objects
1.4 Introduce the Database Relational Model
1.5 Introduce the Oracle Architecture
Put it all together
Lesson 2: Introduction to the Course Tools
Learning objectives
2.1 Work with SQL*Plus
2.2 Utilize SQL*Developer
2.3 Explore Toad
Put it all together
Lesson 3: Introduction to SQL
Learning objectives
3.1 Understand Simple SQL queries
3.2 Work with Where clauses
3.3 Hands-on Lab
Put it all together
Lesson 4: Table Joins
Learning objectives
4.1 Discover available tables/columns
4.2 Use the tools to create SQL without typing
4.3 Understand multiple table joins
4.4 Work with ANSI syntax
4.5 Use Oracle12 new ANSI join syntax
4.6 Explore sorting options
4.7 Hands-on Lab
Put it all together
Lesson 5: Functions and Pseudocolumns
Learning objectives
5.1 Utilize pseudocolumns
5.2 Review character/string functions
5.3 Explore date functions
5.4 Understand number functions
5.5 Work with Decode/Case/regular expressions/pattern matching functions
5.6 Work with Group By functions
5.7 Use multiple functions
5.8 Use the functions from the tools
5.9 Hands-on Lab
Put it all together
Lesson 6: Advanced Queries Using Sub-Queries
Learning objectives
6.1 Understand sub-queries
6.2 Work with in-line views
6.3 Utilize SQL coding tips and techniques
6.4 Hands-on Lab
Put it all together
Lesson 7: Oracle Data Manipulation and Definition Language
Learning objectives
7.1 Understand how to create tables
7.2 Utilize subsets of tables
7.3 Work with inserting data
7.4 Explore updating data
7.5 Utilize deleting data
7.6 Use the MERGE command
7.7 Utilize the tools to perform DML and DDL operations
7.8 Hands-on Lab
Put it all together
Lesson 8: Database Management
Learning objectives
8.1 Work with sequences
8.2 Understand identity columns
8.3 Explore creating views
8.4 Understand permissions
8.5 Use indexes to increase SQL performance
8.6 Introduce SQL performance tuning
8.7 Hands-on Lab
Put it all together
Lesson 9: Data Relationships
Learning objectives
9.1 Learn what referential integrity is
9.2 Explore your data relationships
9.3 Use entity-relationship diagrams
9.4 View related data
9.5 Save related data (useful for test data/reports)
9.6 Live Demonstration
Put it all together
Lesson 10: Analytical SQL
Learning objectives
10.1 Introduce analytical SQL
10.2 Use analytical functions
10.3 Explore partitioning functions
10.4 Utilize windowing functions
Put it all together
Lesson 11: Simple Reports Using SQL*Plus
Learning objectives
11.1 Introduce SQL*Plus formatting commands
11.2 Build simple reports
11.3 Utilize HTML reports
11.4 Explore creating pivot tables
11.5 Introduce Oracle scripting
11.6 Hands-on Lab
Put it all together
Lesson 12: Toad and SQL Developer Reports
Learning objectives
12.1 Use the Toad Report Writer
12.2 Explore creating reports using SQL Developer
12.3 Hands-on Lab
Put it all together
Lesson 13: Spreadsheets and Saving the Data Using the Tools
Learning objectives
13.1 Explore saving data/creating spreadsheets using SQL*Plus
13.2 Utilize saving data/creating spreadsheets using SQL*Developer
13.3 Work with saving data/creating spreadsheets/Access databases using Toad
13.4 Hands-on Lab
Put it all together
Lesson 14: Microsoft Office Programs with Oracle SQL
Learning objectives
14.1 Introduce ODBC drivers
14.2 Implement Oracle connections using ODBC
14.3 Explore SQL from Excel
14.4 Understand SQL from Access
Put it all together
Summary