Skip to Main Content
Oracle SQL
on-demand course

Oracle SQL

with Dan Hotka
August 2015
Beginner content levelBeginner
5h 43m
English
Pearson
Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Overview

Overview

Oracle SQL LiveLessons 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 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.

Related Files

The companion files for this LiveLesson can be downloaded from http://www.informit.com/title/9780134275741.

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

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.

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

You might also like

Oracle SQL Developer

Oracle SQL Developer

Ajith Narayanan, Susan Harper
Oracle SQL By Example

Oracle SQL By Example

Alice Rischert
Oracle Databases

Oracle Databases

O'Reilly Media, Inc.

Publisher Resources

ISBN: 9780134277042