The Complete Oracle SQL course for Data Analysts -A-Z of SQL

Download the Oracle database express edition on Windows or Linux, unzip the file, run the setup, accept the license, create a strong password, and expect about 20–25 minutes for installation.

Learn to download and open Oracle Developer, extract the package, and navigate to the interface used to connect to an Oracle database, with upcoming lessons on creating connections.

Create an Oracle connection by entering username, password, hostname or IP, port, and service name, test the connection, and save the configuration for easy access.

Discover two methods to create a new table in Oracle SQL: a GUI approach and a SQL syntax approach. Define column names, data types, and comments, then run to create.

Learn to alter an existing table in Oracle SQL by adding a foreign key referencing the regions table, modifying table properties, and verifying the changes.

Explore how primary keys uniquely identify rows in a table and how foreign keys refer to a table's primary key to relate rows across tables.

Insert data into a table using the insert into syntax with a column list and values. Use a bulk data method by right-clicking the table and importing from a file.

discover how to use the select statement to fetch data from a table by selecting specific columns and viewing the results.

Learn how to delete data from a table in Oracle SQL using the delete statement, confirm the effect by counting rows, and practice deleting nine rows.

Learn how to use the where clause to filter data with conditions, including region-based and pattern matches, demonstrated through examples of countries and starts with criteria.

learn how to use the order by clause to sort query results by one or more columns, in ascending or descending order using asc and desc, with country name examples.

Learn to drop a table with the drop statement in Oracle SQL, verify removal, and understand error messages when the object does not exist.

Explore how and and or filter data in SQL queries using a where clause on employees table. Understand inclusive vs exclusive conditions and how salary and department criteria shape results.

Master using in and null in Oracle SQL to filter data, apply not in and is null or is not null conditions, and handle null-valued columns in data analysis.

Explore how the like function filters data in Oracle SQL using wildcards to match patterns, including starts with, between ranges, and not like exclusions.

Learn how to perform basic mathematical functions in Oracle SQL, such as addition, subtraction, and multiplication, applying them to table values and observing how zeros affect results.

Explore substr and instr in Oracle SQL to extract characters from strings, specify start positions and lengths, and search for first occurrences, including reverse (right-to-left) extractions using negative indices.

Learn how to pad strings using lpad and rpad to a target length with a chosen character, and trim whitespace from the left, right, or both ends.

Learn how to concatenate two values with the Oracle concat function, insert a space between first and last names, and extend to additional values via nesting.

Master the upper and lower functions in Oracle SQL to convert text to uppercase or lowercase, apply them to characters in a column, and understand their practical usage.

Learn how to replace a character in a string using the Oracle SQL replace function, with syntax guidance and practical examples.

Learn how to limit Oracle SQL results to the initial rows using fetch first n rows only and the rownum function, with practical examples and comparisons.

Explore how inner, left, right, and full joins combine two tables by matching rows, showing how nonmatching data appears in left and right joins, with join syntax examples.

Explore distinct values and group by operations in Oracle SQL to summarize data by department, counting entries and calculating averages.

Learn how the having clause filters grouped results produced by group by, using aggregates such as min salary, max salary, count, sum, and average per department.