- Basic Computer Skills, Your laptop
- 8 weeeks | 2 x 1.5hr classes per week
By the end of this course you will be able to:
- navigate and make sense of data in any industry-standard SQL database
- write effective SQL queries to retrieve information for business decision making from databases
- manipulate your data to modify and summarise your results for reporting
Data makes the today's world go round. Databases make data storage, retrieval, usage, and analysis possible. Thus, learning how to deal with the relational databases, which have been the leader in the field since the inception of computerized data storage idea makes all the sense.
After this course, your relational databases understanding and querying skills will be above average. Roughly speaking. Maybe after the course, you will fall in love with the idea of dealing with data and will proceed to move in this direction. Maybe you won't and it would be another valuable addition to your skillset.
|1||Why databases? Relational databases basics. Entity Relationship Diagrams.||Create and Populate a Database using SQL.|
|2||Query Primer. SQL query blocks.||Make sense of a query structure. Execute your first SQL queries.|
|3||Filtering Data||Retrieve and filter the data you need.|
|4||Querying Multiple Tables||Write and execute SQL queries that retrieve data from multiple tables.|
|5||Grouping and ordering records||Learn to write aggregation functions to produce some sort of total from a number of records|
|6||Analytical Functions||Learn to write analytical functions to perform operations across a set of table rows that are somehow related to the current row|
|7||Designing a Database||Design your own database. Yay!|
|8||Applying acquired knowledge to your database||Analyze and present on data from the database you built.|