Progress Log 67 (SQL): Calculating results with CASE, ELSE, END AS, JOIN

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.   Calculating results with CASE     Where 220 is considered a high heart rate and 30 is the instructor’s age.     Four …

Progress Log 66 (SQL): AND/OR, Querying IN subqueries, LIKE “%%”, Restricting grouped results with HAVING, AS, AVG, COUNT, GROUP BY

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.   AND/OR     AUTOINCREMENT: increments values by one from the highest value. In this example, after the INSERT INTO, we see that id …

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 TABLE: Creates a table. groceries: The name of your table. …

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 data types. No primary key and no NULL ability. This …

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 procedures used, any objects and we can group them into one …

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 numeric data that we can store: Firstly, let us have look at whole numbers or integers. We …

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 database “spreadsheet”. Attributes are descriptions of our entity. Primary Key:  the unique identifier that is …