5 Oct 2021 Kamila Ostrowska Best Places to Practice SQL JOINs Online You’ve just started your journey with SQL and you’re not sure what a JOIN is or where to use it. Don’t worry! In this article, you will find out what JOINs are and where you can practice them online. If you have just started learning SQL, you have a lot of topics to cover before you can call yourself a data professional. If you are serious about using SQL, you’ll have to understand JOIN – what it does, when you can use it, and what its different variants do. Read more 9 Jul 2021 Kamila Ostrowska Best SQL Certifications for Leveling up Your Career Career If you want to build and strengthen your position in the IT industry, you should look into these SQL certifications. We always encourage you to learn, to gather new skills and experience. Training is really important; without it, you will not make much progress if you want to advance in IT or specifically in the SQL industry. That said, you also need something that can validate your competencies, like SQL certifications. Read more 17 Jun 2021 Kamila Ostrowska SQL Terms Beginners Should Know - Part 4 Here it is – another batch of must-know SQL terms. In the first two parts, we covered tables, relational databases, queries, aliases, SQL JOINs, primary keys, and subqueries. Last time, we moved to more advanced terms like INSERT INTO, GROUP BY, and HAVING. Are you ready to dive deeper into SQL terminology? This is the fourth installment of our series on basic SQL terms for beginners (and everyone else). Don’t worry if you missed the previous articles; you can find Part 1 (essential SQL terms), Part 2, and Part 3 in our blog. Read more 12 May 2021 Kamila Ostrowska The Best Books for Data Engineers Are you tired of staring at a computer all day? Maybe it’s time to read a book. Take a moment to check out our list of recommended books for data engineers. They will help you deepen your knowledge about databases. Last year, we shared a list of the best books to learn SQL. This time, I want to introduce five books for data engineers. They are worth reading and will help you learn more about databases. Read more 14 Apr 2021 Kamila Ostrowska Who Should Learn SQL? If you learn SQL, will you use it in your current (or dream) job? If you learn it, will it help you with your daily tasks? SQL has so much potential that everyone can benefit from it – including you! Read this article to find out how much you will gain by knowing SQL. I could answer the title question with one word: everyone! But not everyone wants to learn SQL. Read more 23 Mar 2021 Kamila Ostrowska Best SQL IDEs for You in 2021 Maybe you just started learning SQL. Maybe you already have some experience. Whatever your situation is, choosing the right IDE for you is another step in your development. Why IDE? IDE stands for integrated development environment. It is a software application that enables us to combine various aspects of writing a computer program. An IDE usually contains a source code editor, build automation tools, and a debugger. You might ask why you need an IDE when you have the command line available on your computer. Read more 18 Feb 2021 Kamila Ostrowska How to Practice PostgreSQL Online PostgreSQL is hot right now!If you want to join a community of people passionate about data, this open-source database system is something you need to try. Like everything we teach on LearnSQL.com, PostgreSQL requires practice. To profit from Postgres – as this dialect is sometimes called – you need to start with the basics. You can watch some tutorials on YouTube or read articles to get to know what a Database Management System (DBMS) is. Read more 24 Dec 2020 Kamila Ostrowska How to Practice SQL with LearnSQL.com Practicing new skills online needs motivation and self-discipline, but it’s worth it. We’re facing a difficult, uncertain time. On one hand, the COVID pandemic caused a lot of fear. What will happen in the future? Will I keep my job? Will we stay safe and healthy? On the other hand, COVID is giving us a lot of time. Working remotely, not having anything to do but stay home and… And what? Read more 13 Nov 2020 Kamila Ostrowska Practice SQL Before Interviewing a Potential Employee Has your company grown to the point that you need to hire an SQL expert? Have you found a candidate for the job? How do you prepare for the interview, especially if you don’t know SQL? Don't worry! Follow our suggestions on how to practice SQL. We have tips and tricks to help you feel confident and find the perfect employee. Who You Want To Hire First of all, you need to know the requirements for the new employee. Read more 30 Sep 2020 Kamila Ostrowska How Will Learning SQL Make You a Better Boss? Want to improve the performance of your team, of your own, of your department, or of your entire company? Try SQL! Why should you learn SQL? Because it just pays off! What does learning SQL and being a better boss have to do with each other? Being a better manager can make your employees happier while growing your business. When employees feel a sense of fulfillment, they are more motivated to do well. Read more «« « 1 2 » »»