Skip to content
UdemySQLPaid courseAll LevelsCertificate

Oracle PL/SQL Fundamentals & Database Design--3course bundle (Udemy.com)

The ultimate Oracle/database course bundle with over 20 hours and 100 videos!

Created by: Intellezy Trainers

Last updated January 2018

icon
What you will learn

  • Over 100 lectures and 20 hours of content
  • Understand different types of databases
  • Relate tables with IDs
  • Understand normalization
  • Introducing Database Program Units
  • Creating and Maintaining Packages
  • Work with DECLARE, BEGIN & EXCEPTION clause
  • Understand and use nested blocks
  • Use explicit cursors

icon
Course Description

Over 20 hours and 100 videos are included in this bundle.

Save 20% by purchasing 3 Oracle/Database courses. This bundle includes:

  • Oracle PL/SQL Fundamentals vol. I
  • Oracle PL/SQL Fundamentals vol. II
  • Database Design Instruction

In this Oracle 11g PL/SQL vol I & II courses, you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

The Database Design Instruction course familiarizes the student with techniques necessary to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project.  Information in this course is a must for anyone responsible for building and maintaining a database.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Intellezy Trainers

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individuals

Our library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need them.

In today’s rapidly evolving workplace, it is imperative to make sure your team members have the skills and expertise required to succeed. Intellezy offers custom content development to ensure learning materials, and the delivery approach is aligned to meet intended outcomes and address your specific training needs without covering topics that may be unnecessary or irrelevant.

icon
More courses by Intellezy Trainers

$13.99

$14.99

$15.99

$39.99

$11.99

$14.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.5

468 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Jeremy Bertin on 4/24/2023

The course is excellent, and its format has been the most effective for me thus far. It begins with theory, followed by practical application. Instead of coding alongside the instructor, he presents prepared code and thoroughly explains it. This approach is highly efficient, as the videos are recorded in one take and the instructor demonstrates a deep understanding of the subject matter. He often uses relatable real-life examples to help illustrate concepts. I am thoroughly enjoying the course, having completed only half of it, and I already feel as though I've learned a great deal!

By Matúš Dúbrava on 1/27/2021

Great course. If you need to get up and running quickly with PL/SQL, this is definitely a great choice. Pros: - there is not so much theory that it would put you to sleep but enough for you to be able to understand the main concepts - each piece of theory is accompanied with a working code that you can try out - the biggest plus is the instructor himself - he definitely knows what he is talking about - frequently responds to questions in a professional/friendly manned, which is becoming a rare occurrence these days The only thing that I am missing in this course is some form of exercises but then again, there is a lot of working code that you can study so it is not such a big issue. Thanks to Tim Miles, one of the best instructors that I have ever encountered.

By James Strayer on 8/20/2020

DB Design:: Very good! The breakdown of normalization into the 5 steps, and the instruction on how to tackle each step was clearly explained with good examples. To me, the bad design / good design examples at the end were really "spot on" and just brought everything together. Thanks Tim!

By Abhinav Kaushik on 8/1/2020

wasted whole day for searching sqlplus in my system and have surfed internet just to access sqlplus. for a beginner it should be clarified how the sqlplus is installed in case the latest sql developer package not having the same. Later got to know it has to be installed separately and also nowhere it is mentioned that we need to go to which path to launch it.

By Rodney on 5/6/2020

The instructor's explanations are very well organized, articulate, and thorough. One of the best online courses on PL/SQL I've sampled. Great course for beginners as well as experienced professionals looking for a refresher. For any concept that may be difficult to understand at first, simply re-watch a few times and you'll get it.

By Judith Johnson on 4/13/2020

The course is excellent so far with lots of hints and tips, and the instructor appears trustworthy and is easy to understand. However, the instructor referred to downloading a zip file from "this page" rather than downloading from the Oracle website, but the zip file doesn't appear to be available.

By Ljubomir Kolarski on 3/18/2020

I will rate it as 5 stars because the instructor really goes into detail, things are pretty understandable (over different data types and all) but I must say that the setup courses were an agony, long long videos basically describing how to create shortcuts and what you will be learning and using and not much of the installation itself and just a lot of repetition where its not needed about desktop cleanliness, could be more accustomed to someone with a bit prior programming experience since it's not basic SQL but it's PL/SQL, so the target audiance will know basic computer usage :)

By Sreelatha pragadapati on 2/25/2020

I found Tim Miles to be the best instructor I have ever encountered. I almost spent 60000 to learn Oracle SQL and PL/SQL in the year 2013 with 'NIIT' and other institutes, but I was not happy with the content or lectures. The good thing about Tim is he gives tips based on his real experience with is very helpful.

By Jan Nortje on 11/7/2018

Great course, have learned a lot and has filled in a lot of missing blanks for me personally. I just have one request that has been bothering me from the beginning of Fundamentals I. Could you include a create user (schema) into the course to be used as our workspace? This can even be part of the course setup. I know we are using XE, but please do not use the SYSTEM account.

By Rubén Martínez on 5/8/2018

Excellent curse with an amazing teacher who shows a deep knowledge and knows how to explain it. Easy to follow and a good mix between theory and examples. I think could be easy to ask for some practice on a few of the difficult to understand topics such as triggers. Highly recommended.

Showing all 10 reviews on CourseDuck

Read all 468 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100