This course will teach you the SQL language on an Oracle database. This introductory course teaches you how to work with data in your Oracle Database using Oracle's proprietary SQL language. It starts with the basic overview of what SQL is all about and then covers basic queries and common things you might be expected to do on a job. We then proceed to learn complex queries and data management such as inserting/updating/deleting data. It uses video lectures, covering database topics such as:
·Setting up your Oracle environment
·Basic terminology
·Reading data using a SELECT statement
·What can be done using a SELECT statement
·Functions
·Data types
·Joins, set operators, subqueries
·Inserting, updating and deleting data
·Creating tables
By learning this course you will be conceptual ready for developing DB objects. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables


     
 

https://www.udemy.com/oracle-sql-database/?couponCode=tintin