SQL Tutorial

---

Tutorials: Learn SQL in stages

---

0. Select Basics
   Some simple queries to get you started
1. SELECT name
   Some pattern matching queries
2. SELECT from World
   In which we query the World country profile table.
3. SELECT from Nobel
   Additional practice of the basic features using a table of Nobel Prize winners.
4. SELECT within SELECT
   In which we form queries using other queries.
5. SUM and COUNT
   In which we apply aggregate functions. more the same
6. JOIN
   In which we combine data from multiple tables
7. More JOIN operations
   In which we combine data from multiple tables
8. Using Null
   In which we look at teachers in departments.
8. • Numeric Examples
     In which we look at a survey and deal with some more complex calculations.
9. • Window Function
     In which we examine UK general election results.
   • COVID 19
     In which we measure the impact of COVID 19
   Self join
   In which we join Edinburgh bus routes to Edinburgh bus routes
10. Tutorial Quizzes
    Test your knowledge with multiple choice quizzes
11. Tutorial Student Records
    Create a student record database
12. Tutorial DDL
    Instructions on how to import data and analyse it in mysql