Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist.
The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment.
The emphasis in this course is on hands-on and practical learning . As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python.
No prior knowledge of databases, SQL, Python, or programming is required.
Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course.
LIMITED TIME OFFER: Subscription is only $39 USD per month for access to graded materials and a certificate.

DT

This is a great review of an important topic. If I knew how much this mattered for the advanced capstone course I would have paid more attention. As it was, I came back here frequently.

LG

Mar 06, 2019

Filled StarFilled StarFilled StarFilled StarFilled Star

I really liked this course and it is worth it for learning basic SQL queries with Python. I wish we could have more practical exercises but on the whole this was an excellent course.

De la lección

Week 1 - Introduction to Databases and Basic SQL

In Week 1 you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.

Impartido por:

Rav Ahuja

AI and Data Science Program Director

Transcripción

Hello and welcome to SQL for data science. First, we will talk a little bit about what you'll learn in this course. This course teaches you the basics of the SQL language and the relational database model. There will be some lab exercises, and at the end of each section, there are a few review questions. And at the end, there is a final exam. By the end of this course, you will be able to discuss SQL basics and explain various aspects of the relational database model. In this video, we will learn about SQL and relational databases. By the end of this video, you will be able to describe SQL, data, database, a relational database and list five basic SQL commands. But wait, what is sequel and what is a relational database? What is SQL? SQL is a language used for relational databases to query or get data out of a database. SQL is also referred to as SQL. And is short for its original name Structured English Query Language. So SQL is a language used for a database to query data. But what is data and what is a database? Data is a collection of facts in the form of words, numbers or even pictures. Data is one of the most critical assets of any business. It is used and collected practically everywhere. Your bank stores data about you, your name, address, phone number, account number et cetera. Your credit card company and your paypal accounts also store data about you. Data is important, so it needs to be secure and it needs to be stored and accessed quickly. The answer is a database. So, what is a database. Databases are everywhere and used every day but they are largely taken for granted. A database is a repository of data. It is a program that stores data. A database also provides the functionality for adding, modifying and querying that data. There are different kinds of databases of different requirements. The data can be stored in various forms. When data is stored in tabular form, the data is organized in tables like in a spreadsheet, which is columns and rows. That's a relational database. The columns contain properties about the item such as last name, first name, email address, city. A table is a collection of related things like a list of employees or a list of book authors. In a relational database, you can form relationships between tables. So a database is a repository of data. A set of software tools for the data in the database is called a database management system or DBMS for short. The terms database, database server, database system, data server and database management systems are often used interchangeably. For relational databases, it's called a relational database management system or RDBMS. RDBMS is a set of software tools that controls the data such as access, organization and storage. And RDBMS serves as the backbone of applications in many industries including banking, transportation, health and so on. Examples of relational database management systems are, my SQL, Oracle Database, DB2 Warehouse on Cloud and DB2 Express C. For the majority of people using a database, there are five simple commands to create a table, insert data to populate the table, select data from the table, update data in the table, delete data from the table. So those are the building blocks for SQL for data science. You can now describe what is SQL, what is data, what is a database and what is a relational database. You know that RDBMS stands for Relational Database Management System, and you can list five basic SQL commands to create a table, insert data to populate the table, select data from the table, update data in the table, and delete data from the table. Thanks for watching this video.