Tag: sql
-
Session 4: Working with Data Main Topics Covered: AND: Both conditions must be true. OR: At least one condition must be true. NOT: Reverses the condition (true → false, false → true). Used to select specific rows based on conditions. Can use comparison operators (=, !=, >, <, >=, <=).…
-
Session 3: Working with Data – Part 1 Selecting & Retrieving Data SELECT Statements The SELECT statement is used to retrieve data from a database. 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,…
-
Key Concepts and Demos 1. Introduction to Databases Database: A structured collection of data. Database Schema: Blueprint of how data is stored and related. Tables: Store data in rows (records) and columns (attributes). SQL (Structured Query Language): Used to interact with databases. 2. Creating a Database Use CREATE DATABASE database_name;…
