Starter SQL Challenges

Introduction

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.

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.

Linking your Codewars user name with the C# Academy.

In The C# Academy's Dashboard, you'll see a button where you can insert your Codewars user name. Your input has to match Code War's username exactly, including case sensitivity, or we won't be able to track your results.

Once you have completed a challenge, refresh this page and you'll be able to see your progress so far at the bottom of the page. Once all challenges are finished, the project will be marked as completed automatically.

Your Progress

  • Adults only (SQL for Beginners #1)
  • On the Canadian Border (SQL for Beginners #2)
  • Register for the Party (SQL for Beginners #3)
  • Collect Tuition (SQL for Beginners #4)
  • Best-Selling Books (SQL for Beginners #5)
  • Countries Capitals for Trivia Night (SQL for Beginners #6)

Introduction

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.

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.

Linking your Codewars user name with the C# Academy.

In The C# Academy's Dashboard, you'll see a button where you can insert your Codewars user name. Your input has to match Code War's username exactly, including case sensitivity, or we won't be able to track your results.

Once you have completed a challenge, refresh this page and you'll be able to see your progress so far at the bottom of the page. Once all challenges are finished, the project will be marked as completed automatically.

Your Progress

  • Adults only (SQL for Beginners #1)
  • On the Canadian Border (SQL for Beginners #2)
  • Register for the Party (SQL for Beginners #3)
  • Collect Tuition (SQL for Beginners #4)
  • Best-Selling Books (SQL for Beginners #5)
  • Countries Capitals for Trivia Night (SQL for Beginners #6)
An error has occurred. This application may no longer respond until reloaded. Reload 🗙