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 – SCHOOL HOLIDAY 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

FOLLOW US ON TWITTER

HOURS & INFO

09-8150825
Mon-Thu: 3pm - 7:30 pm
Sat/Sun: 10am - 4pm
09-8150825
Mon-Thu: 3pm - 7:30 pm
Sat/Sun: 10am - 3pm
09-8150825
Mon-Thu: 3pm - 7:30 pm
Sat/Sun: 10am - 3pm