Course curriculum

  • 1

    Overview

  • 2

    Getting Started

  • 3

    Chapter 1: Problem Specification

    • 1.1 Overview

    • 1.2 Introducing SQL

    • 1.3 Main Purposes of SQL

    • 1.4 Understanding the Fundamentals of Databases

    • 1.5 Database Schema

    • 1.6 Basic Concepts

    • 1.7 Example: Using SQL Queries

    • 1.8 Summary
  • 4

    Chapter 2: Database Querying

    • 2.1 Overview

    • 2.2 Introducing Different Operators

    • 2.3 Aggregating Clauses

    • 2.4 JOINS and UNION

    • 2.5 Summary
  • 5

    Chapter 3: Database Management

    • 3.1 Overview

    • 3.2 UPDATE a TABLE

    • 3.3 INSERT and DELETE

    • 3.4 Transactions

    • 3.5 Summary

  • 6

    Chapter 4: Creating Databases

    • 4.1 Overview

    • 4.2 Creating Tables

    • 4.3 Example: Building our own Database

    • 4.4 Summary
  • 7

    Chapter 5: Advanced SQL Functionality

    • 5.1 Overview

    • 5.2 User Defined Functions

    • 5.3 User Defined Stored Procedures

    • 5.4 Functions and Procedures: Similarities and Differences

    • 5.5 Summary

  • 8

    Chapter 6: Ethics and Governance

    • 6.1 Overview

    • 6.2 Legal, Regulatory, Professional and Ethical Considerations

    • 6.3 Conduct and Governance

    • 6.4 Summary
  • 9

    Appendix and Further Resources

    • Additional: Using SQLalchemy and IPythonSQL

    • CSV Datasets for Chapter 5

    • References

    • Additional Resources

  • 10

    Downloadable notebooks

    • Downloadable notebooks and data (zipped)