31 Mar 2024 LearnSQL.com Team New Monthly SQL Practice for April 2024! In our April 2024 SQL Practice, you’ll meet Damien who manages a local art museum. He needs you to extract and present him with information to promote the museum. Will you use your SQL skills to help him? It should not be too hard if you have finished our SQL Basics course or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and put what you have learned so far into practice. Read more 27 Feb 2024 LearnSQL.com Team New Monthly SQL Practice for March 2024! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the March SQL Practice course! This time, you will help Lilia who runs a genetic testing clinic. She needs insight into the performance of her clinic for February 2024 and has hired you as an SQL specialist to help her out. Can you identify the most popular tests? Can you create a report on patient preferences by age? Read more 21 Feb 2024 LearnSQL.com Team 4th Anniversary of LearnSQL.com Time runs so fast. This week, we celebrate the 4th anniversary of LearnSQL.com. We have come a long way together and we promise to get even better in the upcoming year! Thank you for being with us. 1459 days have passed since February 23, 2020, when we launched the LearnSQL.com platform. That's 35,016 hours, or 2,100,960 minutes, if you prefer. It's been a long time, but it feels like yesterday that we started out together. Read more 14 Feb 2024 LearnSQL.com Team PostgreSQL Cheat Sheet Here's your ultimate PostgreSQL cheat sheet! Whether you're a newbie or an experienced pro in need of a quick reference, this cheat sheet has got you covered. This PostgreSQL Cheat Sheet summarizes the key PostgreSQL commands and features you'll use often. It covers everything from how to connect to a PostgreSQL server and manage database contents, to the basic syntax for table creation and modification. It also breaks down the syntax for SELECT, INSERT, UPDATE, DELETE commands, and shows how to use different PostgreSQL functions, including text functions, numeric functions, NULL functions, and date and time functions. Read more 30 Jan 2024 LearnSQL.com Team New Monthly SQL Practice for February 2024! In our February 2024 SQL Practice, you will meet Andrew. He is the manager of a ski resort in Tirol and needs help to get important insights from the database of his resort. He wants to find out how customers rate different slopes at his resort, which reviews are the best and the worst for the slopes, which slopes are the least popular, etc. Will you use your SQL skills to help him? Read more 22 Dec 2023 LearnSQL.com Team New Monthly SQL Practice for January 2024! In our January 2024 SQL Practice, you’ll meet Julie. She is the owner of an online store where she sells handmade crochet items. She has hired you to help her with data analysis to grow her business. What are the best-selling products? Which products bring the most revenue? Can you create reports to help her with sales trends? You will find all the answers in the data. You just need to figure out how to get them out of the database using SQL. Read more 29 Nov 2023 LearnSQL.com Team New Monthly SQL Practice for December 2023! In our December 2023 SQL Practice, you’ll meet John. He manages a website specializing in cooking recipes, tutorials, and articles. John needs you to extract and present information to help with further development of the website. Will you use your SQL skills to help him? It should not be too hard if you have finished our SQL Basics course or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and put what you've learned so far into practice. Read more 26 Oct 2023 LearnSQL.com Team New Monthly SQL Practice for November 2023! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the November SQL Practice course! This time, you will help Emily, the owner of a local bike rental shop. She would like to gather data to help her grow the business and has hired you as an SQL specialist. Can you find out how many bikes the shop owns by category? Can you calculate the rental revenue for each month? Read more 28 Sep 2023 LearnSQL.com Team New Monthly SQL Practice for October 2023! In our October 2023 SQL Practice, you meet Sophie. She manages an online business for publishing and printing books and needs you to access and present various statistics to help her grow her business. Can you use your SQL skills to help? It should not be too hard if you have finished our SQL Basics courses or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and see if you can put what you've learned so far into practice. Read more 4 Sep 2023 LearnSQL.com Team SQL Server Cheat Sheet Welcome to the SQL Server Cheat Sheet! Whether you're just starting out with SQL Server or you're a seasoned developer looking for a quick reference, this guide is tailored for you. This cheat sheet is a comprehensive guide to SQL Server, offering a quick reference to its essential commands. It covers the basics of creating and displaying databases and tables, the commands to modify tables, and the fundamental syntax for T-SQL commands such as SELECT, INSERT, UPDATE, and DELETE. Read more «« « 1 2 3 … 10 » »»