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! .
Responsible | BYLCx Admin |
---|---|
Last Update | 02/29/2024 |
Completion Time | 2 hours 14 minutes |
Members | 1684 |
Share This Course
Share Link
Share on Social Media
Share by Email
Please login to share this SQL for Data Science by email.
-
-
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
-