From web applications to e-commerce to scientific research, relational databases are one of the most popular formats for data storage and retrieval. Structured Query Language (SQL) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Professionals working with datasets and databases should have a working knowledge of SQL. This course will introduce you to relational databases and teach you how to use MySQL, one type of RDBMS.
Note: This workshop is not required for students in the Certificate in Data Science program, but it is strongly encouraged for students with little experience or background in programming or database management.
At the completion of this course, you will be able to interact with a remote MySQL database using MySQL Workbench, a free graphical program allowing you to execute create/read/update/delete (CRUD) actions on a database using SQL. The course covers how to:
- Explain key concepts of storing data in relational databases
- Differentiate between popular relational database management systems (RDBMS) such as MySQL and Postgres
- Use the graphical database management program MySQL Workbench to interact with a remote MySQL database
- Read and critique an Entity Relationship Diagram (ERD) to discern a relational data model
- Perform Create/ Read/ Update/ Delete (CRUD) actions using Structured Query Language syntax (SQL)
NotesThis course is an open enrollment course. No application is required and registration is available by clicking "Add to Cart." Current students must register with their Georgetown NetID and password. New students will be prompted to create an account prior to registration.
- Prior experience with data analysis i.e. using Excel
- Proficiency in your operating system of choice
- A laptop with at least a dual core 1.8 GHz processor, 2GB of RAM and 1 GB free hard disk space (e.g. a laptop purchased in the past two years).
- A modern operating system: Windows 10 or newer, OS X 10.13 or newer, or Ubuntu 16.04 or newer, or the equivalent.
- Before class you should download and install MySQL Workbench 8.0 for your operating system (http://dev.mysql.com/