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 such files 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. Don’t worry – it’s easy! 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 29 Dec 2020 Jakub Romanowski 2020’s Best LearnSQL.com Articles We published a whole lot of interesting SQL articles this year. I had a difficult task – choosing the best LearnSQL.com articles of 2020. And here they are. The crazy year of 2020 is coming to an end. How will we remember it? Probably by the COVID-19 pandemic; we stayed home and fought the virus. It was a difficult time. However, many of us did not give up and kept trying to achieve our professional goals. 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 4 Dec 2020 Jakub Romanowski SQL Terms Beginners Should Know – Part 2 This is the second part of my list of essential SQL terms for beginners. In the first, you learned what a table, relational database, and query are. 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. If you want to review the basic SQL terms, see my previous article, SQL Terms Beginners Should Know. Read more 24 Nov 2020 Jakub Romanowski SQL in the Open-Source World Did you know there are free, open-source databases that use SQL? In this article, I'll show you which open-source database solutions can meet your needs. Ever wonder why many people still use paid programs when the same things can be done with free options? Personally, I am an avid supporter of the open-source movement. For years, I have been trying to apply and promote such solutions and support an active community around them. Read more 10 Nov 2020 Jakub Romanowski SQL Terms Beginners Should Know Have you started learning SQL? Do you feel a little lost in the maze of new words and ideas? Here’s a list of 10 absolutely essential SQL terms for beginners. When you start learning SQL, there’s a lot to process. And some of it – even basic SQL terms – gets lost in the shuffle. If this sounds like you, bookmark this article; it will be a handy reference. Read more 4 Nov 2020 Jakub Romanowski Kickstart SQL Learning with Our SQL Basics Course Updated on: February 19, 2024 Why learn SQL from our interactive online courses? Two reasons: 1) Power up your career. 2) Avoid being a noob. What does it mean to be a noob? “Noob” comes to us from the world of computer games. It’s a combination of “newbie” and “beginner”. It’s not a very nice word. It means that someone has found you an inexperienced player and (even worse) resistant to learning. Read more «« « 1 2 3 … 7 8 9 … 11 » »»