Home > Store

Oracle SQL LiveLessons (Video Training), Download Version

Oracle SQL LiveLessons (Video Training), Download Version

  • By
  • Published Aug 7, 2015 by Pearson.

Downloadable Video

  • Your Price: $212.49
  • List Price: $249.99
  • About this video
  • 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.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2016
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-427705-8
  • ISBN-13: 978-0-13-427705-9

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

  • Beginner

Learn How To

  • Use the SQL query language
  • Interpret business questions into SQL code
  • Understand Oracle standard SQL and ANSI SQL
  • Work with Where clauses, sub-queries, and complex table join conditions
  • Create table objects and populate these tables with data
  • Access Oracle from Microsoft products such as Excel
  • Use analytical SQL, useful for business analysts

Who Should Take This Course

  • Students who are new to SQL and want to learn Oracle SQL

Course Requirements

  • Basic knowledge of what is a database, especially RDBMS and what is a computer programming language

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

Sample Content

Table of Contents

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

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020