34 docs tagged with "advanced"

Learn how to create temporary tables for intermediate processing and how to copy tables for backup or testing purposes in SQL. Free student exam study guide.

Learn how to return query results directly from Oracle procedures using DBMS_SQL.RETURN_RESULT. Master modern result handling in Oracle 12c+.

Master Java Abstraction and Interfaces. Learn how to hide complexity using the Remote Control scenario. Compare Abstract Classes vs Interfaces.

Learn about Composition in Java with real-world examples: Houses, Cars, and Computers. Understand why parts cannot exist without the whole. Complete.

Master Java Input/Output. Learn the difference between Byte Streams, Character Streams, and high-speed Buffered Readers using the Hose vs Bucket scenario.

Comprehensive guide to Java Inheritance. Master parent and child classes using the Royal Family scenario. Understand extends, super, and technical constraints.

Master advanced Java concepts: Inner Classes, Anonymous Classes, and Enums. Learn how to nest classes and manage constants using the Smartphone scenario.

Master Java Lambda expressions. Learn how to write concise, functional code using the Delivery Order scenario. Includes Stream API preview. Complete.

Master Java Polymorphism. Learn how different objects respond to the same method call using the Superhero scenario. Explains Overriding vs Overloading.

Master Java Regular Expressions and Threads. Learn how to search patterns using the DNA Scanner scenario and speed up apps with the Team scenario.

Master Java's try-with-resources statement. Learn how to automatically close files and database connections using the Self-Closing Gate scenario.

Master Java's advanced features. Learn about Wrapper Classes (Autoboxing) and Generics using the Cardboard Box scenario for type safety. Complete.

Master Async/Await in JavaScript. Learn how to write clean, synchronous-looking asynchronous code using the Delivery Waiter scenario. Complete.

Learn how JavaScript handles tasks that take time. Master Promises and Async/Await using the Pizza Shop scenario. No more Callback Hell!. Complete.

Master the FULL OUTER JOIN in Oracle. Learn how to combine all records from both tables, filling in NULLs where no matches exist. Free student exam study guide.

Oracle advanced INSERT — INSERT INTO SELECT, multi-table inserts, and conditional inserts with examples. Bulk data loading techniques for BCA Oracle SQL.

Learn how to use Oracle Outer Joins. Understand how to keep all records from one table even if no matching record exists in the joined table.

Master the Oracle MERGE statement. Learn how to perform an Insert or Update in a single operation based on data existence. Free practical study guide for exams.

Master advanced data transformation in Oracle. Learn how to convert rows to columns with PIVOT and rotate columns to rows with UNPIVOT. Complete.

Master Oracle PL/SQL. Learn block structure, variables, cursors, and triggers using our story-driven roadmap. Perfect for BCA and enterprise database learners.

Learn advanced join techniques in Oracle. Master SELF JOIN for hierarchies and CROSS JOIN for generating Cartesian products. Complete student exam study guide.

Learn advanced data selection in Oracle using subqueries. Master Correlated queries, EXISTS vs IN, and ANY/ALL comparisons. Complete student exam study guide.

Practice classes, objects, __init__, inheritance, methods, and encapsulation with three levels of challenges. Complete practical study guide for student exams.

Practice file I/O, exception handling, algorithms (search/sort), and database basics with three levels of challenges. Free student notes & practical code guide.

Practice pandas Series, DataFrames, CSV handling, and basic data analysis with three levels of challenges. Free student notes & practical code examples guide.

PostgreSQL tutorial — master the most advanced open-source relational database. Covers setup, DDL, DML, SELECT, joins, and PostgreSQL-specific features.

Master Python Async/Await. Learn async def, await, asyncio, tasks, and gather for concurrent I/O operations with real-world examples. Complete.

Master advanced Python tools. Learn how to wrap functions with Decorators and process huge data with Generators using the Gift Wrapper scenario.

Learn how to search text with Regular Expressions and speed up your code with Multiprocessing. Includes the DNA Scanner and Kitchen Team scenarios.

Learn how to use SQL Left, Right, and Full Outer Joins to retrieve unmatched data. Understand how to handle NULL values in joined reports. Complete.

Learn how to use Recursive CTEs to query hierarchical data. Perfect for organizational charts, category trees, and graph data structures. Complete.

Master advanced SQL joins. Learn how to join a table to itself (Self Join) for hierarchies and how to create Cartesian products with Cross Join.

Master SQL Subqueries. Learn how to write queries within queries to solve complex data retrieval problems. Includes Correlated vs. Non-Correlated logic.

Master the SQL WITH clause. Learn how to create Common Table Expressions (CTEs) to make complex queries readable and modular. Complete student exam study guide.