Data Bases

30 שעות לימוד

Data Retrieval: SELECT, SELECT DISTINCT, WHERE, TOP, GROUP BY, HAVING, ORDER BY

Data Manipulation: INSERT INTO, UPDATE, DELETE

Filtering & Comparison: LIKE, IN, BETWEEN, IS NULL, AND, OR, NOT

Aggregation: COUNT, AVG, SUM, MIN, MAX

Aliases: Assigning alternative names to columns or tables

30 שעות לימוד

Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, Self Join

Data Retrieval & Manipulation: SELECT, INSERT INTO, UPDATE, DELETE, UNION

Filtering & Logic: WHERE, HAVING, EXISTS, AND, OR, NOT

Data Aggregation & Functions: COUNT, AVG, SUM, MIN, MAX ,Date Functions, Any, All

Data Types & Conversion: Numeric Functions, String Functions

50 שעות לימוד

Fundamentals:Introduction, Basic Syntax, Operators & Functions

Data Structures:Collections, Records, Data Types

Control Flow:Conditions & Loops

Database Interactions:Environment & Connections, Cursors & Transactions

Stored Programming:Procedures & Functions, Packages & Triggers

Advanced Concepts:Variables & Constants, Arrays & Object-Oriented Programming, Exceptions & Error Handling, DBMS Output