Header Ads

SQL ADVANCED

SQL ADVANCED


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

Created by Amarnath Reddy
Last updated 7/2017
English
English [Auto-generated]
What Will I 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
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 is the target audience?
  • 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.
Size: 1.05G

Content retrieved from: https://www.udemy.com/advanced-sql-tutorial/.

No comments