Learning SQL - Lessons Main Page
Latest Update - 30th May 2011
- Let's start at the very beginning Just a few definitions you might need to know before you start big school!
- What is a Relational Database? If you're not sure the you must read this bit.
- The Basics Creating tables, adding, deleting and changing data.
- Select - Finding your data How to Select data from your database
- Select - Comparing Values Equals, Likes, Ands and Ors
- Joining The Dots The relational bit of Relational Databases - this is where it get's really interesting!
- Amazing Views You can look at it like this... or like this.
- Terrific Trigers Trigger? That's a horse innit?
- Data Types Basically you've got numbers, text and binary - what else is there?
- Keys Part 1 - Primary Keys The Key To Success- Primary Keys!
- Keys Part 2 - Foreign Keys The Relational Database glue
- Outer Joins No join in Table 2,but I want to see ALL the data!
- Constraints Be a Control Freak with your database
- Resolving Many To Many A quick overview on the massive importance of M2M relationships and how to resolve them
- Maintaining Referential Integrity No Orphans! Cascade Deleting and other interesting stuff
- Changing Table Definitions - Part One How can we add a column to an existing table?
- Triggers As Constraints Triggers for real men (and women!)
- Changing Table Definitions - Part Two It get ever more complicated!
- Changing Table Definitions - Part Three The saga continues
- Changing Table Definitions - Part Four - Summary A summary of all that nasty stuff
- Nulls, Nothings and Zeroes What is a Null ? Absolutely nothing!
- Self Referencing Tables Self Referencing Tables, Multi Level Domain Lookup - wow!
- Tips & Tricks What it says! How to avoid some of the common problems and put your SQL one step ahead of the competition.