SQL for Data Analytics

In this intro to SQL course you’ll learn all of the coding you need to start extracting data from a database. No prior programming experience or access to a database required.

Course objectives

SQL is one of the hottest skills, even if you’re not a data scientist. Over 100,000 jobs currently list this as a desired skill in a candidate. SQL allows you to quickly summarize, organize, and pull any piece of information from a database to then be used in your analytics. This course will quickly teach the core SQL language using real life examples.

At completion, you’ll know how to use SQL to extract data from almost any database.

Some key things you’ll learn:

  • Key features of a database
  • What SQL is and how it relates to databases
  • Learn the standard code outline
  • Ways to summarize you data
  • Arithmetic and other functions

 

We recommend taking our Intro to Data Analytics in conjunction with this course.

Additional Info

Format: 3-6 minute videos, quizzes, and a final exam

CPEs: 5.0

Field of study: Computer Software & App

Prerequisites: To get the most out of your analytics, you should have an intermediate knowledge of Excel (e.g. IF statements, VLOOKUP, COUNTIFS, etc.). However, we will not be using Excel in this course. If you are not comfortable with Excel, we recommend taking our Microsoft Excel Bootcamp.