Data is one of the most critical assets of any business, and thus it needs to be stored and accessed quickly and securely. A database is a repository of data to handle a large amount of information by storing, retrieving, and managing data. Nowadays, almost every company in the world is handled through databases. SQL is the standard query language to work and deal with relational databases. Relational databases manage data in tables, making them efficient and flexible structures to store and access information. SQL is the core of relational databases and allows users to insert, search, update, and delete database records. It also provides many other manipulations and operations, including optimizing and maintaining databases.
TechClass SQL for Data science online course will introduce you to SQL and its essential functionalities for Data Science. Through this course, you will learn how to create and manage relational databases. You will gain hands-on experience with MySQL database management system to manage, control, analyze, and query data stored in the relational databases using lots of SQL commands required for an aspiring Data Scientist, Data Analyst, or Data Engineer. By the end of this course, you will be prepared to enter the fantastic world of data analysis towards fantastic job opportunities in the industry.
- Learn about data, databases, relational databases, and data types
- Learn about SQL and its capabilities, characteristics, and use cases
- Get familiar with the concept of ER diagram and how it is created
- Learn how to install and set up MySQL
- Get familiar with primary and foreign keys
- Learn how to create tables and databases with ER diagrams using SQL
- Get familiar with SQL statements for filtering and sorting data
- Learn about the different ways of joining tables and the SQL queries that perform them
- Learn lots of useful SQL statements to query databases and get various types of information
- Learn how to connect to and access databases using Python using DB-API
Table of contents
Chapter 1: Intro to Course
- 1.1. Welcome!
- 1.2. About TechClass Data Science Department
- 1.3. Learning Outcomes
- 1.4. Your Expectations, Goals, and Knowledge
- 1.5. Abbreviations
- 1.6. Copyright Notice
Chapter 2: Introduction
- 2.1. Introduction to Database
- 2.2. Relational Databases
- 2.3. Database Management Systems
- 2.4. Why DBMS?
- 2.5. What is SQL?
- 2.6. Why SQL for Data Science?
- 2.7. SQL Elements
- 2.8. SQL Basic Statements
Chapter 3: Requirements for Relational Databases
- 3.1. Introduction
- 3.2. Entity
- 3.3. Attribute
- 3.4. Relationship
- 3.5. Cardinality of Relationships
- 3.6. Entity Relationship Diagram
- 3.7. Quiz
Chapter 4: Relational Database Modeling
- 4.1. Introduction
- 4.2. Relations
- 4.3. Mapping Entities into Relations
- 4.4. Primary and Foreign Keys
- 4.5. Mapping Relationships into Relations
- 4.6. Data Types
- 4.7. Quiz
Chapter 5: MySQL Database
- 5.1. Introduction to MySQL Database
- 5.2. Install MySQL: Part 1
- 5.3. Install MySQL: Part 2
- 5.4. Create a Database
- 5.5. Create a Table
- 5.6. Delete a Table/Database
- 5.7. MySQL Database
Chapter 6: Basic SQL Statements
- 6.1. Introduction
- 6.2. CREATE DATABASE Statement
- 6.3. CREATE TABLE Statement
- 6.4. SELECT Statement
- 6.5. WHERE Clause
- 6.6. INSERT Statement
- 6.7. ALTER Statement
- 6.8. UPDATE Statement
- 6.9. DROP and TRUNCATE Statements
Chapter 7: Filtering, Sorting, and Calculating Data with SQL
- 7.1. Introduction
- 7.2. Filtering: IN
- 7.3. Filtering: OR
- 7.4. Filtering: NOT
- 7.5. Wildcards in SQL
- 7.6. Sorting with ORDER BY
- 7.7. Aggregate Functions
- 7.8. Math Operations: SUM, COUNT
- 7.9. Math Operations: MAX, MIN
- 7.10. Grouping Data
- 7.11. Having
Chapter 8: Subqueries and Joins in SQL
- 8.1. Introduction
- 8.2. Aliases
- 8.3. INNER JOIN
- 8.4. LEFT JOIN, RIGHT JOIN
- 8.5. CROSS JOIN
- 8.6. SELF JOIN
- 8.7. Subqueries
- 8.8. UNION
- 8.9. Quiz
Chapter 9: Access MySQL with Python
- 9.1. Introduction
- 9.2. Python DB-API
- 9.3. Install PyMySQL and Create its Connection
- 9.4. Create Database and Table
- 9.5. SELECT Syntax
- 9.6. Retrieve Tables with Pandas
Chapter 10: Final Tasks
- 10.1. Project
- 10.2. Self-study Essay
Chapter 11: Finishing the Course
- 11.1. What We Have Learned
- 11.2. Where to Go Next?
- 11.3. Your Opinion Matters
- 11.4. Congrats! You did it!
Payment & Security
In this course, I learned what I needed to know about SQL. How to connect to SQL and query with Python was very useful to me.
Thanks to TechClass for designing this course. I have long been looking for a complete course to learn SQL that is understandable.
If you have little knowledge of SQL, this course can help. Almost all the concepts needed to work with SQL are well explained.
The content of this course was really nice, but I also like to point out the amount of nice illustrations that they created for the content to make it much nicer and enjoyable to learn. Great job.
- Opens in a new window.