3:18The SQL Lead and Lag Functions are Explained in a Daily Stock Pricing table for for Daily Returns.SQL Data Ninja126 views·3 years ago
4:33IRS Form 990 Using the .Nodes Method, the .Values Method and CROSS APPLY to Shred the Data.SQL Data Ninja136 views·3 years ago
3:02A recursive CTE is used to calculate routes to get to different locations including mileage.SQL Data Ninja150 views·3 years ago
2:48Ice cream 4 uses methods like describe, info, jointplot, pairplot and regression analysis.SQL Data Ninja91 views·3 years ago
1:41Inserting Form 990 XML Data into a SQL Server XML Native Data TypeSQL Data Ninja248 views·3 years ago
14:46Correlation coefficients in Python and Excel using commodity prices as well as Libor (Interest rate)SQL Data Ninja294 views·4 years ago
9:37Foreign Currency Exchange Rates Part 1 - Retrieve exchange rates for many currencies using Python.SQL Data Ninja545 views·4 years ago
20:59Commodities Part 3 This video illustrates analyzing commodities prices using SQL and Python.SQL Data Ninja381 views·4 years ago
10:43Commodity pricing data is imported into SQL Server. Data types are specified and tables are merged.SQL Data Ninja379 views·4 years ago
10:23Commodity Prices - Acquisition and Analysis using SQL and Python Part 1SQL Data Ninja787 views·4 years ago
26:02Everything on SQL dates including data types, functions, formats and converting integers or stringsSQL Data Ninja505 views·4 years ago
18:24SQL JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN and CROSS JOINs are thoroughly covered in this video.SQL Data Ninja426 views·4 years ago
7:37Capturing option chain pricing data using Python and storing it in an SQL database.SQL Data Ninja908 views·5 years ago