SQL Advanced (Udemy.com)

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

( 315 Reviews )

Created by: Amarnath Reddy

Produced in 2018

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

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

Who this course is for:

This SQL course is meant for students who already have familiarity with the SQL syntax and would like to learn the advanced concepts of SQL.

Time: 4.5h

Instructor Details

Amarnath Reddy

4.4 Rating
315 Reviews

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.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.4

315 total reviews

5 star 4 star 3 star 2 star 1 star

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

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.