Oracle SQL LiveLessons

English | Duration: 5h 43m | .FLV | h264, yuv420p, 1280x720, 30.00 fps(r) | aac, 44100 Hz, stereo | 5.81 GB

Genre: E-learning

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.

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.

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