2.6 Summary

In this chapter, we went over many materials. We began by defining SQL. You should know now that SQL stands for Structured Query Language which is a standard language to communicate with relational database management systems (RDMS). You should also know the difference between a transactional and a relational database. We also introduced important concept of primary key, foreign key, and table relationship. Make sure you are familiar with these concepts because we’re going to revisit them a lot in more detail later when we start talking about Joints. We also discussed some basic SQL Syntax. And you should now be able to write basic queries statements using SELECT and FROM. Finally, we wrapped up by going over how to write comments in your code which are essential to include so that both you and your colleagues can follow what you were doing and reuse your code. It’s a really good habit to get into as you’re starting out. So be sure to keep practicing that aspect as you begin to write your first query statement.

Here are some resources for further learning: