AdvancedSQLPuzzles
chadbaldwin.github.io
| AdvancedSQLPuzzles | chadbaldwin.github.io | |
|---|---|---|
| 16 | 2 | |
| 499 | 26 | |
| - | - | |
| 9.2 | 4.6 | |
| about 2 months ago | 23 days ago | |
| TSQL | HTML | |
| - | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
AdvancedSQLPuzzles
-
Not using window functions?
Try advancedsqlpuzzles.com
- I don't see the point in these problems.
- Interview at Square for Data Engineering
- How can I improve my SQL skills if I don't use it in work?
- How do I count the number of series per team?
-
Where can I find exercises to practice my SQL learning?
https://advancedsqlpuzzles.com/ Hackerrank.com Leetcode.com Datalemur.com
- I'm spending a crazy amount of time on hacker rank questions. Is this normal?
-
Looking for more SQL exercises after finishing all the free medium and hard questions on stratascratch
Try this GitHub repository. It has a PDF of 50+ advanced puzzles that are nicely written, along with the solutions in a separate sql script.
- Looking for advanced SQL resources
- SQL Case Studies to Practice
chadbaldwin.github.io
-
[MS SQL / T-SQL] My second blog post! Using cross apply to clean up queries....essentially creating inline variables...
Here's the repo that drives the site: https://github.com/chadbaldwin/chadbaldwin.github.io
- Im Interested In Starting A Personal Blog Mostly
What are some alternatives?
sp_whoisactive - sp_whoisactive
Practical-Automation-with-PowerShell - Practical Automation in PowerShell reveals how you can use PowerShell to build automation solutions for a huge number of common admin and DevOps tasks. It takes you beyond scripting basics and shows you how to handle the unforeseen complexities that can keep automations from becoming reusable and resilient. You’ll discover tools and platforms that let you share your automations with your team and even roll them out to non-technical users through easy-to-understand Sharepoint frontends.
sql-server-password-secure - Securely storing passwords in SQL-Server for C# and verifying
dillinger - The last Markdown editor, ever.
DataAccessGeneration - Better SQL Server stored procedure calls from C#
DataEngineeringProject - Example end to end data engineering project.
MachineIntelligence-TextAnalytics-TPLDataFlows - Machine Intelligence using OpenAI, Semantic Kernel, Vector Search, SQL Server
sql-server-maintenance-solution - SQL Server Maintenance Solution
dp-300-database-administrator - Repository for lab exercises and instructions for Microsoft DP-300 learning content
W3Schools - W3Schools Full Offline Version
analytics
8-week-sqlchallenge - My solutions for the 8 Week SQL Challenge