Hierarchical & Recursive SQL
4.1 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
53 students enrolled

Hierarchical & Recursive SQL

SQLs like Oracle CONNECT BY and Common Table Expressions (CTE)
4.1 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
53 students enrolled
Created by Sanjay Singh
Last updated 11/2017
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Recursive SQL: What is it? How it is used? Where it is used?
  • Oracle Database 11gR2 installation
  • CONNECT BY with all it's options like START WITH, LEVEL,CONNECT_BY_ROOT, SYS_CONNECT_BY_PATH, CONNECT_BY_PATH, CONNECT_BY_LEAF, NOCYCLE and much more.
  • SQL Developer Operations
  • Common Table Expression (CTE)
  • Interesting Assignments from Real life projects
Requirements
  • Basic Knowledge of Computer and Windows Operating System
  • Basic Knowledge of SQL
  • Desire to learn
Description

Join the most comprehensive and popular Hierarchical & Recursive SQL Course on Udemy, because now is the time to get started!

From basic concepts about recursive SQL like CONNECT BY, COMMON TABLE Expression (CTE) this course covers it all you need to know to become an expert in recursive SQL.

But that's not all! Along with covering all the steps of recursive SQL, this course also has quizzes and projects, which allow you to practice the things learned throughout the course!

You'll not only learn about the concepts, but also practice each of those concepts through Projects.

And if you do get stuck, you benefit from an extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience, I have designed this course for students and professionals who wish to master how to develop and support industry standard recursive SQL and be reason behind successful project implementation.

This course will be kept up-to-date to ensure you don't miss out on any changes once recursive SQL is required in your project!

Why to learn Hierarchical and Recursive SQL?

If you are know SQL, learning  hierarchical and recursive SQL techniques can be a boon to your productivity. You will write simple SQL codes to achieve same thing which other programs will achieve writing several line of codes.

Pay once, benefit a lifetime! This is an evolving course! recursive SQL in Oracle 12c and later future versions will  be covered in this course.  You won’t lose out on anything! Don’t lose any time, gain an edge and start now!

Who this course is for:
  • Students looking forward to a thriving career in IT.
  • Professionals who wants to keep their IT skill up to date and remain future ready.
  • Professionals and Students with basic knowledge of SQL and desire to become expert SQL professional.
  • Anyone who wants to grab opportunity available in Data and Information related professional like data analyst, scientists, engineer, developer.
Course content
Expand all 14 lectures 45:32
+ Introduction
1 lecture 04:10

Welcome to this course!

This introductory lecture explains you why you should learn Recursive SQL.

Preview 04:10
+ Preparation
4 lectures 12:26

In this lecture you will download, install and configure Oracle Database Express Edition (XE).

Oracle Database Express Edition
05:22

In this lecture you will download SQL Developer.

Preview 03:56

In this lecture you will connect the SQL developer with your local Oracle Express Database.

Connection
01:27

This is an optional lecture. It shows you how to change database password using SQL developer, in case you need to.

Password Reset
01:41
+ CONNECT BY
7 lectures 20:30

In this lecture you will write your first CONNECT BY SQL, and understand how it works. The START WITH and CONNECT BY PRIOR clauses are explained in this lecture.

CONNECT BY
03:27

In this lecture you will learn use of LEVEL pseudo column in recursive SQL.

Preview 02:19

In this lecture you will learn about ORDER SIBLINGS BY clause.

ORDER SIBLINGS BY
02:39

In this lecture you will learn about SYS_CONNECT_BY_PATH.

SYS_CONNECT_BY_PATH
03:09

You will learn about CONNECT_BY_ROOT in this lecture.

CONNECT_BY_ROOT
03:40

In this lecture you will learn about CONNECT_BY_ISLEAF.

CONNEC_BY_ISLEAF
01:41

In this lecture you will learn about NOCYCLE and CONNECT_BY_ISCYCLE

NOCYCLE and CONNECT_BY_ISCYCLE
03:35
Write SQL which shows numbers from 1 to 1000 and classify them as odd or even.
Numbers from 1 to 1000 with Odd and Even Indication
1 question
+ Common Table Expression (CTE)
2 lectures 08:26

In this lecture you will write first SQL using common table expression.

Common Table Expression -Introduction
04:40

This is first lecture in series using recursive SQL for mathematical functions. In this lecture you will show number 1 to 100 using common table expression (CTE) with numbers.

Mathematical Function -> List of Numbers
03:46