YoVDO

Data Management with Python and SQL

Offered By: Southern New Hampshire University via edX

Tags

Databases Courses Python Courses SQL Courses

Course Description

Overview

Data management is a growing field that explores the many ways of using data within an organization to improve decision-making. Expertise in data management allows organizations to assess the data they have and the data they need to understand the health and future of a business. Individuals with experience in data management can better plan for the future by leveraging data organization, data management and automation tools.

This program can help learners build the foundational skills they need to succeed in data management using the Python programming language and SQL (structured query language). Through hands-on labs, learners will develop the skills necessary to create structured database environments using a relational database management system (RDBMS), such as MySQL, that incorporates basic processing functionality and allows for data management, data manipulation and data analysis.

This content is designed for individuals interested in using data to solve problems, regardless of prior experience. Whether you’ve worked with data in your current role or are interested in the ever-expanding field of data management, this program can help you build the skills you need to succeed.

Below you’ll find the recommended order for taking the courses in this program. Unless you have a background in these areas already and feel comfortable skipping ahead we recommend you start with the first course and work your way through the program.

  1. IT-140x - Starting February 2021
  2. DAD-220x - Starting February 2021


Syllabus

Courses under this program:
Course 1: Scripting with Python

Explore fundamental programming with hands-on activities that help you build applications using Python.



Course 2: Structured Database Environments with SQL

Discover Structured Query Language (SQL) programming basics in relation to database management and data manipulation. This course can provide you with an overview of topics like joins, database schemas, database design and importing data into a database.




Courses

  • 0 reviews

    16 weeks, 8-10 hours a week, 8-10 hours a week

    View details

    The Python programming language is extremely powerful and commonly used to automate time-intensive activities/tasks for users. This makes Python a good skill to have for any job that requires automation to replace data in a file, rename multiple file names, update Excel spreadsheets or mine data from web pages. Python can be used as a steppingstone to enter some of the most exciting industries including data science, artificial intelligence, machine learning, software or full-stack development.

    Learning the fundamentals of programming concepts with Python includes data types, variables, decision statements, loops, functions and file handling. By developing simple scripts, you can understand how to use common scripting language constructs including lists, literals and regular expressions to build useful applications.

    After taking this class, you will be able to:

    Write Python scripts with confidence using best practices and coding standards:

    • Evaluate control constructs for program flow

    • Write simple scripts

    • Format scripts following code standards best practices

    Solve problems before developing code by designing programs with pseudocode or flowcharts:

    • Write pseudocode to support code design

    • Draw a flowchart using design tools to support code design

    • Develop user interface for input and output

    • Develop script syntax based on a problem statement

    Develop fully functional programs using a Python interpreter:

    • Determine the difference between an interpreter and a compiler

    • Run script syntax with an interpreter

    • Write script syntax with an interpreter

    • Develop scripts in an integrated development environment (IDE)

    • Fix script errors

    • Validate user inputs in program development

    This is the first course in the introductory, undergraduate-level offering that makes up the larger Business Analytics Foundations and Data Management with Python and SQL MicroBachelors programs. We recommend taking them in order, unless you have a background in these areas already and feel comfortable skipping ahead.

    1. Scripting with Python - starting February 2021

    2. Structured Database Environments with SQL OR Applied Statistics with Python - starting February 2021

    NOTE : While this is generally a non-credit-bearing course, you may able to use this class with proper completion for 3 credits (1 course) toward a bachelor's degree at Southern New Hampshire University.


Taught by

Gwen Britton, Curtis George, Scott Overmyer and Ben Tasker

Tags

Related Courses

Artificial Intelligence for Robotics
Stanford University via Udacity Intro to Computer Science
University of Virginia via Udacity Design of Computer Programs
Stanford University via Udacity Web Development
Udacity Programming Languages
University of Virginia via Udacity