![sqlitestudio cnet sqlitestudio cnet](https://upload-images.jianshu.io/upload_images/2596054-4ccb59db5230ced8.png)
7 Meta Data How to find out what tables and columns exist. 6 Users How to create users, GRANT and DENY access, get at other peoples tables. 5 Functions How to use string functions, logical functions and mathematical functions. 4 DATE and TIME How to work with dates adding, subtracting and formatting.
![sqlitestudio cnet sqlitestudio cnet](https://dotblogsfile.blob.core.windows.net/user/yc421206/1404/4b45d5a01511_7CCE/image_thumb_2.png)
3 INSERT and DELETE How to put records into a table, change them and how to take them out again. 2 CREATE and DROP How to create tables, indexes, views and other things. 1 SELECT How to read the data from a database. 10 Tutorial Quizzes Test your knowledge with multiple choice quizzes 11 Tutorial Student Records Creating a database 12 Tutorial DDL Instructions on how to import data and analyse it in mysql 9+ COVID 19 In which we measure the impact of COVID-19 9 Self join In which we join Edinburgh bus routes to Edinburgh bus routes. 9- Window function In which we examine UK general election results. previously Scottish Parliament 8+ Numeric Examples In which we look at a survey and deal with some more complex calculations. 8 Using Null In which we look at teachers in departments. previously music tutorial 7 More JOIN operations In which we join actors to movies in the Movie Database. more the same 6 JOIN In which we join two tables game and goals. 5 SUM and COUNT In which we apply aggregate functions. 4 SELECT within SELECT In which we form queries using other queries. 3 SELECT from Nobel Additional practice of the basic features using a table of Nobel Prize winners. 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.