28 Sep 2020 LearnSQL.com Team New Course: Customer Behavior Analysis in SQL Good news! A new SQL course is here! We’re happy to announce the release of our Customer Behavior Analysis in SQL course. Do you want to get to know your clients and better understand their needs and behavior? If so, this great interactive SQL course is for you. Discover the power of full customer lifecycle analytics in SQL and know more than your competitors. The LearnSQL.com team is happy to announce the release of a new SQL course on our platform: Customer Behavior Analysis in SQL. Read more 25 Sep 2020 LearnSQL.com Team SQL Basics Cheat Sheet Download this 2-page SQL Basics Cheat Sheet in PDF or PNG format, print it out, and stick to your desk. The SQL Basics Cheat Sheet provides you with the syntax of all basics clauses, shows you how to write different conditions, and has examples. You can download this cheat sheet as follows: Download 2-page SQL Basics Cheat Sheet in PDF format (A4) Download 2-page SQL Basics Cheat Sheet in PDF format (Letter) Download 1-page SQL Basics Cheat Sheet in PDF format (A3) Download 1-page SQL Basics Cheat Sheet in PDF format (Ledger) Download SQL Basics Cheat Sheet in mobile-friendly PDF You may also read the contents here: Read more 25 Sep 2020 LearnSQL.com Team SQL JOIN Cheat Sheet Ready to master SQL JOINs? Get your downloadable cheat sheet now! Your shortcut to becoming an SQL JOINs expert is one click away. Dive deep into the world of SQL JOINs with our detailed SQL JOIN Cheat Sheet, a must-have resource for data enthusiasts at every level. Whether you are just starting out or looking to sharpen your skills, this guide is tailored to provide you with the quick reference needed to use SQL JOINs efficiently. Read more 1 Sep 2020 LearnSQL.com Team Course of the Month: Analyzing Revenue Trends in SQL We work hard, we learn SQL, and we develop professionally. But why? For our own satisfaction, but also for money! The knowledge of SQL will increase your income significantly. If you are proficient in SQL, you can better analyze your company's revenue. How? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo. In this article, she answers your questions about our September SQL Course of the Month: Analyzing Revenue Trends in SQL. Read more 4 Aug 2020 LearnSQL.com Team Course of the Month: Recursive Queries 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 22 Jul 2020 LearnSQL.com Team LearnSQL.com’s New Learning Path: Data Engineering 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 29 Apr 2020 LearnSQL.com Team 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 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 «« « 1 2 3 … 5 6 7 » »»