SQL for Data Science Online Course


Price:
Sale price€199.75

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.

Learning outcomes

  • 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!

Brochure

Payment & Security

Payment methods

American Express Apple Pay Mastercard PayPal Visa

Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.


Security

Customer Reviews

Based on 4 reviews
100%
(4)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
L
Liam Anderson
Comprehensive course

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.

V
V. Jrvinen
Love this course

Thanks to TechClass for designing this course. I have long been looking for a complete course to learn SQL that is understandable.

L
Liam Walsh
Good job TechClass

If you have little knowledge of SQL, this course can help. Almost all the concepts needed to work with SQL are well explained.

H
Heini Jaakola
Great overall

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.

You may also like

Recently viewed