1 May 2020 LearnSQL.com Team New SQL Monthly Challenge for 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 29 Apr 2020 LearnSQL.com Team SQL Course of the Month – Window Functions 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 29 Apr 2020 LearnSQL.com Team SQL Window Functions Cheat Sheet Unlock the full potential of SQL with our comprehensive Window Functions Cheat Sheet! This indispensable guide is designed to elevate your analytics capabilities and make complex data manipulations effortlessly accessible. Welcome to the ultimate resource for mastering SQL window functions - the SQL Window Functions Cheat Sheet! This invaluable resource provides you with the essential syntax, a comprehensive list of window functions, and real-life examples to enhance your SQL skills and analytics capabilities. Read more 22 Apr 2020 LearnSQL.com Team New SQL Monthly Challenge for April 2020! The new Monthly Challenge on LearnSQL.com is ready! In April, we invite you to test your SQL knowledge with data from another area of business: automobile repair. What is an SQL Challenge? It is a set of 5 to 10 SQL exercises, prepared for people who want to sharpen their SQL skills. Each challenge is centered around a specific theme. Do you like pizza? One of the challenges focuses on this miracle of Italian cuisine. Read more 20 Mar 2020 LearnSQL.com Team Stay at Home and Learn SQL for Free with LearnSQL.com Working remotely is a dream come true for some. You ditch commuting and have more time for the people you love and the things you enjoy. For others, it's a challenge to maintain their focus when there are new distractions. It's also an opportunity to invest the few gained hours in learning something new. Staying at home can be a time when you might find yourself busier than you've ever been, but not getting many things done, and worse, not learning what you planned to. Read more 4 Dec 2018 LearnSQL.com Team Practical Ways to Improve the Performance of SQL Queries Knowing how to improve SQL query performance is an important skill, especially when working with with large databases. In this article, you'll learn how to write more efficient SQL queries to get results faster. The biggest difference between SQL and other languages is that SQL is a non-procedural language. In a non-procedural language you specify the results that you need but not the methods used to get it. The advantage of a non-procedural language is that it is easier to write programs, therefore it is common for non-programmer business users to generate reports from SQL queries. Read more 21 Feb 2017 LearnSQL.com Team The Complete Beginner’s Guide to SQL Fundamentals LearnSQL.com is a great place to learn SQL. If you’re a complete beginner, it’s best to have an overview of what SQL is, what a database is, and how they work together. In this article, you’ll find a complete guide to SQL fundamentals. SQL Fundamentals: Database Let’s begin our guide to SQL with basic definitions. You might have already heard that SQL is used with databases. What exactly is a database? Read more «« « 1 2 3 … 9 10 » »»