74 - Introduction to Relational Databases
75 - Data Types and Schemas
76 - Mac Setting Up a Local PostgreSQL Server
77 - Windows Setting Up a Local PostgreSQL Server
78 - Mac SQL Editor Postico
79 - SQL Editor DataGrip
80 - SQL Editor CLI
81 - Creating and Removing a Database
82 - Creating Schemas
83 - Creating Tables
84 - Altering Tables
85 - Enumerated Types
86 - Inserting Values
87 - Running an SQL Script
88 - Reading Data
89 - Creating Tables Using Query Results
90 - Aliases and Ordering
91 - Conditional Filtering Direct Comparisons
92 - Conditional Filtering Grouped Comparisons
93 - Joining Conditionals
94 - Negating Conditionals
95 - Filtering Null Values
96 - Creating New Columns and Arithmetic
97 - Datatype Conversions
98 - Logic Statements
99 - Manipulating Strings
100 - String Positional Information
101 - String Subsets and Concatenations
102 - String Replacements
103 - Date and Time
104 - Date and Time Intervals
105 - Comments
106 - Aggregation Functions
107 - Grouping and Filtering Aggregations
108 - Inner Join
109 - Left Right and Outer Joins
110 - Self Joins
111 - Unions
112 - Subqueries
113 - Common Table Expression CTEs
114 - Window Functions and Aliases
115 - Row Numbers and Ranks
116 - Using Other Rows with Window Functions
117 - NTiles
118 - Understanding Query Performance
