Oracle SQL – Basics for data analysts

Why take this course

Do you need to perform accurate and fast data analysis but are not yet familiar with the capabilities of Oracle SQL? This course will help you master SQL from the ground up, focusing on data manipulation, analytical functions, and reporting. You’ll learn to write queries, create functions and procedures, and use advanced analytical tools that are essential for any data analyst.

What you'll learn

• Write clean and optimized SQL queries.
• Work with various data types and database objects.
• Use aggregate and analytical functions effectively.
• Perform multi-dimensional analysis using CUBE, ROLLUP, and grouping.
• Create your own functions and procedures in PL/SQL.
• Leverage advanced analytical functions such as windows, rankings, LAG/LEAD, and FIRST/LAST.
• Automate tasks and streamline analysis of large datasets.
• Handle hierarchical queries and use the WITH clause.
• Apply statistical functions and reporting tools.

Certification & Exam

Upon completing the training, you will receive a named certificate confirming your skills in Oracle SQL, including creating queries, using analytical functions and procedures, and analyzing large datasets. There is no final exam—just active participation is all that’s required.

Who is this course for

• Data analysts who work with Oracle databases.
• Members of project teams who create reports and analyses.
• Individuals who want to learn SQL and PL/SQL in a practical context.
• Professionals looking to deepen their knowledge of analytical functions and query optimization.

Topics covered

• Basics of databases
• Schemas, Oracle database objects
• Creating SQL queries
• Joints (join)
• Subqueries
• WITH construction
• Built-in functions and procedures
• Date and time functions
• Hierarchical questions
• Multidimensional grouping
  • Rollup
  • Cube
• Analytic functions
  • partitions
  • windows
  • ranking features
  • window functions
  • reporting functions
  • LAG / LEAD functions
  • FIRST / LAST functions
  • inverse percentile functions
  • functions of the hypothetical ranking
  • WIDTH_BUCKET function
  • statistical functions