A collection of T-SQL scripts I written throughout my journey as a Data Analyst, Data Engineer, and BI Developer. They demonstrate the use of window functions, calculating dates, dynamic SQL, stored procedures, and other out of the box solutions.

An example of a complex T-SQL query

My Youtube playlist - SQL Server Videos for Beginners - https://www.youtube.com/playlist?list=PLOX4P8JBtVQCH3nU5FXyrOoLn1z9rTUf1

Notes and Assignments done as part of the CSCI-B561 Advanced Database Concepts course at Indiana University Bloomington

Integration of MySQL into C++ via the use of ODBC

Dynamic Sequence/Trigger Pair using Oracle PL/SQL on every table in the database.

Database design for Big Data

A PL/SQL package to create modular batch chains with dynamic variable and query support

Collection of PL/SQL scripts which decorate an Oracle DB table by additional structure to serve as a DataHub

Retrieve records from a table using dynamic SQL (no need to write the columns name in the sp)

SQL Server Linked Server's aliasing workaround

Wise Owl SQL Server Exercises Solutions

Useful SQL Scripts

Converting dynamic sql to static sql on the fly

SQL Query Builder Utility for .NET

The Core of the minecraft.plugin.zocker.pro series

The fenix spring boot starter. 这是 Fenix JPA 扩展库的 Spring Boot Starter 库。

这是 Spring Data JPA 的 Fenix 扩展示例项目

Lightweight persistence layer framework, support interface mapping, dynamic sql and sql file manager.