Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Business Intelligence Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Email Marketing Google Analytics Startup Advertising Strategy

Office ProductivityOraclePl/SQL

Oracle PL/SQL Fundamentals with Case Study (OCI)

Build Oracle PL/SQL expertise using Oracle Cloud Autonomous DB (OCI). Built-in case study to make understanding better
Rating: 4.0 out of 54.0 (1 rating)
3 students
Created by Guha Rajan M., B.Engg, MBA, PMP
Last updated 5/2022
English
English [Auto]

What you'll learn

  • Oracle PL/SQL Programming
  • Provisioning Oracle Cloud Autonomous Database with Oracle Cloud Infrastructure(OCI)
  • Connecting to Cloud Autonomous Database using SQL Developer client.
  • Case study to make understanding of PL/SQL better

Requirements

  • Basic understanding of Oracle SQL statements.
  • Oracle Database Access through SQL OR Request / provision Autonomous Oracle Cloud Autonomous Database in OCI free tier

Description

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

SQL & PL/SQL has established itself as the de-facto data access language used across many different industries, that's available in the database. 

This means that SQL & PL/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 and PL/SQL isn’t going anywhere. Its stable in popularity and still dwarfs NoSQL databases on a side by side comparison.

The advantage of PLSQL is

PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications.

PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database.

Applications written in PL/SQL are fully portable.

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 , utilize it to learn SQL (not covered in detail in this course ) and PL/SQL, which is covered in details.


The PL/SQL topics covered in this course are :


  • Different Oracle DB environment to Learn & Practice.

  • 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 – SQL Developer.

  • What is PLSQL?

  • Oracle PLSQL programming approach

  •            Naming conventions and formatting.

  •            Scope of variable declaration &  nested block

  • Using PLSQL to interact with Oracle DB

  • Cursors in PLSQL.

  • Control Statement in PLSQL

  • Handling Exceptions in PLSQL

  • Subprograms  & Composite data type

  • Database triggers.

  • Case study in SQL & PLSQL

  •     Business case & problem statement provided in document format for the learner to work upon & provided solution.

  •     Solutions presentation in detail to validate your solution.


Happy Learning!!

Who this course is for:

  • IT Analyst
  • IT Developer looking for career in Oracle PLSQL
  • Students in IT / Engineering / Management
  • Any one who have knowledge on SQL and wish to learn PLSQL

Instructor

Guha Rajan M., B.Engg, MBA, PMP
Founder and CEO - Capstone Solutions, Trainer
Guha Rajan M., B.Engg, MBA, PMP
  • 3.8 Instructor Rating
  • 1,007 Reviews
  • 5,438 Students
  • 42 Courses

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 Internet of things and Machine learning, AI these days.

Due to his vast experience, he has crafted varied unique courses in Udemy 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 Cloud Infrastructure 2021 Architect Professional.

Oracle Cloud Infrastructure 2021 Architect Associate.

Oracle Cloud Infrastructure 2021 Cloud Operations 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 ) recently.

He holds a degree in engineering (Computer science) with MBA and a certified PMP since 2007



Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.