![]() 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 6: Advanced Queries Using Sub-Queries Lesson 5 illustrates functions and pseudocolumns and useful coding tips and techniques involving mixing these functions to solve complex business requirements. Lesson 4 builds on this knowledge with table joins, using both the Oracle and ANSI syntax methods and concludes with data sorting options. Lesson 3 covers the basic SQL syntax, table joins, and use of functions. If you happen to be using one of these tools at your shop, you certainly learn more about that tool during these lessons. ![]() 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. Lesson 2 illustrates the 3 tools that will be used as well. Lesson 2: Introduction to the Course Tools Lesson 1 starts with a review of the course prerequisites and data objects used throughout the lessons. Basic knowledge of what is a database, especially RDBMS and what is a computer programming language.Students who are new to SQL and want to learn Oracle SQL.Use analytical SQL, useful for business analysts.Access Oracle from Microsoft products such as Excel.Create table objects and populate these tables with data.Work with Where clauses, sub-queries, and complex table join conditions.Understand Oracle standard SQL and ANSI SQL.Interpret business questions into SQL code.He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. Dan is well published with 12 Oracle books and well over 200 published articles. Dan enjoys sharing his knowledge of the Oracle RDBMS. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. This course will use both Toad and SQL Developer for SQL examples.ĭan 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. In addition, they will learn how analytical SQL can be used for business analysis. Students will also learn how to access Oracle from Microsoft products such as Excel. 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. 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. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |