SQL Course of the Month - Recursive Queries by LearnSQL.com Team 4 Aug 2020 Recursive Queries is one of SQL’s more advanced features. You could say they divide SQL users into beginners and experts. But how do you learn recursive queries? And why do you need them, anyway? Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, is here to help. In this article, she answers your questions about our August SQL Course of the Month: Recursive Queries. Recursive queries … that sounds very serious. Read more New Monthly Challenge for August 2020! by LearnSQL.com Team 1 Aug 2020 A new month always brings new challenges. The August Monthly Challenge on LearnSQL.com is ready! This month, we invite you to support Mike in his first year of boarding school while testing your SQL knowledge. The SQL Challenge is a set of several exercises to help you practice your SQL skills. Each challenge is centered around a specific theme—food, stars, planets, travels, work, school, etc. The exercises within a challenge are interrelated, but you can do them in whatever order you want. Read more LearnSQL.com’s New Learning Path: Data Engineering by LearnSQL.com Team 22 Jul 2020 Calling all future data engineers! Would you like to learn to use SQL? Then our new Data Engineering Learning Path is just for you! We’re very excited to announce the release of a new learning path at LearnSQL.com: Data Engineering, published in July 2020. This is the second learning path offered in our platform. So far, we offered an analytical path, SQL Querying & Reporting, that focuses on writing queries and business reports in SQL. Read more New SQL Monthly Challenge for July 2020! by LearnSQL.com Team 1 Jul 2020 The new LearnSQL.com Monthly Challenge is ready! In July, we invite you to sharpen your SQL skills with some questions about US states. If you’ve never come across our Monthly Challenge, it’s a set of 5 to 10 SQL exercises prepared for people who want to practice their SQL skills. Each challenge is designed around a specific theme. In this challenge, you’ll use SQL to learn facts about some US states. Read more SQL Course of the Month - SQL Practice Set by LearnSQL.com Team 5 Jun 2020 It is said that practice makes perfect. I agree with this statement one hundred percent. What is applicable in basketball training, playing an instrument, or learning a foreign language is also useful in learning SQL. Practicing writing queries, using functions, and putting together clauses is the basis for learning the true power of SQL. But how and where do you practice SQL? I spoke with Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo about this. Read more New Monthly Challenge! by LearnSQL.com Team 1 Jun 2020 The new LearnSQL.com Monthly Challenge is ready! In June, we invite you to use your SQL skills to analyze insurance agency activities. Is this the first time you’ve ever come across our Monthly Challenge? Then you should know that it’s a set of 5 to 10 SQL exercises prepared for people who want to practice what they’ve learned. Each challenge is designed around a specific theme. In this seventh challenge, the exercises are built around a fictional insurance agency, but in the other challenges we’ve explored the subjects of pizza, the stars, a car workshop, and bakery management. Read more SQL Course of the Month - Creating Basic SQL Reports by LearnSQL.com Team 20 May 2020 In May, we chose Creating Basic SQL Reports as our course of the month. Why? Because the basis of every successful business is making the right decisions based on proven data and good SQL reports. I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, about this. She knows SQL better than just about anyone and is probably the best person to talk about SQL Reporting. What does it mean to create SQL reports? Read more New Monthly Challenge! by LearnSQL.com Team 1 May 2020 The new LearnSQL.com Monthly Challenge is ready! In May, we invite you to use your SQL knowledge to help a bakery manager buy a new oven. Is this the first time you’ve ever come across our Monthly Challenge? Then you should know that it’s a set of 5 to 10 SQL exercises prepared for people who want to practice their SQL skills. Each challenge is designed around a specific theme. Read more SQL Course of the Month - Window Functions by LearnSQL.com Team 29 Apr 2020 Spring has come. It is nicer outside. It's a great time to learn something new. Which course should you choose? In April, it's worth it to bet on SQL window functions. What are they, what are they used for, and why are they worth knowing? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, these questions. She has a PhD in mathematics and over 10 years’ experience teaching mathematics and computer science at the University of Warsaw. Read more SQL Window Functions Cheat Sheet by LearnSQL.com Team 29 Apr 2020 Download this 2-page SQL Window Functions Cheat Sheet in PDF or PNG format, print it out, and stick to your desk. The SQL Window Functions Cheat Sheet provides you with the syntax of window functions, a list of window functions, and examples. You can download this cheat sheet as follows: Download 2-page SQL Window Functions Cheat Sheet in PDF format (A4) Download 2-page SQL Window Functions Cheat Sheet in PDF format (Letter) Download 1-page SQL Window Functions Cheat Sheet in PDF format (A3) Download 1-page SQL Window Functions Cheat Sheet in PDF format (Ledger) Window Functions Window functions compute their result based on a sliding window frame, a set of rows that are somehow related to the current row. Read more «« « 1 2 » »»