Mastering Oracle SQL Using Oracle Cloud (OCI) - Free Tier
Gain expertise in Oracle SQL using Oracle Cloud Autonomous DB (OCI)-Free tier. Explore Oracle Cloud and learn SQL,Machine learning with Oracle Database
Oracle,Development,Database Design
Lectures -60
Resources -14
Duration -6 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
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(OCI) as always free tier , utilize it to learn SQL and also explore other Autonomous DB tools including Oracle machine learning.
Towards Oracle SQL learning this course has following topics of coverage.
Whats a Business application.
Relational Database Management System - An overview.
What is Oracle Database Instance.
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.
Developer Tools with Oracle Cloud Autonomous Developer tools - An Overview
- Data analytics and Visualization with Oracle cloud DB: Machine learning
First step to become expert in Oracle SQL !!
Happy Learning! ....
Who this course is for:
- Students of Computer science, IT and Management.
- Front end developers who wish to learn about Oracle Database SQL statement
- Anyone who wish to take up career in IT.
Goals
Provisioning Autonomous Oracle Database 19c on Oracle Cloud Infrastructure (OCI) - This is available on always free tier Oracle Cloud Offering
Overview about RDBMS concepts
Overview about Oracle Instance
- Use Different Constraints in Database -Primary, Foreign, Not Null, Unique, Check
Learn about Oracle SQL statement - Data definition, Data manipulation & Control statement
- Difference SQL Select statements - Using Functions, Strings, joins, Subquery, Correlated subquery etc
- Different DB objects like table, views, synonyms, index, sequence
- Oracle Cloud Autonomous Database tools including Oracle Machine Learning - An Overview.
Prerequisites
- Access to Oracle Cloud Infrastructure (OCI) Free tier - The course also guides you towards requesting Oracle Cloud Account.
- Alternatively, if you have access to Oracle Database through SQL, you can still learn Oracle SQL without provisioning Autonomous Database on Oracle cloud Infrastructure (OCI)
Curriculum
Check out the detailed breakdown of what’s inside the course
Topics of coverage
2 Lectures
-
Course Introduction 03:01 03:01
-
Topics of Coverage 08:45 08:45
Business Application
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Whats a Relational Database Management System?
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What is a Oracle Database Instance?
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Different Oracle Database environment and advantage of Oracle Cloud environment - OCI Free tier
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Getting Access to Oracle Cloud Infrastructure - Always Free tier
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What's an Oracle Autonomous Cloud Database?
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Provisioning Oracle Autonomous Database on Oracle Cloud Infrastructure
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Accessing the Oracle Cloud Autonomous Database through SQL Developer
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Oracle HR dataset installation using Oracle APEX and access using SQL developer
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Retrieving Data from table using SQL statements
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Restriction data retrieval based on condition "Where" clause
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Functions in SQL statements
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Conversion and Conditional Expression in SQL Select Statement
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Aggregate Function and group by clause
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Retrieving Information from Multiple table using Joins
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Subqueries in SQL statements
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Definition Language (DDL)
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Manipulation Language - SQL statement
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Introduction to Oracle DB - Data Dictionary.
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Other DB objects - Sequence, Synonyms, Index & View
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Database User Privilege & Roles
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Developer tools with Oracle Cloud Autonomous DB - An Overview
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Correlated Subqueries in SQL statements
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Guha Rajan M., B.Engg, MBA](https://www.tutorialspoint.com/assets/profiles/344057/profile/200_50742-1624463526.jpg)
Guha Rajan M., B.Engg, MBA
Having over 25 + years of IT industry experience (Product development, Consulting & Training).
His last engagement was with Oracle India (initially with consulting and then with Oracle university) , which was for more than 12 years. Prior to this, had worked with Cap Gemini (formerly iGate Global Solution), GE to name a few.
Had managed projects and programs in Enterprise Resource Planning and Business Intelligence implementations in the range of 3000 man days with revenue about 6mil US$ per year. These projects are on industry domains, such as Oil and Gas, Process Manufacturing, Hi-Tech Retail & Telecom across the globe.
Was awarded with "pace setter" , "best managed " project awards in recognition of efforts in project management.
He was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products stack for partner IT services companies in recent times.
Right from college was fascinated about devices and sensor interaction with computer, which made him focus on micro-controller in early 90's and that eventually attracted him towards field of ERP, BI , Cloud technologies - Saas, Iaas, Paas, Internet of things, Machine learning, AI and open source software tools these days.
Due to his vast experience, he has crafted varied unique courses in Tutorialspoint related project management, Internet of things, ERP & BI, Database modeling and design, SQL, Linux and more importantly on Cloud Infrastructure. Has plans to create more, as his passion has been on knowledge acquisition and sharing.
He is certified as
Oracle Financials Business Process Certified Foundations Associate
Oracle Cloud Infrastructure 2021 Architect Professional.
Oracle Cloud Infrastructure 2021 Architect Associate.
Oracle Cloud Infrastructure 2021 Cloud Operations Associate.
Oracle Cloud Infrastructure Security 2021 Certified Associate
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Machine Learning using Autonomous Database 2021 Certified Specialist
Also certified in Python, IOT by NPTEL (Govt of India ) 2018.
He holds a degree in engineering (Computer science) with MBA
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)