SQL Data Ninja

SQL tables of several types including table variables, temp tables and inline tables with examples!

Subquery with Aggregate Function in SQL Server

The SQL window functions are covered in this video with lots of examples.

SQL INSERT Statements with two variations.

We use SQL , Python, and Tableau in our analysis of Major League Baseball data from 1962 to 2012.

SQL UPDATE Statement and Best Practices

Getting Started with Google Colab: Python Programming Tutorial

Importing Stock Data from Excel to SQL Server Database

This video covers entropy and information gain using an example with fruit in using Excel and SQL.

Importing flat files into SQL Server.

SQL Performance in SQL Server

Problem Solving with Aggregate Functions in SQL Server

Web scraping financial data using Python and inserting the data into SQL Server

SQL Pivot Operator

SQL DELETE Statement Explained with Examples

The DateBucket function released in the new SQL Server 2022.

JSON in SQL Server

This is a video about executing Python and SQL together in SQL Server.

Commodity pricing data is imported into SQL Server. Data types are specified and tables are merged.

Everything on SQL dates including data types, functions, formats and converting integers or strings

CAST() and CONVERT() in SQL Server

JSON in SQL Server - Store, transmit and query JSON data alongside tabular, relational data.

The SQL Lead and Lag Functions are Explained in a Daily Stock Pricing table for for Daily Returns.

Correlation coefficients in Python and Excel using commodity prices as well as Libor (Interest rate)

IRS Form 990 Using the .Nodes Method, the .Values Method and CROSS APPLY to Shred the Data.

Descriptive statistics and SQL are combined in this presentation to include mean, median and mode.

Capturing option chain pricing data using Python and storing it in an SQL database.

SQL JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN and CROSS JOINs are thoroughly covered in this video.

Foreign Currency Exchange Rates Part 1 - Retrieve exchange rates for many currencies using Python.

Ice Cream Data 3 : A Data Frame

This is a Dynamic SQL demonstration in SQL Server that demonstrates using EXEC and sp_executesql

SQL Server Client Login - Shows how to login to a remote server or a local instance.

CREATE Statement, Cross JOIN and Stored Procedure in SQL Server

Download and Decompress IRS Form 990 Data in XML Files

SQL stored procedures are covered here. We include input and output parameters and variables.

A recursive CTE is used to calculate routes to get to different locations including mileage.

Beginning Python in Jupyter notebooks is covered in this video.

Join and Union in SQL Server

Financial Statement Analysis using Python and SQL