Super Oracle Developer

Oracle SQL

30 Training HoursStructured query languageTrack 01 of 6

Space Code AcademyScroll down

Course overview

SQLStructured query language

We provide practical Structured Query Language (SQL) training that helps learners understand databases, write efficient queries, and manage data confidently for real business applications.

30Training hours
4Course modules
23Listed topics
1Capstone project
Track 01

Oracle SQL

30 Hours
01Introduction to databases and SQL4 topics
  • What is a database?
  • Relational databases and SQL
  • Introduction to Oracle Database
  • Installing and setting up Oracle Database
02SQL syntax and basic queries5 topics
  • SELECT statement
  • FROM clause
  • WHERE clause
  • ORDER BY clause
  • Arithmetic expressions and NULL values
03Filtering and sorting data6 topics
  • Comparison operators
  • Logical operators (AND, OR, NOT)
  • LIKE operator and wildcard characters
  • IN and BETWEEN operators
  • Sorting data with ORDER BY
  • Handling NULLs in sorting
04Joins8 topics
  • Inner join
  • Left outer join
  • Right outer join
  • Full outer join
  • Self join
  • Cartesian product (cross join)
  • Equi-join and non-equi-join
  • Joining multiple tables
Beyond the modules

Additional Course Content

01

Data Definition (DDL) and Oracle Objects

Learn about DDL and its relation to Oracle Objects such as creating tables, defining data types and constraints, and manipulating table structures.

02

Data Control (DCL)

Understand the basics of Data Control Language (DCL) in SQL, including managing user roles, permissions, security, and auditing.

03

Performance Tips and Tricks Tuning and Optimization

Dive deeper into performance optimization in SQL, covering techniques like execution plans, optimizer hints, indexes, and materialized views.

04

Best Practices and Projects

Understand the best practices for writing efficient and secure SQL code, and learn how to avoid common pitfalls and security vulnerabilities.

Capstone

Apply Your Skills: Capstone Project

  • This capstone project will solidify everything learned throughout the course.
  • The instructor will guide students through selecting and completing a project of their choice.
  • The project should demonstrate a thorough understanding of SQL, PL/SQL, Forms, and Reports.
Ready to grow your brand into a legacy?

Lets Make Something

Great together