15 docs tagged with "foundations"

Foundation topics for C language courses, aligned with Programming Skills 204 learning outcomes.

A complete guide to Oracle data types. Understand the difference between CHAR and VARCHAR2, and master NUMBER, DATE, and TIMESTAMP.

Practice HTML foundations — headings, paragraphs, images, lists, links, navigation, and multi-section pages.

Learn the structure of a PL/SQL anonymous block. Understand the DECLARE, BEGIN, EXCEPTION, and END sections with practical examples.

Learn how to use comments in PL/SQL. Understand single-line and multi-line comment syntax and best practices for clean, readable code.

Learn how to use constants in PL/SQL. Understand why some values should never change during program execution and how to declare them.

Understand PL/SQL data types. Learn about scalar types, Boolean, and the powerful %TYPE anchored declaration for dynamic column matching.

Learn how to use the NULL statement in PL/SQL. Understand why a command that does nothing is essential for placeholder logic and labels.

Master PL/SQL variables. Learn how to declare variables, assign values using := and SELECT INTO, and understand variable scope.

Foundation topics for Python language courses, aligned with Programming Skills 204 outcomes.

Understand the 4 pillars of SQL commands: DDL (Structure), DML (Data), DCL (Permissions), and TCL (Transactions). A complete guide with examples.

Understand the different data types in SQL including CHAR, VARCHAR2, NUMBER, and DATE. Learn how to choose the right type for your database columns.

A complete guide to SQL operators. Learn how to perform calculations, compare values, and combine logic using Arithmetic, Comparison, and Logical operators.

Master the fundamental syntax rules of SQL. Learn about keywords, identifiers, case sensitivity, semicolons, and comments in Oracle, MySQL, and SQL Server.

Understand the core concepts of PL/SQL (Procedural Language/Structured Query Language). Learn about its architecture, benefits, and how it extends standard SQL.