KwickAcademy Databases and SQL · free
Databases and SQL: free video lessons
18 lessons on Databases and SQL, about 114 minutes in total, taught by Kajal Ma'am. 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)