Intro to Databases and SQL

This was a nice refresher on databases. I had taken a course in college a few years ago but do not use SQL regularly so this was good practice to brush up on the skills.

We learned about the different kinds of databases which are relational and non-relational. Most databases are relational such as Oracle, Microsoft SQL Server and MySQL which stores data in columns and rows. Any other type of storage is considered non-relational such as Mongo. Here is a great website that ranks the most popular databases: https://db-engines.com/en/ranking.

We used a free website to practice running commands with keywords. A few commonly used keywords are SELECT, FROM, WHERE, AND, INNER JOIN and LIKE. There are many others. You can practice here if you are interested: https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in  There are small diagrams on the W3 schools JOIN pages that better explain these concepts which many in the group found useful. Overall this was a very good presentation. Actualize is offering free courses each Wednesday on a variety of topics related to coding.