KwickAcademy Databases and SQL · free
Databases and SQL: free video lessons
18 lessons on Databases and SQL, about 114 minutes in total. Each one has the video, the tables from the board, the quick answers and the full text.
Aggregate Functions: COUNT, SUM, AVG, MAX and MIN
Database Tool Basics: Creating a Database, Tables, Fields and Records in Base
Forms and Reports in Base
GROUP BY and HAVING
Introduction to SQL and MySQL: DDL, DML and DQL
Keys in a Database: Primary, Candidate, Alternate and Foreign Key
Queries in Base: Design View, Criteria and Sorting
Relationships Between Tables in Base
SQL Data Definition: CREATE DATABASE, CREATE TABLE, ALTER and DROP
SQL Data Manipulation: INSERT, UPDATE and DELETE
SQL Operators: BETWEEN, IN, LIKE and IS NULL
SQL SELECT: Choosing Rows and Columns with WHERE
SQL Single Row Functions: Math, Text and Date
SQL for Cambridge IGCSE: Single-table Databases and Queries
Sorting Results with ORDER BY
The Relational Model: Relation, Tuple, Attribute, Domain, Degree and Cardinality
Why Databases: Data, Information and the DBMS
Working with Two Tables: Cartesian Product, Equi-join and Natural Join
Courses that use these lessons
- CBSE Class 9 Computer Applications (165)
- CBSE Class 9 Information Technology (402)
- CBSE Class 10 Information Technology (402)
- CBSE Class 12 Computer Science (083)
- CBSE Class 11 Informatics Practices (065)
- CBSE Class 12 Informatics Practices (065)
- CBSE Class 11 Information Technology (802)
- CBSE Class 12 Information Technology (802)
- ICSE Class 10 Computer Applications
- GSEB Std 11 Computer Studies
- GSEB Std 12 Computer Studies
- Cambridge IGCSE Grade 9 Computer Science (0478)
- Cambridge IGCSE Grade 10 Computer Science (0478)
- NIOS Senior Secondary Computer Science (330)
Disclaimer. KwickAcademy is free study material for general learning and revision. Parts of it, including the voice-over, are produced with the help of AI tools and may contain errors; if you spot one, please tell us and we will correct it. Syllabus, marks and exam details follow the latest official board publications available to us, and boards can change them at any time, so always confirm against your board's official website and your school. Using this material does not guarantee any marks or result. Board names and trademarks belong to their owners; Kwickprep is not affiliated with or endorsed by any examination board. We never ask for passwords, OTPs or ID numbers. Your progress is saved only in this browser. Full disclaimer · Privacy