Learning SQL Programming
Currently, I am enrolled in MIS 2502 Data and Analytics. Our first exam was approaching and this Linkin Learning Course was recommended before taking the exam. It teaches how to retrieve data from Relational Databases from MySQL. We first learned what a database is, which is a collection of information. Individual kinds of information are organized in columns, or fields, and each set of information is organized into rows, or records. Together, columns and records create a table, which is where the data is stored.
Schemas of the database regulate and create connections within the database. This is done through statements. The main learning objective was to get comfortable with the programming of MySQL, specifically using statements. Statements are made up of SELECT, FROM, WHERE, GROUP BY, ORDER BY, etc. These statements are tools to organize and find data. The course was divided into an introduction, 4 chapters, and a conclusion. It was extremely helpful and was definitely worth watching.