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 Sep 2023 LearnSQL.com Team Free Course of the Month – SQL Practice Set in PostgreSQL Do you know the basics of PostgreSQL but still need some practice? Look no further! Here is a great interactive course, SQL Practice Set in PostgreSQL. Throughout the month of September, you have access to it for FREE! We at LearnSQL.com believe that to learn a new skill, you need basic theoretical knowledge and, above all, a lot of practice. It's the same with writing PostgreSQL queries – you need a lot of PostgreSQL practice. Read more 29 Aug 2023 LearnSQL.com Team New Monthly SQL Practice for September 2023! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the September SQL Practice course! This time, you will help Evelyn, the owner of a local art gallery. She would like to gather data to grow her business and has hired you as an SQL specialist to help her out. Which art pieces have not been exhibited? What is the transportation cost for each art piece? Read more 25 Aug 2023 LearnSQL.com Team SQL for Data Analysis Cheat Sheet Welcome to our SQL for Data Analysis Cheat Sheet — a must-have resource for anyone looking to harness the power of SQL in the realm of data analysis. Whether you're a data enthusiast, a business analyst, or a seasoned data professional, this cheat sheet is designed to empower you to extract valuable insights from your datasets. Inside, you'll find a carefully curated collection of SQL commands and tips that will elevate your data analysis game. Read more «« « 1 2 3 … 10 » »»