Chinook DatabaseThe Chinook Database is a sample database available for several database products, including SQL Server, PostgreSQL, MySQL, Oracle, […] January 10, 2023 in Database tagged media / music / sample / dataset / data / database / digital by Mike
SQL Select IntoThe SELECT INTO statement copies data from one table into a new table. Here’s the syntax for copying […] January 8, 2023 in SQL Server tagged backup / table / copy / into / select by Mike
SQL Update From Another TableWe want to add a new column to our Orders table and put the product name into that […] January 8, 2023 in SQL Server tagged update / change / sql / clean by Mike
SQL Add ColumnWhat is the SQL statement that adds a column to an existing table? The SQL statement is the […] January 8, 2023 in SQL Server tagged sql / add / column / attribute by Mike
SQL Update StatementThe UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […] January 4, 2023 in SQL Server tagged update / change / sql by Mike
Kaggle IntroductionWhat is Kaggle? Wikipedia says: “Kaggle, a subsidiary of Google LLC, is an online community of data scientists […] December 27, 2022 in Database tagged data / dataset / notebook by Mike
Data Model Examples in ExcelDo you want to work with a few small & sample data models in Excel to practice the […] December 13, 2022 in Database tagged sample / model / relationship / dataset / bridge / data / database / excel by Mike
Tiny MeasuresIMDBNow it’s time to create some Measures in the Tiny IMDB database. A measure is a DAX formula […] December 6, 2022 in IMDB tagged movie / imdb / Tiny IMDB Data Model by Mike
Get Other TablesNow we need to get other tables and create the relationships After we’ve imported all of the tables […] December 6, 2022 in IMDB tagged imdb / movie / Tiny IMDB Data Model by Mike
Get Ratings from TinyNext we’ll use Power Query to bring in the ratings data into the Data Model. There are no […] December 6, 2022 in IMDB tagged movie / imdb / Tiny IMDB Data Model by Mike
Build the Tiny Data ModelBelow is a link to the downloadable Excel file that contains a sheet with the table we will […] December 6, 2022 in IMDB tagged movie / imdb / Tiny IMDB Data Model by Mike
Microsoft’s FoodMart DatabaseIt’s always very helpful to have a database to work with when you are learning software such as […] November 28, 2022 in Database tagged datasets / data / test / sales / sample / set / lookup / fact / food / mart by Mike