SQL for Data Science

SQL for Data Science

At a time when the world is producing 2.5 quintillion bytes of data, a rather mind-boggling amount, the demand for data scientists, who can make sense of such deluge of data, is increasing. Businesses around the world are recognizing the role of data in product, operation, and customer service decision-making. In Bangladesh, startups and big companies alike are hiring and intend to hire more and more data scientists to leverage the insights drawn from data and integrate them into the product, marketing, operation, and other decisions. In such a backdrop, it’s important that an aspiring data scientist is well-versed in SQL, because SQL is the programming language for communicating with any database. This course will teach you the basics of SQL, starting with SQL syntax and moving on to Entity Relationship Diagram(ERD) and explaining its importance in SQL. It will help you create tables and insert data into them and gradually write simple queries to retrieve data. You will also learn how to update and delete data from tables. By the end of the course, you will be able to create a simple database, using real-world scenarios.
This course is designed for those seeking to enter the field of Data Science, but with no prior background. The course will also be helpful for aspiring digital marketers, product developers, and executives that want to make data-driven decisions. This course will act as a stepping stone into the world of data. Welcome to the world of SQL. Enroll now!
.

Last Update 05/22/2020
Completion Time 2 hours 14 minutes
Members 417
    • 01 Introduction
    • 02 What is SQL?
    • 03 SQL Commands
    • 04 Data Modelling
    • 05 Entity Relationship Diagram
    • 06 Primary and Foreign Key
    • 07 How to Retrieve Data
    • 08 How to Create Tables
    • 09 How to Insert Data
    • 10 How to Update Data
    • 11 How to Delete Data
    • 12 Adding comments in SQL
    • 13 Data Types Part 1
    • 14 Data Types Part 2
    • 15 Filtering Data
    • 16 Filtering Data Part 2
    • 17 Filtering Data Part 3
    • 18 Sorting Data
    • 19 Math Operator
    • 20 Aggregate Functions
    • 21 GROUP BY and HAVING Clause
    • 22 Subquery
    • 23 SQL JOIN
    • 24 SQL JOIN Part 2
    • 25 Practicing SQL
    • 26 Conclusion
    • Assessment and Certificate