INTERMEDIATE SQL

6 WEEKS / AGE 14+

INTERMEDIATE SQL

Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language. Learn how to use SQL to manipulate data. Learn how to store related data in multiple tables and use joins to bring them together. You will learn more advanced skills to use SQL in the real world.

INCLUDED IN THE COURSE

Week 1: SPLITTING DATA INTO RELATED TABLES. JOINING TABLES
Week 2: DIFFERENT TYPES OF JOINS
Week 3: LET’S PUT OUR LEARNING TO TEST AND CREATE A PROJECT
Week 4: USING SQL TO UPDATE DATABASE. UPDATE/DELETE
Week 5: ALTERING TABLES AFTER CREATION. USING TRANSACTIONS
Week 6: PROJECT

SCHEDULE

CODE THAT BOT – PROGRAM A ROBOT USING EDISON – REGULAR PROGRAMME

Code to control the Edison robot and use features like obstacle-avoidance, line-following, and remote control commands.

READ MORE

CONTACT US





Your Contact Number (required)

 

ABOUT SCRATCHPAD

Scratchpad is both an approach to learning and a centre for creativity. We run our programs from our learning centres in St Lukes, Botany, Albany & Northcote, Auckland, as well as offering additional support online.

         

Terms & Conditions

CONNECT WITH US ON FB

OUR CENTRES

ST LUKES CENTRE

12/1 Wagener Place

Mt Albert, Auckland

09 815 0825

Send Email


BOTANY CENTRE

23/2 Bishop Dunn Place

Flatbush, Auckland

09 815 0825

Send Email


ALBANY CENTRE

28A William Pickering Drive

Albany, Auckland

09 815 0825

Send Email


NORTHCOTE CENTRE

46 Lake Road,

Northcote, Auckland

09 815 0825

Send Email