Databases and SQL for Data Science

Preference Dates Timing Location Registration Fees
Hybrid (In-Person & Live Webinars) 11, 13, 15, 18, 20, 22 July 2021 07:00 PM - 08:30 PM Dubai Knowledge Park 3,500 AED

Course Description

Much of the world’s data resides in databases.  SQL (or Structured Query Language) is a powerful language used for communicating with and extracting data from databases.  Working knowledge of databases and SQL is a must if you want to become a data scientist.

The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment.  

The emphasis in this course is on hands-on and practical learning.  Indeed, you will work with real databases, real data science tools, and real-world datasets.  Moreover, you will learn how to create your own database instance in the cloud.  Through a series of hands-on labs, you will practice building and running SQL queries.  You will also learn how to access databases from Jupyter notebooks using SQL and Python.

Unit 1 – Getting Started with SQL

  • Overview of SQL for Data Science
  • Introduction to Databases
  • SELECT Statement
  • COUNT, DISTINCT, LIMIT
  • INSERT Statement
  • UPDATE and DELETE

Unit 2 -​ Relational Databases and Tables

  • Relational Database Concepts
  • Creating a Database Instance
  • Types of SQL Statements (DDL vs. DML)
  • CREATE TABLE Statement
  • ALTER, DROP and Truncate Table

Unit 3 – Searching, Sorting and Grouping Data

  • Using String Patterns and Ranges
  • Sorting Result Sets
  • Grouping Result Sets
  • Built-in Database Functions
  • Date and Time Built-in Functions
  • Sub-Queries and Nested Selects
  • Working with Multiple Tables

Unit 4 – Accessing Databases using Python

  • How to Access Databases using Python
  • Writing Code using DB-API
  • Connecting to Relational Databases
  • Creating Tables, Loading Data and Querying Data
  • Analyzing Data with Python

Unit 5 – Advanced SQL

  • Views
  • Stored Procedures
  • ACID Transactions
  • Joins Overview
  • Inner Joins
  • Outer Joins
  • Professionals or students interested to learn how to extract data from relational databases and analyze it with Python.
  • Future Data Analysts, Data Science Professionals or Engineers.
  • No prior technical experience is required to benefit from this course.

The participants who have successfully completed this course are encouraged to take our Artificial Intelligence Professional Program.

Testimonials