Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn Oracle SQL and PL/SQL fundamentals through this comprehensive tutorial covering database installation, data definition and manipulation commands, and procedural programming. Begin with installing Oracle Database 11g Release 2 Express Edition for Windows 64-bit, then master SQL DDL commands including CREATE, ALTER, and DROP TABLE operations. Explore SQL DML commands and operators such as relational, LIKE, and BETWEEN operators through hands-on demonstrations. Develop proficiency in string handling functions and Oracle's date data type along with its associated functions. Study data organization techniques using GROUP BY, HAVING, and ORDER BY clauses, then implement data integrity through primary key constraints and understand the differences between column-level and table-level constraints. Master foreign key constraints including ON DELETE CASCADE and ON DELETE SET NULL options, and learn to combine data from multiple tables using SQL joins. Create and manage database views for simplified data access and dive into subqueries including nested subqueries and ALL/ANY keywords. Transition to PL/SQL programming with anonymous blocks, stored procedures, and control structures including conditional statements and CASE statements. Practice loop constructs including FOR, WHILE, and simple loops, along with GOTO and NULL statements. Conclude with SELECT INTO statements and advanced procedure concepts covering IN, OUT, and IN OUT parameters through practical demonstrations.
