Skip to main content

Posts

Showing posts from June, 2020

Databases and SQL for Data Science

Under Maintenace ! Some topics may work... Don't forget to check out those... 1.  Introduction to Databases and Basic SQL     1.1 Introduction to Databases Welcome to SQL for Data Science Introduction to Databases How to create a Database instance on Cloud     1.2 Basic SQL Create Table Statement SELECT Statement COUNT, DISTINCT, LIMIT INSERT Statement UPDATE and DELETE Statement 2. A dvanced SQL     2.1. String Patterns, Ranges, Sorting, and Grouping Using String Patterns, Ranges Sorting Result Sets Grouping Result Sets     2.2. Functions, Sub-Queries, Multiple Tables Built-in Database Functions Date and Time Built-in Functions Sub-Queries and Nested Selects Working with Multiple Tables 3. Accessing Databases using Python How to Access Databases Using Python Writing code using DB-API Connecting to a database using ibm_db API Creating tables, loading data and querying data Analyzing data w