Tag: database
-
Session 4: Working with Data Main Topics Covered: SQL Examples from the Session 1. Using Logical Operators SELECT * FROM students WHERE age >= 18 AND name LIKE ‘J%’; SELECT * FROM training_exercises WHERE difficulty_level = ‘hard’ AND is_completed = false; 2. Sorting Data SELECT * FROM students ORDER BY…
-
Session 3: Working with Data – Part 1 Selecting & Retrieving Data SELECT Statements Basic Syntax: SELECT column_name FROM table_name; Example: Selecting student names and IDs from a students table: SELECT student_id, name FROM students; To select all columns, use *: SELECT * FROM students; Using Aliases (AS) Syntax:SELECT column_name…
-
Key Concepts and Demos 1. Introduction to Databases 2. Creating a Database Example: CREATE DATABASE intro_to_data; USE intro_to_data; 3. Creating Tables Example: CREATE TABLE equipment_maintenance ( equipment_id INT, maintenance_cost DECIMAL(10,2), description VARCHAR(255), is_operational BOOLEAN, last_maintenance_date DATE ); 4. Inserting Data Example: INSERT INTO equipment_maintenance VALUES (101, 2500.75, ‘Engine maintenance’, TRUE,…
KaiRaiChu 