Loading...

Course Description

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.

Course Objectives

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)

Notes

This 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.

Course Prerequisites

Experience Prerequisites:

  • Prior experience with data analysis i.e. using Excel
  • Proficiency in your operating system of choice

Hardware Prerequisites:

  1. 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).
  2. A modern operating system: Windows 10 or newer, OS X 10.13 or newer, or Ubuntu 16.04 or newer, or the equivalent.
  3. Before class you should download and install MySQL Workbench 8.0 for your operating system (http://dev.mysql.com/downloads/workbench/)
Loading...

Enroll Now - Select a section to enroll in

Type
Class
Days
Sa
Time
9:00AM to 4:00PM
Dates
Mar 20, 2021 to Mar 27, 2021
Schedule and Location
Contact Hours
12.0
Course Tuition
Tuition non-credit $495.00
Section Notes

Welcome to the Flex Learning Experience - Real-time learning using live Zoom video conferencing— mirroring a more traditional classroom with regular interaction, - engaging activities, and the dynamic exploration of topics and concepts.

  • Dynamic exploration of topics, ideas and concepts with the instructor and students in the class
  • Interact regularly and frequently with your instructors and other students
  • Comparable level of accountability and engagement as classroom attendance
  • Lectures, discussions, and presentations occur at a specific hour
  • Face-to-face discussion, individual guidance, speed and immediacy to synchronous online learning
  • Immediate feedback - encouraging quick feedback on ideas, and support consensus and decision making
  • Pacing - encouraging students to keep up-to-date and provide a discipline to learning
  • Spontaneity - making it easy to add new ideas to the conversation, brainstorming or decision making
  • Familiarity - simulating a more traditional face-to-face environment

 

Computing Requirements

Students will be expected to use a personal laptop to complete analytics and programming workshops and a Capstone project. Students should have administrative access and be able to install required course software and libraries. We recommend the following minimum computing requirements:

  • A laptop with at least a dual-core 1.8 GHz processor, 4GB of RAM, and 20 GB free hard disk space (e.g. a laptop purchased in the past two years).
  • A modern operating system: Windows 10 or newer (updated to the latest semi-annual channel version), OS X 10.15 Catalina or newer, or Ubuntu 20.04 or newer (or an equivalent Linux distribution). OS X and Linux are strongly encouraged.
  • Administrator access on your system to install new software.
  • Python 3.8 (or later) or Anaconda 2020.07 (or later) installed on your system.
  • A command prompt available (Powershell on Windows, Terminal on OS X or Linux).

Please note that computing requirements and software dependencies may change. 

Required fields are indicated by .