Center for Continuing and Professional Education

XBUS-493 SQL Fundamentals

XBUS-493 SQL Fundamentals

 Email this information to yourself or a friend
 Remind me of this course at a later date



Course Details

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 7 or newer, OS X 10.6 or newer, or Ubuntu 12.04 or newer, or the equivalent.
  3. Before class you should download and install MySQL Workbench 6.3.5 for your operating system (http://dev.mysql.com/downloads/workbench/)



Sections

XBUS-493 - 01 SQL Fundamentals    
2017 - Fall 2017 Non-Credit   Status:  Available
Class:   Sat 9:00AM - 4:00PM
29 Jul 2017 to 05 Aug 2017
Number of Sessions: 2 Sessions
Contact Hours: 12.0
Course Tuition:
Tuition non-credit    295.00
Potential Discount(s):
AMADC Members
Alumni Discount
Boeing Discount
EdAssist
Fed. Government Employee Discount
 
Location:   Main Campus
Building:   640 Mass Ave
Instructors: Laura Lorenz
Section Notes:  Class will meet on the following dates: July  29 & August 5, 2017.  
 


Connect with us

Executive Certificate in Leadership Coaching - Webinar

July 11, 2017 12:00 PM - 1:00 PM Details

Professional Certificate Programs News and Highlights