In this first lesson we learn what a database is? Is it just useful for storing data, or does it serve other purposes as well.

Introduction to Databases

Installation tutorial for setting up your server

Install MySQL and Setup Local Server Database

We learn how to create tables in this lesson

Creating Tables for your Database

Wildcards, and Functions in Databases Queries Advanced

ER Diagrams, Entities and Relations

In the Advanced Data Science and Analytics Course, we tackle SQL and Database Management frameworks in the field of Data Science. This includes techniques ensuring data can be applicable and modified using modern Data Mining & Refining Techniques.

Data Science & Analytics - Advanced

Introduction to Databases for Data Scientists

Lesson II with Databases

{time()}-Richard Machina - SQL Programming For Beginners_ The Guide With Step by Step Processes on Data Analysis.pdf

{time()}-Upom Malik, Matt Goldwasser, Benjamin Johnston - SQL for Data Analytics_ Perform fast and efficient data analysis with the power of SQL-Packt Publishing (2019).pdf

Advanced Techniques for Transforming Data Into Insights

{time()}-Cathy Tanimura - SQL for Data Analysis_ Advanced Techniques for Transforming Data into Insights-O'Reilly Media (2021).pdf

{time()}-Renee M Teate - SQL for Data Scientists_ A Beginner's Guide for Building Datasets for Analysis-Wiley (2021).pdf

Recoding of first Session Available Here
https://drive.google.com/file/d/1KaGZHZgCgmkpTPNPi_yfLdxAUT4X9ERt/view?usp=sharing

{time()}-Data Science in - ad.png

Second Live-In Session Recording 
https://drive.google.com/file/d/1ySOuUPr9ywzt1aZ9q7ZUZRaQXgNR6DZH/view?usp=sharing