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.
- 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
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.
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.
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.
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.
0 Comments