Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Mastering Oracle SQL Using Oracle Cloud (OCI) - Free Tier

person icon GUHARAJANM

4

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

updated on icon Updated on May, 2024

language icon Language - English

person icon GUHARAJANM

English [CC]

category icon Oracle,Development,Database Design

Lectures -60

Resources -14

Duration -6 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

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

What will you learn in this course:

  • 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

What are the prerequisites for this course?

  • 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)


               

Mastering Oracle SQL Using Oracle Cloud (OCI) - Free Tier

Curriculum

Check out the detailed breakdown of what’s inside the course

Topics of coverage
2 Lectures
  • play icon Course Introduction 03:01 03:01
  • play icon Topics of Coverage 08:45 08:45
Business Application
1 Lectures
Tutorialspoint
Whats a Relational Database Management System?
3 Lectures
Tutorialspoint
What is a Oracle Database Instance?
1 Lectures
Tutorialspoint
Different Oracle Database environment and advantage of Oracle Cloud environment - OCI Free tier
1 Lectures
Tutorialspoint
Getting Access to Oracle Cloud Infrastructure - Always Free tier
3 Lectures
Tutorialspoint
What's an Oracle Autonomous Cloud Database?
1 Lectures
Tutorialspoint
Provisioning Oracle Autonomous Database on Oracle Cloud Infrastructure
2 Lectures
Tutorialspoint
Accessing the Oracle Cloud Autonomous Database through SQL Developer
3 Lectures
Tutorialspoint
Oracle HR dataset installation using Oracle APEX and access using SQL developer
2 Lectures
Tutorialspoint
Retrieving Data from table using SQL statements
3 Lectures
Tutorialspoint
Restriction data retrieval based on condition "Where" clause
4 Lectures
Tutorialspoint
Functions in SQL statements
3 Lectures
Tutorialspoint
Conversion and Conditional Expression in SQL Select Statement
3 Lectures
Tutorialspoint
Aggregate Function and group by clause
2 Lectures
Tutorialspoint
Retrieving Information from Multiple table using Joins
5 Lectures
Tutorialspoint
Subqueries in SQL statements
2 Lectures
Tutorialspoint
Data Definition Language (DDL)
3 Lectures
Tutorialspoint
Data Manipulation Language - SQL statement
2 Lectures
Tutorialspoint
Introduction to Oracle DB - Data Dictionary.
2 Lectures
Tutorialspoint
Other DB objects - Sequence, Synonyms, Index & View
5 Lectures
Tutorialspoint
Database User Privilege & Roles
2 Lectures
Tutorialspoint
Developer tools with Oracle Cloud Autonomous DB - An Overview
3 Lectures
Tutorialspoint
Correlated Subqueries in SQL statements
2 Lectures
Tutorialspoint

Instructor Details

GUHARAJANM

GUHARAJANM


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual 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

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515