Skip to content
Write a review
UdemySQLPaid courseExpert levelCertificate

SQL Advanced (Udemy.com)

Lead yourself to enhance your SQL skills and transform into Senior SQL Developer. Learn SQL by doing with me.

4.5
1,533 reviews

Created by: Amarnath Reddy

Last updated December 2018

icon
What you will learn

  • Understand the key advance concepts being implemented in the database world
  • Choose between Views and Materialized views based on the requirement
  • Partition the tables for better management and performance optimization
  • Perform complex pattern matching using Regular Expressions
  • Create advanced reports with sub totals at various grouping levels
  • Perform analysis with ease using the analytical functions

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.5 out of 5higher than 48% of them
  • Reviews1,533#114 of 389 by number of reviews
  • Length5 hoursshorter than 60% of them
  • Last updatedDecember 2018earlier than 75% of them

icon
Quality Score

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

Overall Score : 90 / 100

icon
Course Description

Senior SQL Developers are in high demand and demand 100k+ salary in the IT industry.

If we have to advance in our career and earn a good salary, we need these Advanced SQL skills. So let's take the next step of learning these advanced concepts of Oracle SQL.

Learning these advanced SQL concepts would position you better in your working environment.

What will we learn?

Students will learn the art of breaking a big SQL statement into small pieces and rebuild it again.

Create Materialized views to replicate data across servers and improve performance by using simple SQL syntax.

Partition the tables for better management and performance optimization using SQL Partitioning.

Students will learn to use Analytic SQL to aggregate, analyze and report, and model data using the SQL Analytic capabilities.

Students will learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure using SQL Hierarchical features.

Students will also learn to use regular expressions and subexpressions to search for, match, and replace strings using SQL built in functions.

Group and aggregate data using the built in SQL functions like ROLLUP and CUBE operators.

See you inside,

Amarnath Panyam
Read More Expert Expert Level product length iconTime: 5h

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.

Get the Udemy discount

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

Amarnath Reddy

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.

Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.

Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.

Read More

icon
More courses by Amarnath Reddy

$15.99

$14.99

$13.99

$11.99

$13.99

$14.99

All courses by Amarnath Reddy

icon
Reviews

4.5

1,533 ratings on Udemy

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

Write a review

By Ganesh chittalwar on 9/23/2020

everything is okk very good work but one think is missing that is your are not explain about keyword and each one sentence. please explain each and every line

By Zielinskiijan on 9/17/2020

I wanted to develop new sql skills and indeed I did not know some of them :)

By Dinesh kumar Singh on 9/5/2020

I was really afraid of writing SQL query before watching this tutorial, even though I have very good experience in backend development. Very nice tutorial, I am dam sure recommending others. Thanks a lot for such a session.

By Ravinder Singh on 8/27/2020

To the point course.

By Dmitry V Erikalov on 8/23/2020

Very basic

By Satish T on 8/20/2020

ok

By Milina Salvi on 8/19/2020

Good Session

By Obtain IT Consultany LLP GSTN : 27AADFO8 on 7/20/2020

Yes it is

By Abdollah Sobhy on 7/11/2020

Useful course.
I just wish if the instructor responds to people comments.

By Samuel Turner-Lill on 7/2/2020

Instructor does a great job showing the end result of the topic at the beginning of the lecture and then using the remaining time to explain and demonstrate the concept. He speaks carefully and plainly so that he can be easily understood even to those unfamiliar with his accent. Overall very good.

By warisha Naaz on 6/20/2020

Detailed oriented and Useful.

By Vinay Sharma on 6/17/2020

It's like going through an instruction manual. Examples are good but there is almost no depth to enable understanding. Good course to keep as a reference but has almost no explanations. Also I think the course should be called 'oracle' advanced sql, since there is NO information about Postgre, MS Sql server, Sybase or even the new AWS based simple database server. I learnt that it is important to watch the sample video before purchasing.

Showing 12 of 310 reviews

SQL Advanced
Visit course on Udemy Write a review
  • Video Duration: icon 5h
  • Price: $12.99
  • Provider: icon Udemy
  • Updated: icon December 2018
  • Level: Expert Expert
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com