database

Self Hosted Period Tracking App For Menstruation 🩸️

Overview

I've been meaning to make this video for a while now as it's a subject im pretty happy about, we took our own stance against company collection of menstrual data and created our own self hosted period application using my database, appsmith, and cloud flare tunnels and now we have complete ownership and control of our data and insights that no company will have access to.

Timestamps

Introduction To SQL & Databases

SQL is an awesome language and has been around for decades. It is the defacto language for dealing with and manipulating data in Relational Databases.

I use SQL in my day job every day and it is a fantastic tool in your toolbox. It is not only very easy to learn the basics to start getting data and working with it, but certain variations of SQL are just a pleasure to work with.

My least favorite type of SQL is PL-SQL in Oracle databases, and my favorite is T-SQL in SQL Server.

This video takes you through the basics of T-SQL and begins to enter the more intermediary topics of triggers, stored procedures, user defined functions etc.

IF you're looking to get a start in SQL and databases this is a great starting place for you.

0:00:00 - Intro
0:00:33 - Support the Channel
0:00:54 - What is SQL?
0:01:20 - What Does A Database look like?
0:06:03 - Database objects 
0:29:38 - SQL Language Syntax
0:30:18 - USE Database
0:31:22 - Basic SELECT Statement
0:32:47 - DISTINCT Keyword
0:34:02 - The WHERE Clause
0:34:56 - Aggregation Functions
0:37:59 - Aliasing New Columns
0:39:00 - Date Range Operator BETWEEN
0:42:24 - The IN Operator
0:43:11 - GROUP BY
0:44:58 - The HAVING Clause
0:45:36 - Exclude NULL
0:48:44 - SQL JOINS
0:51:06 - Aliasing Tables
0:52:29 - INNER JOIN
0:53:45 - LEFT JOIN
0:55:02 - RIGHT JOIN
0:55:48 - FULL OUTER JOIN
0:58:05 - Date Functions
1:02:37 - Integer Functions
1:03:16 - CAST Data Types
1:04:33 - String Functions
1:07:08 - Variables
1:11:47 - CASE Statements
1:14:54 - IF Statements
1:17:51 - TRY CATCH Statements
1:19:59 - Database Objects
1:20:45 - User Defined Functions
1:26:54 - Triggers
1:33:59 - Common Table Expressions
1:36:50 - Temporary Tables
1:40:52 - Stored Procedures
1:44:32 - Jobs
1:45:27 - Closing
1:47:10 - THANK YOU PATRONS
1:47:23 - Outro