SQL Learning Course Outline and Book Giveaway Announcement

The Aikexing Open Source Community is holding a book giveaway, thanking Tsinghua University Press for sponsoring the books and inviting followers to participate.

Participants can win three books by following the community’s public account and scanning the activity QR code before October 28, 2023.

SQL Course Outline

Chapter 1: Writing Your First SQL Program

1.1 SQLite Database – installation and command‑line access

1.2 Hello World program

1.3 Overview of relational database management systems (Oracle, SQL Server, DB2, MySQL)

1.4 SQL Overview – standards and syntax

1.5 Hands‑on practice

Chapter 2: MySQL Database

2.1 MySQL Overview – features and versions

2.2 Installation and configuration on Windows, Linux, macOS

2.3 Graphical client tools – download, install, configure, and manage databases, tables, and SQL statements

2.4 Hands‑on practice

Chapter 3: MySQL Table Management

3.1 Core concepts of the relational model – records, fields, keys, constraints

3.2 Database operations – create, delete, select

3.3 Table creation and data types (strings, numbers, dates, large objects)

3.4 Key specifications – candidate, primary, foreign keys

3.5 Other constraints – defaults, NOT NULL, CHECK

3.6 Table modification – rename, add/delete columns, delete tables

3.7 Hands‑on practice

Chapter 4: View Management

4.1 View concepts, creation, modification, deletion, and exercises

Chapter 5: Index Management

5.1 Creating composite and unique indexes, deleting indexes, best practices, and exercises

Chapter 6: Modifying Data

6.1 INSERT, 6.2 UPDATE, 6.3 DELETE statements

6.4 Transactions – concepts, properties, states, control, and exercises

Chapter 7: Querying Data

7.1 SELECT statement – fields, ordering, aliases, expressions, arithmetic operators

7.2 ORDER BY, 7.3 WHERE clause with comparison, logical, IN, BETWEEN, LIKE operators and precedence

7.4 Hands‑on practice

Chapter 8: Aggregate Queries

8.1 Aggregate functions (COUNT, SUM, AVG, MIN, MAX)

8.2 Grouping – GROUP BY, HAVING, DISTINCT

8.3 Hands‑on practice

Chapter 9: Subqueries

9.1 Concepts and examples (single‑row, multi‑row, nested subqueries, DML usage)

9.2 Hands‑on practice

Chapter 10: Table Joins

10.1 Join concepts, inner, left, right, full, and cross joins with syntax and examples

10.2 Hands‑on practice

Chapter 11: MySQL‑Specific Statements

Auto‑increment fields, date types, row‑limit clauses, common functions (numeric, string, date/time) and exercises

Chapter 12: MySQL Database Development

Stored procedures – creation, invocation, deletion, parameters (IN, OUT, INOUT), stored functions, and exercises

Appendix A provides reference answers for the hands‑on exercises.