Oracle SQL LiveLessons

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