SQL for Kids

Intended Audience

  • A minimum of Grade 7 is required to do this course

What do I need?

  • If Live Online Training : A laptop, and a stable internet connection. The recommended minimum speed is around 10 Mbps.
  • If Classroom Training : If you are not brining your own laptop (recommended), please let us know so we can have one ready for you.

Certification

  • A progress report will be issued for an incomplete year
  • After all classwork is completed, and the assessments passed, a Competency Certificate will be issued

Duration

  • 6 Months (20 one hour lessons, 10 per term, one per week)
  • Crash Course This course can be crashed over a periond of 1-2 weeks full-time

Outcomes

  • Know how Web Pages are created
  • Know how to seperate content and style
  • Use web standards
  • Create great-looking web pagesr
  • Build modern layouts

One

Getting Started with Data

Examining the Basic Structure of Data
  • Determining the fields in a record
  • Introducing SQL data types
  • Specifying the length of a record
  • Defining a primary key
  • Defining the table structure
Introducing MySQL
  • Why use MySQL
  • Understanding the three-tier architecture
  • Practising with MySQL
Setting up phpMyAdmin
  • Changing the root password
  • Adding a user
  • Using phpMyAdmin on a remote server
Implementing a Database with phpMyAdmin

Two

Managing data with MySQL

Writing SQL Code by Hand
  • Understanding SQL syntax rules
  • Examining the buildContact.sql script
  • Dropping a table
  • Creating a table
  • Adding records to the table
  • Viewing the sample data
Running a Script with phpAdmin Using AUTO_INCREMENT for Primary Keys Selecting Data from Your Tables
  • Selecting only a few fields
  • Selecting a subset of records
  • Searching with partial information
  • Searching for the ending value of a field
  • Searching for any text in a field
  • Searching with regular expressions
  • Sorting your responses
Editing Records
  • Updating a record
  • Deleting a record
Exporting Your Data and Structure
  • Exporting SQl Code
  • Creating XML Data

Three

Normalizing Your Data

Recognizing Problems with Single-Table Data
  • The identity crisis
  • The listed powers
  • Repetition and reliability
  • Fields with changeable data
  • Deletion problems
Introducing Entity-Relationship Diagrams
  • Using MySQL workbench to draw ER diagrams
  • Creating a table definition in Workbench
Introducing Normalization
  • First normal form
  • Second normal form
  • Third normal form
Identifying relationships in Your Data

Four

Putting Data Together with Joins

Calculating Virtual Fields
  • Introducing SQL functions
  • Knowing when to calculate virtual friends
Calculating Date Values
  • Using DATEDIF to determine age
  • Adding a calculation to get years
  • Converting the days integer into a table
  • Using YEAR()and MONTH()to get readable values
  • Concatenating to make one filed
Creating a view Using an Inner Join to Comnine Tables
  • Building a Cartesian join and an inner join
  • Enforcing one-to-many relationships
  • Counting the advantages of inner joints
  • Building a view to encapsulate the join
Managing Many-to-Many Joins
  • Understanding link tables
  • Using link tables to make many-to-many joins

Five

Connecting PHP to a MySQL Database

PHP and MySQL: A perfect (but Geeky) Romance
  • Understanding data connections
  • Introducing PDO
  • Building a connection
  • Retrieving data from the database
  • Using HTML tables for output
  • Allowing User Interaction
    • Building an HTML search form
    • Responding to the searach request
Back to top