Author Archives: Chris K

You can imagine a TABLE in SQL as an Excel spreadsheet. It contains rows and columns with data in their fields. Let us create a table for pupils. The table should contain information about the pupils unique Id, the Name and the Date of Birth. The query for such a table will look like this: […]

What will you learn? Understand the creation and modification of tables, how to handle data, do calculations and gain query speed. Content Chapter 1 – Straight Into Action Create Table Insert Into Select *, Where, Group By, Age, AvgAge Alter Table (Gender, Size, Notes) Update, Delete Create Index Create Table Class, Join Chapter 2 – […]