AIM OF COURSE
We focus on the beginner and foster a comfortable atmosphere where you can learn at your own pace. We facilitate learning from the understanding of what is means to be a beginner, I remember being one so well.
In this weekly workshop there is no presenter, just you, your coach and our laptops.
Join our Meetup Group and RSVP for our next event. We provide you with learning materials. When you need help or support just call a coach over and we will be there to support you with a smile.
Come and leave when you want, all genders, backgrounds and interest levels are welcome.
WHAT YOU'LL LEARN
After the completion of this course, you will be able to use an SQL client to obtain data stored in a database.
You will learn how to write basic queries which give you exactly the information you require and to bring them into the form most suitable to answer the given questions.
How a basic SQL query is constructed
Filter and fine tune query results using the WHERE clause and operators
Results from more than one table
Get results from multiple tables
Primary and Foreign Key Constraints
How information is different tables are connected
Sorting Query Results
How to order data
How to deal with corrupt data
Calculating the value of multiple rows of data
Empty records and Nulls
How to work with missing data
An introduction to Joins
Combining data from multiple tables explicitly