Data Programming

Master the skills you need to tap into databases, play with data and make smarter decisions. You'll learn to specialize in SQL, the international standard language for databases and build interactive programs and automate your tasks using Python.

What you'll learn

Database structures

Before you learn more about SQL we?ll help you understand how data is stored in a database.

SQL queries

Select, sort and identify data from a database using SQL queries.

Where command and logical conditions

Use where command and logical conditions to filter data.

Aggregation functions

Group data with aggregation functions.

Tables

Create tables by adding, updating and removing data.

Foundational concepts

Master foundational concepts of coding with Python. These are the building blocks for everything else

Strings

Understand how to work with strings to store text data and handle special characters

User inputs

Make your programs interactive by taking and working with user inputs

Variables

Use variables to help your program store data

"If" and "Else" statements

Start shaping the flow and purpose of your program with "if" and "else" conditional statements

Lists

Create and operate with lists to store multiple items into a single variable. This means you can handle more types of data

Functions

Keep your code efficient and manageable using built-in functions and your own custom functions

Getting Started with SQL

Going Deeper with SQL

Query Techniques

Data Analysis

Getting started with Python

Going Deeper with Python

Working with Data

Control Flow

Working with Lists

Functions

Your Certificate is close

You are doing great! Keep learning to unlock your certificate!

Blog

What Is SQL Used For?

SQL is the commonly used acronym for Structured Query Language, the standard language for relational database management systems. SQL traces its origins all the way back to 1973, when it was initially created by a team at IBM to manipulate and retrieve the data stored in their system at the time.

Continue reading on our blog

10 Reasons To Learn Python Right Now

From a beginner language just a few years ago to one of the most popular and versatile languages in the world today, Python is everywhere. Long...

Continue reading on our blog

CHEAT SHEET: What Is A SQL Injection?

One of the most common web hacking techniques, an SQL injection is a method for attacking and manipulating underlying databases. From providing access to protected data, to gaining access to manipulate the database of the targeted application, this tool is a common threat for most website and application managers. Our guide walks you through this widespread threat so you can protect your own applications from it.

Continue reading on our blog