SQL Track of the Season: SQL Fundamentals in PostgreSQL by Jakub Romanowski 7 Apr 2021 Are you ready for a new challenge this spring? Check out our SQL Track of the Season: SQL Fundamentals in PostgreSQL! In this article, we’ll answer common questions about this track. It’s getting warmer. The flowers are slowly beginning to bloom. This can mean only one thing – spring is here. The world is coming to life after its wintertime lethargy. This is a great time for new challenges. Do you want to add something to your skillset? Read more What Did the Easter Bunny Bring? Sweet Promotions for SQL Courses! by Jakub Romanowski 2 Apr 2021 It's already spring and Easter comes with it. This time of year, the world comes to life. Maybe it's time to awaken your hunger for learning? There is a perfect opportunity for that: at LearnSQL.com we have sweet promotions for you! If you've ever thought about working with databases, you've probably also come to the conclusion that you need to learn SQL. It is an industry standard that should be in the arsenal of every aspiring programmer, analyst, or entrepreneur. Read more Free SQL Course of the Month – Creating Basic SQL Reports by Jakub Romanowski 1 Apr 2021 Do you want to create good SQL reports from scratch? Are you looking for a course that will help you spread your analytical wings? What if I told you that throughout April 2021, you could access one of the best SQL Reports courses for FREE? Here it is: Creating Basic SQL Reports. What's the catch? There is none. LearnSQL.com provides one of their courses for free from time to time. Read more Where to Practice JOINs in MS SQL Server by Jakub Romanowski 30 Mar 2021 Are you tired of looking for exercises that will help you master SQL JOINs in MS SQL Server? Find out about an online course that will take your JOINs skills to the next level! There are tons of MS SQL Server courses out there. Some are good, although they often lack the most important thing ... the possibility of practicing what you learn with interactive exercises. This is one of the main reasons I advise people (especially beginners) not to learn SQL exclusively from YouTube clips. Read more Is MS SQL Server Still Worth Learning in 2021? by Jakub Romanowski 25 Mar 2021 There are some open-source database solutions for MS SQL Server. Some have more support from the online community, and others may run faster in certain situations. Nevertheless, MS SQL Server is still hot and is not going anywhere. Is it worth learning MS SQL Server in 2021? In this article, I will try to answer this question. Read on. What is MS SQL Server? Let's start with the basics. You've probably heard that MS SQL Server is a popular Relational Database Management System (RDBMS). Read more Want to Learn GROUP BY Extensions in PostgreSQL? You've Come to the Right Place! by Jakub Romanowski 18 Mar 2021 Do you want to take your knowledge of PostgreSQL to the next level? I have something for you: LearnSQL.com’s new GROUP BY Extensions in PostgreSQL course! It will help you get even more out of your data and create better reports and summaries. Fasten your seat belts and prepare to see what GROUP BY can do when it’s turbocharged. First, I have to confess something. I am not objective – I think PostgreSQL is the best and coolest SQL dialect. Read more Give Yourself the Green Light to Learn SQL by Jakub Romanowski 16 Mar 2021 Green and shamrocks everywhere and that can only mean one thing: St. Patrick's Day! Whether you are a native of Ireland or not, this is a great time to have some fun. However, when you wake up the next morning with a slight headache caused by too much intense ... céilí dancing, think about what is worth learning. We suggest SQL. This is a really good opportunity to learn the database language that is SQL. Read more Where Can I Find Good Courses to Practice MS SQL Server? by Jakub Romanowski 10 Mar 2021 You’ve got the basics of MS SQL Server. Where can you find practice exercises in this SQL dialect? You've started learning MS SQL Server. Maybe you've done a course, watched some YouTube tutorials, and feel pretty confident in your knowledge. What now? Let me tell you, you need to practice. Only by writing queries can you truly master SQL. In this article, I will show you where to find practice MS SQL Server exercises. Read more SQL Terms Beginners Should Know - Part 3 by Jakub Romanowski 24 Feb 2021 This is the third part of my list of essential SQL terms for beginners. In the first, you learned what tables, relational databases, and queries are. In the second part of the tutorial, I told you about aliases, SQL JOINs, primary keys, and subqueries. Now, it's time for more advanced database terms. But don't be afraid! I won’t crush you with scientific definitions. I will explain everything simply so that you can easily understand. Read more Which SQL Books Should You Read in 2021? by Jakub Romanowski 15 Feb 2021 Readers keep asking for books that I can recommend to complement our SQL courses. There are quite a lot of SQL books on the market, but only a few are worth your attention. See which SQL-related books to read in 2021. A while ago, I wrote an article about my favorite SQL books for 2020. I chose books about various aspects of working with databases with the goal of helping you get a clear picture of SQL in the real world. Read more «« « 1 2 3 … 5 » »»