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

The DateBucket function released in the new SQL Server 2022.

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

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

Importing flat files into SQL Server.

SQL Pivot Operator

SQL Performance in SQL Server

CREATE Statement, Cross JOIN and Stored Procedure in SQL Server

IRS Form 990 Shredding XML Data Into Columns and Rows

Inserting Form 990 XML Data into a SQL Server XML Native Data Type

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

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

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

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

Join and Union in SQL Server

SQL DELETE Statement Explained with Examples

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

Installing and starting Python

CAST() and CONVERT() in SQL Server

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

Ice Cream Data 2 - Analysis Video Using Python

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

Beginning Python in Jupyter notebooks is covered in this video.

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

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

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