Introduction to Python and SQL

You are here: Executive Education » Open Courses » Data Science

This Page

Introduction to Python and SQL

Delve into the course contents and find out about the faculty members.

Single Course Price:

400.00 EUR (tax exempt)

 

Instructor:

Brian Kim, PhD (University of Maryland)

Video lecture:

Brian Kim, PhD (University of Maryland)

 

Course Dates

To see all courses in the upcoming term click here.

 

Book this course here!

In order to book the course with alumni conditions, please get in touch with Manon Pfeifer directly.

Course Description

Short Course Description
This course introduces students to the basics of Python and SQL for data analysis. Students will explore real publicly-available datasets, using the data analysis tools in Python to create summaries and generate visualizations. Students will learn the basics of database management and organization, as well as learn how to code in SQL and work with PostgreSQL databases. By the end of the class, students should understand how to read in data from CSV files or from the internet and be comfortable using either SQL or Python to aggregate, summarize, describe, and visualize these datasets.

Prerequisites
No prerequisites

Course Objectives
By the end of the course, students will

  • understand the basic structure of how Python and object-oriented programming works
  • be able to write basic Python code, including functions and loops
  • know how to use Pandas and matplotlib packages in Python to analyze data and create visualizations
  • be comfortable reading error messages and Python documentation to diagnose and debug code
  • understand how relational databases work
  • be able to construct a query to answer questions about the data
  • understand how joins work and how to use them

Course Composition
This is a 2 ECTS course, which runs for 4 weeks. The content of the course is broken down into 4 units:

  1. Introduction to Python and Pandas
  2. Functions, Loops and Visualizations
  3. Introduction to SQL
  4. Joins

Learning and Teaching Methods
In this course, you are responsible for watching video-recorded lectures and reading the required literature for each unit prior to participating in mandatory weekly one-hour online meetings where students have the chance to discuss the materials from a unit with the instructor. In addition, students must post questions or comments about the materials covered in the videos and workbooks of the week to the instructor in the forum before the meetings.

Grading
Grading will be based on:

  • 4 online quizzes (worth 20% total)
  • Participation in discussion during the weekly online meetings and posting questions in the forum demonstrating understanding of required readings and video lectures (worth 20%)
  • 4 homework assignments (worth 60% total)

ZFU Certification and Online Dispute Resolution

ZFU Certification

The Mannheim Master of Applied Data Science & Measurement program is certified according to the regulations of the ZFU (Staatliche Zentralstelle für Fernunterricht).

 

Online Dispute Resolution

Online dispute resolution according to Art. 14 Sect. 1 ODR-VO: The European Commission provides a platform for online dispute resolution (ODR). You can find more information under http://ec.europa.eu/consumers/odr/

MANNHEIM BUSINESS SCHOOL (MBS)

Located in the heart of the German and European economy, Mannheim Business School (MBS), the umbrella organization for management education at the University of Mannheim, is considered to be one of the leading institutions of its kind in Germany and is continuously ranked as Germany’s #1.

SOCIAL MEDIA NEWS WALL