Databases and SQL for Knowledge Science with Python

About this Course

A lot of the world’s information resides in databases. SQL (or Structured Question Language) is a robust language which is used for speaking with and extracting information from databases. A working information of databases and SQL is a should if you wish to turn into a knowledge scientist.

The aim of this course is to introduce relational database ideas and aid you study and apply foundational information of the SQL language. It’s also meant to get you began with performing SQL entry in a knowledge science surroundings. The emphasis on this course is on hands-on and sensible studying . As such, you’ll work with actual databases, actual information science instruments, and real-world datasets. You’ll create a database occasion within the cloud. By means of a collection of hands-on labs you’ll follow constructing and operating SQL queries. Additionally, you will learn to entry databases from Jupyter notebooks utilizing SQL and Python. No prior information of databases, SQL, Python, or programming is required. Anybody can audit this course at no-charge. In case you select to take this course and earn the Coursera course certificates, it’s also possible to earn an IBM digital badge upon profitable completion of the course. LIMITED TIME OFFER: Subscription is just $39 USD monthly for entry to graded supplies and a certificates.

This course is a part of a number of packages

This course may be utilized to a number of Specializations or Skilled Certificates packages. Finishing this course will rely in the direction of your studying in any of the next packages:

• IBM Knowledge Engineering Skilled Certificates
• Knowledge Science Fundamentals with Python and SQL Specialization

WHAT YOU WILL LEARN

• Analyze information inside a database utilizing SQL and Python.

• Create a relational database on Cloud and work with tables.

• Evaluate and distinction DDL to DML.

• Write SQL statements together with SELECT, INSERT, UPDATE, and DELETE.

SKILLS YOU WILL GAIN

• Cloud Databases
• Python Programming
• Ipython
• Relational Database Administration System (RDBMS)
• SQL

Syllabus – What you’ll study from this course

Content material Ranking93%(29,045 rankings)

WEEK

1

2 hours to finish

Getting Began with SQL

On this module, you may be launched to databases. You’ll create a database occasion on the cloud. You’ll study a number of the primary SQL statements. Additionally, you will write and follow primary SQL hands-on on a stay database.

WEEK

2

5 hours to finish

Introduction to Relational Databases and Tables

On this module, you’ll discover the basic ideas behind databases, tables, and the relationships between them. You’ll then create an occasion of a database, uncover SQL statements that will let you create and manipulate tables, after which follow them by yourself stay database.

WEEK

3

7 hours to finish

Intermediate SQL

On this module, you’ll learn to use string patterns and ranges to go looking information and the way to type and group information in consequence units. Additionally, you will follow composing nested queries and execute choose statements to entry information from a number of tables.

WEEK

4

6 hours to finish

Accessing Databases utilizing Python

On this module you’ll study the fundamental ideas associated to utilizing Python to hook up with databases. In a Jupyter Pocket book, you’ll create tables, load information, question information utilizing SQL, and analyze information utilizing Python.