Starter SQL Challenges

This project has been completed by 116 users

This is your first SQL challenge! Although there isn't too much hype around SQL, it's one of the most important skills for a software developer. One could argue that nothing can be done on the internet without writing to and reading from databases, and SQL is the most common language used to communicate with them.

For .NET developers, it's tempting to skip SQL and jump straight into Entity Framework. It's indeed a great ORM and gone are the days where it would suit only simple projects, while raw SQL would be required for more complex operations. However, a developer will only have advanced knowledge of Entity Framework with advanced knowledge of SQL. After all Entity Framework does nothing more than compile into SQL! (in a neat, developer-friendly way, we must say).

In this project we're using CodeWars exercises integrated with our platform to deliver automated feedback. CodeWars is a popular online platform that offers a collection of coding challenges and programming exercises. It provides a wide variety of programming problems that cover different programming languages, algorithms, data structures, and computer science concepts.

Requirements

For this project you'll complete the following exercises in the Code Wars Platform:

Resources

If this is your first contact with SQL, Free Code Camp's tutorial is an excellent resource. It's 5 years old but that's not an issue. Most core SQL features haven't changed a lot since they have been created. If you already know some SQL, SQLtutorial.org is a slim, to-the-point resource for learning commands you're not familiar with.

Tips

You don't need to refrain from using Chat GPT. However avoid the temptation of using it without understanding the SQL script. AI will only take you so far and you won't be able to handle very complex scenarios. Try to understand what EACH KEYWORD does. Also ask Chat GPT for alternative answers.

Create your own library of scripts and push it to Github. You'll find yourself reusing your old scripts, or basing yourself off of old ones all the time. It will save you a lot of time to have your own library as a reference.

Comments

0 comments

No comments yet. Start the conversation.

Sign in to add a comment.
An unhandled error has occurred. Reload 🗙