->

Become Oracle SQL expert using Oracle Cloud Infrastructure(OCI) - Autonomous Database

Become Oracle SQL expert using Oracle Cloud Infrastructure(OCI) - Autonomous Database

Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz

Language: English  | VTT | Size: 1.53 GB  | Duration: 5h 21m


The big question is – is SQL still relevant and should you learn it? Well, the answer is: Yes.

 

SQL has established itself as the de-facto data access language used across many different industries.  This means that SQL is no longer just used by developers,but folks from many different parallel technical fields that need to store, manipulate, and access large volumes of data - analyse it with slice and dice concept to derive meaningful business information so as to have the business in competitive edge.

 

For this reason, SQL isn’t going anywhere. Its stable in popularity and still dwarfs NoSQL databases on a side by side comparison.

 

With this course, you can learn how to provision the latest Oracle Cloud Autonomous Database 19c which is provided on Oracle cloud infrastructure as always free tier. You can also learn SQL by going through the video, if have access to Oracle SQL environment 

 

Towards Oracle SQL learning this course has following topics of coverage.

 

Different Oracle DB environment to Learn & Practice Oracle SQL

How to get access to Oracle Cloud Free tier.

An Overview about all new Oracle Autonomous Cloud Database.

Provisioning Oracle Autonomous Database on OCI

Accessing the Oracle Cloud Autonomous DB for SQL - web and client version.

Oracle HR dataset installation using Oracle APEX.

Data Retrieval using SQL Select statements.            -Where Clause.            -Functions.            -Character Manipulation.            -Conversion and Conditional Expression - NVL, CASE, DECODE.            -Aggregate functions and group by clause.            -Table joins for retrieving data from multiple table.            -Subqueries.

Data Definition Language and Constraints

Data Manipulation Language.

What is Oracle Data Dictionary.

Other DB Objects - Sequence, Index, Synonyms & Views.

Database User Privilege & Roles

Understanding Correlated Subqueries. First step to become expert in Oracle SQL !! Happy Learning! ....


 

 

 

Become Oracle SQL expert using Oracle Cloud Infrastructure(OCI) - Autonomous Database

 

 


 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.


 nomaher   |  

Information
Members of Guests cannot leave comments.




rss