Oracle SQL

Install the Oracle database on Windows XP, select the enterprise edition as a single-instance database, create a new Windows user with a password, and complete the installation.

Master restricting data using single and multiple restrictions, operators, and literals in Oracle SQL. Then apply sorting with the order by clause, choosing ascending or descending order and handling nulls.

apply single row restriction in Oracle SQL using comparison operators, in, and/or to filter employees by department, salary range, and job type, with substitution variables.

Explore multi-row restriction in Oracle SQL using between, in, not in, and like with wildcards % and _ and escape characters, illustrated by salaries between 2000 and 4000.

Master sorting in Oracle SQL with order by, including ascending or descending order, multi-column sorts, nulls first or last, and the fetch first rows only option.

Explore practical Oracle SQL exam scenarios, practicing queries with select, from, where, and order by, covering ascending and descending sorting, implicit conversions, like patterns, and five percent rule examples.

Oracle sql ddl theory explains create, alter, drop, rename, and truncate commands to manage database objects such as tables, sequences, synonyms, and indexes, without performing insert, update, or delete operations.

Explore practical data definition language tasks in Oracle SQL, including creating and altering tables, adding and dropping columns, renaming objects, and using drop with recycle bin and flashback for recovery.

Explore data manipulation language in Oracle SQL, and learn how insert, update, and delete modify tables, while managing transactions with commit and rollback to finalize or revert changes.

Learn practical Oracle SQL inserts, including basic insert into values, column lists, insert all with conditional routing to small, medium, and big orders, and commit rollback control.

Explore practical DML update in Oracle SQL by updating single or multiple columns, using where clauses to target specific rows, setting nulls, and committing or rolling back changes.

Explore practical DML delete operations in oracle sql, including deleting all records, deleting with conditions, rolling back, and using merge for insert or update across source and target tables.

Explore Oracle SQL constraints theory, including primary key, unique, and foreign key concepts, and learn table-level and column-level constraint syntax with enabling, disabling, and adding constraints.

Create locations and workers with primary keys and a foreign key from workers to locations. Include a unique worker name and a salary check greater than 15000; emphasize constraint naming.

Explore practical constraints in Oracle SQL, including primary keys, unique constraints, and cascade delete, with metadata access and table alterations on departments and employees.

Practice oracle sql constraints with exam-style questions on dropping and altering columns, handling primary and foreign keys, defaults, and rollback implications.

Discover oracle single row functions and their types, including character functions, no functions, convergent functions, special or general functions, and conditional expressions, with practical, row-level outputs in depth.

Master Oracle SQL character functions through practical exercises on conversion and manipulation, covering upper, lower, initcap, concat, substring, length, instr, trim, ltrim, rtrim, replace, and lpad/rpad.

Explore Oracle SQL number functions in this practical session, including mod for remainders, round with decimal control, truncation, and ceil/ceiling and floor operations.

Explore Oracle SQL date functions through practical examples of sysdate, next_day, last_day, and months_between. Learn to_char, add or subtract days, months, and hours for dynamic date handling.

Explore explicit and implicit conversion functions in Oracle SQL, converting numbers, dates, and characters to different formats with practical examples of date handling, formatting, and between usage.

Master Oracle SQL general functions and conditional expressions by applying NVL, COALESCE, and CASE to handle nulls, convert data types, and compute salaries with commissions.

Explore Oracle SQL group functions and aggregate functions, including max, min, avg, and sum. Learn how to apply group by and having clauses to produce one result per group.

Explore group functions in Oracle SQL, using max, min, average, sum, and count with group by, having, and distinct to analyze salaries, commissions, and department data.

Oracle SQL exam preparation covers single row functions and group functions, evaluating expressions, nesting, and practicing having and group by usage.

Learn to master Oracle SQL joins, including inner, outer, and cross joins, with equal joins using on, using, and natural join; cover left and right outer joins and syntax styles.

Explore the ER diagram of the SCOTT and HR schema, identify common columns and references, and understand inner, left outer, and full outer joins.

Explore inner joins and equi joins in Oracle sql using on and using clauses, compare with natural join, and apply aliases and qualifiers to join multiple tables on common columns.

Learn to perform non equi joins and self joins with join on in Oracle SQL, using operators like between and salary comparisons to relate employees, salaries, and managers with aliasing.

Learn how left, right, and full outer joins—and cross join—retrieve matching and nonmatching rows across employees, departments, and locations, using equijoins and practical examples of departments without employees.

Explore practical joins, including inner, left outer, right outer, full outer, and natural joins, with cartesian product examples from employees and managers to prep for the exam.

Explore subqueries in oracle sql, including inner and outer queries, non-correlated and correlated types, and single-row versus multi-row subqueries using operators and table references.

Practice non-correlated and single/multi-row subqueries in Oracle SQL, using real-world examples to fetch jobs, compare salaries with all/any, and identify max salaries by department.

Explore correlated subqueries and analytical functions in Oracle SQL, including inline views, alias rules, pseudo columns, and ranking to identify top earners.

Explore subqueries in Oracle SQL through exam-style questions on update with subqueries, execution rules, and the truth of statements about comparing columns, cross-table data access, and subquery levels.