SQL/PLSQL Advance Certification

Explore advanced SQL queries in Oracle SQL Developer, mastering built-in functions like average, maximum, minimum, sum, and count; learn group by, having, where, and distinct to analyze employee data.

Explore built-in group functions such as average, maximum, minimum, sum, variance, count, and learn how group by, order by, where, and having clauses shape Oracle SQL queries with null handling.

Explore relational database joins, including natural, equijoin, self-join, inner and outer joins, and cross joins, and learn when to use using or on clauses with aliases.

Master using and on clauses, natural joins, and self-joins in Oracle SQL, while querying employees, departments, and locations, and practicing in Oracle SQL Developer.

Explains left and right outer joins between employees and departments, using on or using clauses, demonstrates null values, then covers cross joins and Cartesian products and promotes equijoins.

Explore subqueries in SQL, including single-row and multi-row patterns, with salary and department data and the use of group by and having.

Learn to apply union, intersection, and minus in Oracle SQL Developer, merging employee and job history data, handling nulls, and using union all for current and previous departments.

Practice composing English sentences with SQL using two union operators, learn union, intersection, and minus, via the dual table and underscore dummy values, culminating in professional Oracle SQL Developer usage.

Create and drop tables using SQL, including syntax, with Oracle SQL Developer and graphical tools like Toad, and note the impact of commit on rollback.

install the lemon key database, set up virtual memory, run the installer, configure a desktop-class 11g database named ORCL, then use sqlplus to alter and unlock the user for practice.

Explore lecture 18 in the sql/plsql advance certification course to advance your sql and plsql training.

Copy the locations table into a new table using create table as select to replicate structure and data. Insert rows by listing columns, with other fields defaulting to null.

Create a new student table with id, name, city, registration date, and default system date; insert data and verify results, and discuss adding a primary key.

Create a student table, insert multiple records, and enforce primary key uniqueness to prevent duplicates, then use delete from student where id = 12 to remove records.

Install Oracle 11g database and developer suite; run as administrator, adjust virtual memory, and configure the database. Open sqlplus to unlock default users such as HR and scott.

Create and manage Oracle SQL Developer tables for students, class, session, faculty, and instructor, and set up two users for master and details forms, including Udemy master and details.