->
Lynda - Oracle Database 12c: Basic SQL - 601804
Lynda - Oracle Database 12c: Basic SQL
Mastering the SQL language is an essential skill for any Oracle professional and is the first step in becoming a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, Oracle instructor and consultant David Yahalom covers the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions. David also provides an overview of advanced concepts, such as constraints and subqueries.


Table of Contents

  • Introduction
  • 1. Introduction to SQL
  • 2. Preparing the Course Environment
  • 3. Using Oracle SQL Developer
  • 4. Basic SELECT Queries
  • 5. String, Number, and Date Functions
  • 6. Joining Table Data
  • 7. Manipulating Data
  • 8. Grouping Data
  • 9. Advanced Topics
  • Conclusion
  • Lynda - Oracle Database 12c: Basic SQL


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss