6 May 2021 Jakub Romanowski Want to Work With Data? Learn SQL! Are you looking for a database job? How are things working out? If you don't know what to do, I suggest you start by learning SQL. Here’s why. In this article, I’ll explain how you can succeed at finding a database job. If you are tired of your current job and fed up with your boss (who hasn't given you a raise in years), read on. Stay with me too if one more stupid Zoom call will make you scream. Read more 1 Apr 2021 Jakub Romanowski Course of the Month: Creating Basic SQL Reports 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 25 Mar 2021 Jakub Romanowski Is MS SQL Server Still Worth Learning in 2024? MS SQL Server is an in-demand skill in today’s job market. Should you learn MS SQL Server in 2024? In this article, I’ll answer this question. Thinking about whether you should dive into Microsoft SQL Server in 2024 – especially with so many free database alternatives available? MS SQL Server has been a go-to for handling data for ages, thanks to its solid features and reliability. But now, with a bunch of new options on the block, some people wonder if it's still the champ. Read more 18 Mar 2021 Jakub Romanowski New SQL Course: GROUP BY Extensions in PostgreSQL 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 10 Mar 2021 Jakub Romanowski Where Can I Find Good Courses to Practice MS SQL Server? Begin your journey to mastering MS SQL Server with the finest practice exercises out there. Whether you are a beginner or seeking to improve your T-SQL skills, explore the top destinations for the most engaging and interactive MS SQL practice courses online. 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. Read more 24 Feb 2021 Jakub Romanowski SQL Terms Beginners Should Know - Part 3 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 5 Feb 2021 Jakub Romanowski How to Import CSVs to PostgreSQL Using PgAdmin Do you work with data and use CSV files? Here is a practical guide on how to import a CSV file into a PostgreSQL database using pgAdmin, one of the best PostgreSQL editors on the market. Let's get right into importing CSVs into a Postgres database. We’ll start by explaining what a CSV file is, then we’ll introduce you to pgAdmin and show you how to do the import process. Read more 20 Jan 2021 Jakub Romanowski Stories of the LearnSQL Scholarship Program 2020 is behind us. It was an extremely difficult year: We’ve struggled with the Covid-19 pandemic, a worldwide economic crisis, and constant anxiety. Many people have lost their jobs and their prospects for a better tomorrow. That's why we decided to do something positive: establishing a SQL scholarship program. We decided to find people in difficult situations and try to help them. For many, learning SQL can be their chance to get a job and develop their career. Read more 12 Jan 2021 Jakub Romanowski Best SQL Video Tutorials for 2021 Ready for this year’s picks for the best YouTube SQL video tutorials? Here are our top 5 choices! It's been well over a year since I last wrote about SQL tutorials on YouTube. Those seven channels can help you learn the basics of SQL quite painlessly, but now it's time to add to that list with 2021’s top contenders. Which YouTube SQL tutorials are worth your time and attention? I’ve got my favorites, but first, let’s consider an important question: Read more 17 Dec 2020 Jakub Romanowski The Best SQL Lectures on YouTube YouTube contains a vast amount of information. The trick is to know how to find what’s valuable. If you type “SQL lectures” in the YouTube search engine, you will probably get a list of boring or unhelpful clips. However, there are hidden gems, and I’ve compiled a list of the best SQL talks I’ve found on YouTube so far. First, let's establish one thing. I didn't choose any YouTube SQL tutorials when making this list. Read more «« « 1 2 3 … 8 9 10 … 12 » »»