16 docs tagged with "foundations"

C Course Foundations hub — 2D arrays, structures, unions, and user-defined functions aligned with BCA Programming Skills 204 (Code 204) learning outcomes.

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

Practice HTML foundations — headings, paragraphs, images, lists, links, navigation, and multi-section pages. Free student notes & practical code examples guide.

Practice variables, data types, operators, string manipulation, and type casting with three difficulty levels. Complete practical study guide for student exams.

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

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

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

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

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

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

Python Course Foundations hub — variables, data types, strings, lists, collections, functions, and OOP basics aligned with BCA 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.