0. Introduction - Data Extraction Using SQL

Loading...

Do curso por University of Colorado Boulder

Introduction to Data Analytics for Business

341 classificações

University of Colorado Boulder

Introduction to Data Analytics for Business

341 classificações

Curso 1 de 5 em Specialization Advanced Business Analytics

This course will expose you to the data analytics practices executed in the business world. We will explore such key areas as the analytical process, how data is created, stored, accessed, and how the organization works with data and creates the environment in which analytics can flourish. What you learn in this course will give you a strong foundation in all the areas that support analytics and will help you to better position yourself for success within your organization. You’ll develop skills and a perspective that will make you more productive faster and allow you to become a valuable asset to your organization. This course also provides a basis for going deeper into advanced investigative and computational methods, which you have an opportunity to explore in future courses of the Data Analytics for Business specialization.

Na lição

Data Extraction Using SQL

In this module we’ll learn how to extract data from a relational database using Structured Query Language, or SQL. We’ll cover all the basic SQL commands and learn how to combine and stack data from different tables. We’ll also learn how to expand the power of our queries using operators and handle additional complexity using subqueries.

0. Introduction - Data Extraction Using SQL2:03

Conheça os instrutores

David Torgerson
Instructor

Welcome to Module 3.

In this module we'll focus on data extraction from relational databases using

structured query language or SQL.

Up till now, we've been focused mostly on thinking about analytical problems and

understanding where data comes from and how we capture and store it.

Now we take our first step in actually working with and

manipulating the data we need in order to execute an analysis.

As an analyst the ability to extract data from a database yourself, is one of those

skills that can really enhance the value you bring to an organization.

It makes you more efficient and more effective, since you gain a much

deeper level of understanding of the database itself and the data it contains.

There are two thing about SQL that make it really great to learn in specialization

like this one.

First, it's incredibly simple.

By the time we finished this module, you'll learn the basic commands and

operations that drive 80% to 90% of the SQL coding we see in data analytics.

Secondly, SQL is almost ubiquitous.

While there are many other languages that companies use either directly or

indirectly to support analytics, SQL is easily the most common.

And there's a really good chance you'll find it in just about any organization

working with databases.

And even if you don't end up using SQL,

you can benefit from learning the thought process that goes into writing it.

It's the same thought process you'll need to go through regardless of how you get

data out of your databases.

By the end of this module you should be able to construct simple to

moderate SQL queries using a set of basic commands.

Namely select, from, where, group by, having, and order by.

Combine or stack data from multiple tables using join and union commands.

Enhance queries using relational, arithmetic, and logical operations, and

build even more complex queries by utilizing sub queries.

This will be your first chance to get your hands dirty with some actual data work.

So I hope you're as excited as I am.

And I hope you'll love writing SQL as much as I do.

Explore nosso catálogo

Registre-se gratuitamente e obtenha recomendações, atualizações e ofertas personalizadas.

O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.

© 2018 Coursera Inc. Todos os direitos reservados.

Baixar na App Store

Baixar no Google Play