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

LEARN TO CODE IN PYTHON – SCHOOL HOLIDAY PROGRAMME

This course is a great introduction to get started learning programming concepts using the Python programming language. Python is a general-purpose, versatile and popular programming language. It is a great language for website development and developing scientific applications.

READ MORE

CONTACT US





Your Contact Number (required)

 

Input this code in the field below: captcha

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 & Stonefields 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


STONEFIELDS CENTRE

1st Floor, 38 Lunn Avenue,

Stonefields, Auckland

09 815 0825

Send Email