->

Oracle Database 19c: Basic SQL
Oracle Database 19c: Basic SQL
Mastering SQL is an essential skill for any Oracle professional and the first step in becoming a true Oracle expert. In this course, Bob Bryla covers the basics required to code using SQL in an Oracle 19c Database environment. Bob covers what you need to know to get data in and out of your database tables, as well as how to modify data. He explains how to leverage SELECT statements, filter and sort rows, use both single- and multiple-row functions, and join tables. He delves into the Oracle data dictionary—a set of tables that provide information about a database—and shows how to query it. Plus, he demonstrates how to efficiently delete data using DML statements. Upon wrapping up this course, you'll have the fundamental skills you need to work with SQL in this popular relational database management system.


  • Introduction
  • 1. Client Tools
  • 2. SELECT Statements
  • 3. Data Dictionary
  • 4. String Manipulation
  • 5. Filtering Rows
  • 6. Sorting Rows
  • 7. Single-Row Functions
  • 8. Aggregation and Multiple-Row Functions
  • 9. Joining Tables
  • 10. Using the Oracle Data Dictionary
  • 11. DML: INSERT
  • 12. DDL: Creating Objects
  • 13. Dropping Objects
  • Conclusion


 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.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss