The workshop covers SQL and MongoDB, two very popular database systems. We also touch on a relativley new type of graph database.
If you haven't worked with SQL before, check out the beginner SQL section. This section covers SQL syntax and how to create queries using select statements. Select statements are arguably the most important aspect of SQL. Select statements make use of logical operators, grouping, and ordering to filter out data and obtain the intended information from a database table.
For those who may already feel comfortable with the basics of SQL and select statements, we invite you to check out the intermediate SQL section. This section will cover more advanced select statements that use joins. Joins are very useful for retreiving data from multiple database tables and combining or computing new values using the information gathered.
Lastly, if you are already experienced in SQL and data retrieval, check out the advanced SQL section. This section covers database table creation and management, as well as a glimpse into stored procedures. In order to perform the queries in the beginner and intermediate sections, it is important to understand how the databases themselves are maintained and updated!
MySQL with Python, How to interact with a personal SQL database with Python's MySQL wrapper!
NoSQL and MongoDB, An introduction to NoSQL (non-SQL database systems) and MongoDB, a NoSQL platform!
To learn about Graph Databases, check out the Graph Databases Section.