Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications 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 Certification Network & Security Hardware Operating Systems 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 Design Thinking 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 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 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 Yoga Mental Health Dieting 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 Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software SQL

SQL Advanced

Lead yourself to enhance your SQL skills and transform into Senior SQL Developer. Learn SQL by doing with me.
Rating: 4.1 out of 54.1 (1,342 ratings)
9,651 students
Created by Amarnath Reddy
Last updated 12/2018
English
30-Day Money-Back Guarantee

What you'll 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

Requirements

  • Brush up necessary SQL skills so that it is easy to follow the advanced concepts.

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.

Course content

11 sections • 82 lectures • 4h 58m total length

  • Preview01:34
  • How to make best use of the program.
    1 page

  • Installing Oracle
    03:08
  • Installing Java SDK
    02:00
  • Installing SQL Developer
    03:50
  • Running scripts necessary for the course
    02:12
  • Scripts used in the demonstration
    20 pages

  • Default values for columns
    05:43
  • Virtual Columns
    05:26
  • Arithmetic calculations on NULL Values
    05:38
  • Multi table Insert's
    05:38
  • Merge the data...
    09:42
  • Lab Setup
    00:05
  • Exercise 1
    00:04

  • Analytical Functions Introduction
    04:29
  • Why Analytical Functions Example 1
    Preview06:06
  • Why Analytical Functions Example 2
    02:39
  • Getting the cummulative Sum of Sales
    01:40
  • Displaying Sales as a percentage of Total sales
    03:04
  • Ranking your data
    03:55
  • Preview03:25
  • Dividing your data into Bands
    04:02
  • LAG and LEAD function Examples
    04:22
  • Analyzing Sales growth across time
    03:17
  • Analytical Functions Recap
    3 pages
  • Exercise 2
    00:04

  • Preview04:32
  • Preview03:14
  • Row level data to Column level using LISTAGG
    03:43
  • Column level data to Row level using UNION
    04:04
  • Column level data to Row level using UNPIVOT
    03:32
  • Data Transformation Recap
    00:02
  • Exercise 3
    00:04

  • Hierarchical Queries Introduction
    01:51
  • Connect By clause
    05:08
  • Preview03:21
  • Sorting the Hierarchy Tree
    02:08
  • CONNECT_BY_ROOT unary operator
    02:34
  • Get me the Sales under Manager Raj
    03:42
  • SYS_CONNECT_BY_PATH function
    01:48
  • CONNECT BY for number generation
    01:17
  • Hierarchical Queries Recap
    2 pages
  • Exercise 4
    00:04

  • Extensions to Group BY
    00:47
  • Preview04:32
  • Sub Totals using CUBE function
    02:09
  • GROUPING function
    03:55
  • GROUPING_ID function
    03:17
  • Limiting number of sub totals using GROUPING SETS function
    04:41
  • Composite Columns
    04:44
  • Group by Extensions Recap
    5 pages
  • Exercise 5
    00:04

  • Read This!!!!
    1 page
  • Preview04:46
  • Range Partition based on range of values
    09:38
  • List Partition based on list of values
    06:09
  • Hash Partition based on the hash key
    05:40
  • Composite Partitioning by mixing things up!!
    04:38
  • Interval Partition for automatic partition creation
    07:12
  • Adding/Droping Partitions
    1 page
  • Table Partitioning Recap
    2 pages

  • Preview03:26
  • Materialized Views creation Options
    03:33
  • Materialized Views with ON COMMIT option
    05:38
  • Materialized Views with ON DEMAND option
    04:06
  • Materialized Views with REFRESH FAST option
    06:16
  • Timing the refresh
    03:50
  • Query Rewrite functionality
    05:40
  • Materialized Views Recap
    5 pages

  • Preview03:06
  • Meta Characters . and +
    04:16
  • Meta Characters ? and *
    04:22
  • Interval Operator to match the number of occurances
    03:55
  • Matching the characters in a List
    04:55
  • Lets combine multiple expressions using |
    02:02
  • Check for an expression in the beginning or end of a string
    02:18
  • POSIX Character class operators
    03:26
  • Search for meta characters by placing a escape character
    02:07
  • More examples on Regular Expressions
    1 page

Instructor

Amarnath Reddy
Oracle Architect & Best Selling Instructor | 27000+ Students
Amarnath Reddy
  • 4.4 Instructor Rating
  • 16,197 Reviews
  • 72,326 Students
  • 9 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.