AdvancedSQLPuzzles
8-week-sqlchallenge
Our great sponsors
| AdvancedSQLPuzzles | 8-week-sqlchallenge | |
|---|---|---|
| 16 | 8 | |
| 490 | 0 | |
| - | - | |
| 9.2 | 0.0 | |
| about 1 month ago | over 1 year ago | |
| TSQL | ||
| - | - |
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
8-week-sqlchallenge
- Resources to Practice Technical Skills
-
How do I learn to develop logic/get better at SQL?
You can try this site. https://8weeksqlchallenge.com/
-
Sometimes, SQL is extremely hard for me and I'm going crazy
https://8weeksqlchallenge.com here is a fun and well organized program for working on your SQL skills. All the answers are provided if you need them. It starts off pretty light weight so you can warm up to it. Working on sites like Leetcode, Hackerrank, Stratscratch will only lead to headaches. Those are poorly written questions that are more for reading comprehension than learning SQL.
-
I'm spending a crazy amount of time on hacker rank questions. Is this normal?
Here’s something a little more fun for you that isn’t a pile of hot garbage: https://8weeksqlchallenge.com
- Looking for exercices
- Tech Layoff SQL Learning Resource Recommendations?
-
Resources to take my SQL skills to the next level?
https://8weeksqlchallenge.com/ is very good resource for practicing SQL as practice makes the person perfect.
-
Lessons learnt from the 8 week sql challenge: window functions & ranking
👩🏼💻 using Google BigQuery SQL syntax 📁 check Github repository for context
What are some alternatives?
sp_whoisactive - sp_whoisactive
8-Week-SQL-Challenge - Case study solutions for the #8WeekSQLChallenge.
sql-server-password-secure - Securely storing passwords in SQL-Server for C# and verifying
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
CEDS-Data-Warehouse - Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
chadbaldwin.github.io - The repo that drives my blog chadbaldwin.net