Structured Query Language (SQL) and Relational Databases

Next Start Date: 16 October, 2018
for (comlete) beginners
Image Description

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.

Learning process

  • 👩‍🏫 Live classes. Live online classes every Tuesday and Thursday, from 19:00 to 21:00
  • 📝 Homework. Yes homework. I am not sorry. Your homework is reviewed and checked by your course mates and me personally
  • 💬 Communicate with your group. Communicate with your course mates in a group chat and help each other grow
  • 🙋 Ask questions any time. Ask me anything anytime over a private chat
  • 📄 Focus on what matters. Receive short and relevant materials for each topic, which highlight key aspects important for interviews and your further progress

Course content and structure

Class Topic You will
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. Indexes. 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 Revision Fill in all the gaps in your knowledge
8 Applying acquired knowledge Analyze and present on data from the sample database mimicing a real-world business