Blog

Data Blog

 

LATEST BLOG POSTS

All Data Analytics/Data Science SQL Pandas Python

Progress Log 65 (SQL): Creating a table and inserting data, Querying the Table, Aggregating Data

I'm taking a course entitled "Intro to SQL: Querying and managing data" by Khan Academy and all of the concepts described below come from that course.   Creating a table and inserting data *click title for the video*   CREATE…
CONTINUE READING

Progress Log 64 (SQL): CREATE TABLE, DROP TABLE, ALTER TABLE, Temporary Tables, Computed Columns – PERSISTED, Demo: Working with Tables

I'm taking a course entitled "Developing SQL Databases" by Microsoft at edX and all of the concepts described below come from that course.   Creating, Dropping, and Altering Tables In this first example, we have the names of the columns and…
CONTINUE READING

Progress Log 63 (SQL): What is a Schema?, Object Name Resolution, Demo: Schemas

I'm taking a course entitled "Developing SQL Databases" by Microsoft at edX and all of the concepts described below come from that course.   What is a Schema?   Basically, we can group up our objects. Now that could be tables, stored…
CONTINUE READING

Progress Log 62 (SQL): Introduction to Data Types, Numeric Data Types, Data and Time Data Types, Unique Identifiers, Converting Data Between Data Types

I'm taking a course entitled "Developing SQL Databases" by Microsoft at edX and all of the concepts described below come from that course.   Introduction to Data Types     Numeric Data Types   Different types of…
CONTINUE READING

Progress Log 61 (SQL): Normalizing Data, Normalizing Terms, Denormalizing, Normalization Forms – First Normal Form, Second Normal Form, etc., Overnormalization Forms, Walkthrough: From Unnormalized to 3NF

I'm taking a course entitled "Developing SQL Databases" by Microsoft at edX and all of the concepts described below come from that course.   Normalizing Data   Normalizing Terms   Entity: a table Attribute: columns of our…
CONTINUE READING

Progress Log 60 (Python 3): Boolean Logic and Control Flow, Modulo Operator %2 == 0, Pandas – Column Access, Row Access

I'm taking a course entitled "Introduction to Python for Data Science" by Microsoft at edX and all of the concepts described below come from that course.   Boolean Logic and Control Flow To check if a value is an even number,…
CONTINUE READING