Learn the fundamentals of SQL, and how to apply your SQL knowledge
Our Intro To Programming level is required for entry into this course
Who will benefit
School leavers intending to do one of our Coding Bootcamps.
Professionals who are already familiar with another programming language
This course is also the first module in all our our Coding Bootcamps
Attendance : If you have attended 80% of the sessions and completed all the class work, you qualify for the Attendance Certificate.
Competency : If you have also completed all the practical projects as described the Outcomes section, you qualify for the Competency Certificate.
What you will learn
Build an HTML Web Site showing off your portfolio of projects and host it online.
What do I need?
Live Online Training : A laptop, and a stable internet connection. The recommended minimum speed is around 10 Mbps.
Classroom Training : A laptop, please notify us if you are not brining your own laptop. Please see the calendar below for the schedule
Advanced SELECT –
Seeing your data with new eyes
ORDER BY SUM, MIN, MAX, AVG, GROUP BY COUNT,
LIMIT Multi-table Database Design –
Outgrowing your table Schema
How to go from one table to two
Create a table with a Foreign Key
Relationships between tables
Patterns of data Junction table
1NF Partial functional dependency
Transitive functional dependency 2NF 3NF
CREATE, SELECT, INSERT at the same time AS, column aliases