Oracle SQL, PL/SQL in the free cloud DB by practical examples
Empower Your Career with Hands-On Expertise: Oracle SQL & PL/SQL
Oracle Database,Database Programming,Databases,Oracle SQL,SQL,
Lectures -62
Resources -46
Quizzes -4
Duration -6.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
You don't have to be a know-it-all to dive into coding for real-life projects. This course throws you right into the action, tackling problems from the very start. Before you know it, you'll be doing real-world projects with confidence and speed.
No boring theory! The course is designed with an emphasis on hands-on experience. Every topic has a detailed explanation video and tasks you have to perform by yourself.
At first, we will learn some general SQL and Database topics:
Create an Autonomous Transaction Processing Database in the Oracle Cloud and configure a connection.
Learn how to create ERD diagrams.
Learn about different types of Database Objects, Data Types, etc.
Learn how to perform DML operations: SELECT/INSERT/UPDATE/DELETE
Learn DDL operations: CREATE TABLE/INDEX/SEQUENCE/TRIGGER
Create additional schemas and load data.
Learn Built-in Functions, JOIN operations, Subqueries, etc.
With these basics mastered, the course will take you through program flow control by teaching you PL/SQL topics:
How to use for loops, while loops, and conditional if-else statements to add complexity and functionality to your programs.
Working with Composite Data Types.
Working with explicit cursors.
Handling Exceptions.
Creating Procedures and Functions.
Complete with working files and code samples, you’ll be able to work alongside the author as you work through each concept.
Finally, we will develop several solutions for real-world projects. With this experience under your belt, you'll be infused with the confidence to seize any opportunity that comes your way, no matter how challenging it may seem.
Students completing the course will have the knowledge and skills required for a DBA and Oracle PL/SQL developer positions.
Get ready to thrive!
Goals
Master PL/SQL Easily: This course, crafted by a current Oracle developer, provides the perfect tools for complex projects without overwhelming theory. Dive into hands-on tasks, making learning practical and effortless.
![Oracle SQL, PL/SQL in the free cloud DB by practical examples Oracle SQL, PL/SQL in the free cloud DB by practical examples](https://d3mxt5v3yxgcsr.cloudfront.net/courses/17275/course_17275_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Intro 02:00 02:00
What is a Database?
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Create an Always Free Cloud Account
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Create ERD
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What is SQL?
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
DML
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Database Objects
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Types
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Database Normalization
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
DDL
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Load Sample Schemas to ATP database
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Built-in Functions
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
JOIN Tables
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Subqueries
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
SQL Interview Example
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What is a PL/SQL?
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
OCI Cloud Shell
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Load Data to DB
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PL/SQL variables
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PL/SQL executable statements
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PL/SQL control structures
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PL/SQL composite data types
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PL/SQL Explicit Cursors
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PL/SQL Exceptions
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PL/SQL Procedures & Functions
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Self Education
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Projects
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Bonus: Performance
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
ALEXEY GUSAROV
My name is Oleksiy and I am a certified DB expert at Oracle USA. Initially I was working with MySQL databases but had to retrain for the Oracle Database. And I have been working with Oracle Technologies for 5 years already. During this time our team has successfully migrated our application from MySQL to Oracle database. And later we were among the first to migrate our database to the cloud ( OCI ). Currently I have the following responsibilities: Define, design, and implement database solutions within a fast-paced, leading edge applications company. Performance trend analysis and manage the server/network capacity. Propose client configuration and implement technical solutions to enhance and/or troubleshoot the database systems.
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)