Відео

This is the 1st part of 3 videos for getting started with NYC Open Data and Tableau Visualizations. In this video, we visit the NYC Open Data site and download CSV data. Please note that while I show one data set here, in the next videos I use the Citywide Payroll Data instead (data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e/about_data) because the 311 data is...

This is the 2nd part of 3 videos for getting started with NYC Open Data and Tableau Visualizations. In this video, we select and load the Citywide Payroll Data (data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e/about_data) into Tableau.

A couple of quick steps to run MySQL from Docker.

What is a Database Management System? What is a Database? What are Data? In this short video, we give a quick explanation of all of these. This is a good video for anyone beginning to learn about databases or data.

In this video, we use ChatGPT to create SQL statements to create and populate tables in postgres Here is the dialog between the user and ChatGPT: chat.openai.com/share/d1dafdf9-9334-46de-9f60-280a19ef470b

If you want to get started learning about databases or want to move from Access, this video shows you how to configure a database using CockroachDB Cloud (cockroachlabs.cloud/) We then create some tables and insert data using the following commands: CREATE TABLE Guide ( GuideNum CHAR(4) PRIMARY KEY, LastName TEXT, FirstName TEXT, Address TEXT, City TEXT, State CHAR(2), ZipCode CHAR(5), PhoneNum...

In this video, we explore creating a subquery in Microsoft Access. We go through all of the steps required to answer a question. A subquery is when you use the results of one SQL command within another SQL command. Should out to Andre D. for asking this question; I hope this helps.

After going through this video, you should have an idea of the following: * Minimal database table requirements (table name and list of attributes) * High-level Data Types * Primary Keys * Foreign Keys This is Part 3 of a series of videos that I am creating for anyone learning about data, databases, and database management systems. If you have any questions about this content or would like a vi...

Video 2 for Gentle Introduction to Databases where we explore how we can use Spreadsheets to organize data.

Gentle Introduction to Databases Video 1 of many where I explore how to learn about databases without 0 prior experience.

SQL and Database knowledge are in high demand. Learning about sql and databases can require some configuration and installation that many people, including myself, are not fond of doing. In this video, I go through how to use Supabase to configure a database and table so that you can explore SQL concepts.

Sometimes your SQL tables will have many rows for the same customer, the same department, the same entity and you only want to get the last edited or the last updated row for each of those. How do you do it? In this video, I show you how you do it and I introduce a couple of commands including: * row_number() * over * partition * qualify Thumbs up if you like this video, reply in the comment if...

The Snowflake SQL Unpivot command is pretty cool and may help you in the future. UNPIVOT rotates a table by transforming columns into rows. In this video, I go through the Snowflake Documentation example and provide my own insights. If this was helpful, click like. If it wasn't and you'd like to see something else, just write a comment below and the next video on my list will be to answer you q...

3/3. Using Remember To Keep State in Android Composables

2/3. Add Logic To Die Rolling App

1/3 Adding Drawable and Using Image Composable

Cell Highlighting based on Months Passed using Excel DATEDIF

Getting Started with Colab Notebooks: Get User Input, Save to Variable, and Print Result

Creating Excel Dropdowns using Data Validation and Indirect Function

Installing MySQL Server And Workbench on Windows 10