Through this course you will learn:

• Installation steps for installing a text editor, installing MAMP or XAMPP  and creating a MySql Database.
• Single table queries, syntax of the SQL language and database design with multiple tables, foreign keys, and the JOIN operations.
• Model many-to-many relationships like those needed to represent users, roles, and courses.

Basic Exerts of the Course:

• Use SQL to query a database
• Use SQL to perform data analysis
• Be comfortable putting SQL and PostgreSQL on their resume
• Learn to perform GROUP BY statements
• Replicate real-world situations and query reports