SQL for Data Science (5 credits)


Price:
Sale price€249.75

Tax included

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. This course will introduce the student to SQL and its essential functionalities for Data Science. Through this course, the student will learn how to create and manage relational databases. The student 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, the student will be prepared to enter the fantastic world of data analysis towards amazing 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: Beginning with This Course

  • 1.1. Our Approach in This Course
  • 1.2. TechClass AI Department
  • 1.3. Your Expectations, Goals, and Knowledge

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. Test Yourself

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. Test Yourself

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. Test Yourself

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
  • 10.3. 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

You may also like

Recently viewed