26 Mar 2021 Dorota Wdzięczna How to Install Microsoft SQL Server 2019 and SQL Server Management Studio Do you want to install SQL Server 2019 on your Windows PC? How about the latest version of SQL Server Management Studio? I’ll walk you through the process. Soon you’ll be writing T-SQL queries and operating on SQL Server databases! As I write this article, Microsoft SQL Server 2019 is the latest version of SQL Server. It’s the 15th version of one of the most popular database servers in the world. Read more 15 Nov 2019 Jakub Romanowski Join us on Facebook–We Can Learn More Together We are so happy that you have joined us to learn and develop your SQL skills! We want to invite you to a new Facebook group, We Learn SQL. It is a great place for anyone interested in meeting like-minded people who also want to learn about database-related concepts. Learning together is easier, don't you think? Joining this group is a great opportunity to begin sharing your learning experiences with others. Read more 30 Jul 2019 Jakub Romanowski YouTube Tutorials That Actually Teach You Some SQL YouTube is not just funny cats, music clips, and viral videos. It can also be a mine of knowledge – if you know where to look. Can YouTube tutorials really help you learn SQL? Let's say you're a marketer or an accountant. You work with databases every day. But when it’s time to write a query and get specific data, you need to call someone from IT. Why not learn to do it yourself? Read more 2 Jul 2019 Tihomir Babic Career Change: From Accountant to Database Designer How do career changes and life choices impact our future? Can we change the path that's been set for us? And if so, where do we begin? I wouldn't blame you if you thought this article is about change. In a sense, it is—it's in the title, after all. But for me, this article is more about what remains constant. If somebody were to ask me what hasn't changed for me since my childhood, I would know the answer immediately: curiosity. Read more 15 Apr 2019 Adrian Więch Forget About Excel, High Five With SQL Find out why you should forget about Excel and start using SQL even if you're not an IT expert. We'll show you how easy it is to learn SQL, how it can make you work better, and how LearnSQL.com makes the learning process fun. "I Don't Deal With Data" We frequently hear the sentence above from people outside the IT industry. Well, it's not entirely true. Data is now almost everywhere. Read more 7 Feb 2019 Ignacio L. Bisso A Non-Technical Introduction to Learning SQL on Your Lunch Break Do you think learning SQL will help you in your career? You are right. SQL is one of the easiest computer languages to learn. These days many non-IT employees have SQL skills and use them to extend their professional capacity. Moreover, more and more companies are encouraging their employees in non-IT areas (like sales, advertising, and finances) to learn and use SQL. One of the benefits of empowering employees with SQL skills is that once you answer one data question, the results will generate a new data question, and then perhaps a cascade of further data questions. Read more 15 Nov 2018 Ignacio L. Bisso How to Install PostgreSQL on Windows 10 in 5 Minutes It may look like a complicated task to install PostgreSQL, Oracle, or SQL Server or any other database software, but it really isn’t! These days, most relational database management systems come with installation wizards that make the process much simpler. In this article, we’ll look at how to install PostgreSQL and test that the installation is working. Install PostgreSQL: Steps Involved To install PostgreSQL, we’ll complete the following tasks: Read more 12 Oct 2018 Aldo Zelen How SQL supports data-driven organization Typical business users make decisions based on gut feelings, but this can't get them so far. In this article, we'll look at how learning to write basic SQL queries helps your company become a data-driven organization. Businesses face many decisions. Do we increase our advertising budget in one region or the other? Are certain products selling quickly enough? What we should do if they aren't? Most of these decisions are driven by intuition, but organizations that make the most business impact use data-driven decision-making. Read more 8 Oct 2018 Dorota Wdzięczna Microsoft SQL Server 2017 Installation Step by Step Microsoft SQL Server is one of the most popular professional database servers on the market. In this guide, I’ll show you all SQL Server 2017 installation steps to help you install it on the Windows operating system together with SQL Management Studio. If you want to learn T-SQL, the dialect of SQL used in SQL Server, check out our SQL from A to Z in MS SQL Server track. Read more 27 Sep 2018 Ignacio L. Bisso How to Begin Running SQL Queries In this article, I’ll explain how to run a SQL query to help you execute your first one. Let’s jump right in! Running SQL queries for the first time is not a complex task, but it can seem intimidating at first if you’re a complete beginner. But once you get past that initial roadblock, you’ll be able to focus on learning SQL and writing more interesting queries to meet your business needs. Read more 31 Jul 2018 Aldo Zelen How to Use a SQL Wildcard SQL wildcard allows us to filter data matching certain patterns in SQL. We use SQL wildcards with the LIKE operator in the WHERE clause of a query to filter data. In this beginner’s article, we’ll look at everything you need to know about basic SQL wildcards. If you like playing cards, then you know that wildcards can substitute any other card in your deck. Similarly, SQL wildcards can substitute one or more characters. Read more 24 Jul 2018 Dorota Wdzięczna Our Picks for 2020’s 7 Best Online SQL Schools If you’re looking for the best online SQL courses but aren’t sure where to start, you’re in the right place. I evaluated the top 7 ranked SQL schools available online to help you find the right solution. While summer is a great time to relax and get away from work, it’s also an excellent opportunity to learn new skills – like SQL! Thanks to SQL schools putting their courses on the internet, learning new tech skills is super easy and you can choose from a variety of formats to suit your needs. Read more 6 Jul 2018 Kate Stolarek Why Learn SQL Over the Summer Think summer is reserved for flying to warm places and hanging out at the beach? Sure! But it's also a great time to learn new skills that you haven't had time for. If you recently graduated from high school and want to get a head start on computer programming for college, learning SQL over the summer is a great opportunity. You have nothing to lose and everything to gain—SQL is actually really easy to learn, especially with so much free time over the summer. Read more 2 Mar 2018 Kate Stolarek Here’s Why You Should Learn SQL Why learn SQL? We asked our users about it. This is what we’ve learned. At LearnSQL.com, we help people with no computer science background to understand the core concepts of databases and data science. For example, we teach users how to extract the most important data from a database to build simple reports and how to understand key statistical metrics in data analysis. We love to provide easy-to-understand examples that thoroughly depict complex technical concepts. Read more 27 Feb 2018 Jeffrey Edison How to Start Thinking in SQL Thinking in SQL will help you understand what SQL queries do, how to create and change them, and how to create reports from the data you obtain. If you want to know how to write better SQL queries, you have to change the way you think about the code. One of the greatest skills you can have in SQL programming is the ability to change an existing SQL query so you get the results you need. Read more 13 Nov 2017 Aldo Zelen Introduction to Reporting with SQL — the Ultimate Tutorial for Business Professionals Working with the financial aspects of large and small enterprises can be a daunting task for a business professional. In this article, we'll look at several ways of constructing the perfect SQL report. You've probably already heard about SQL from your colleagues or in other areas of your career. If you're here, you've likely concluded that learning SQL will make your professional life easier – and you're right! Read more 9 Nov 2017 Alex Briggs 5 Great Benefits of Learning SQL If you want your business to succeed in 2017, it’s absolutely critical that you understand your data; this is why you should get acquainted with SQL ASAP. But there are other reasons to learn it that may not be obvious. In this article, I’ll show you 5 huge benefits of learning SQL! Don’t fall for the common trap—analyzing data isn’t just a concern for those competing at national or corporate levels. Read more 21 Oct 2017 Dorota Wdzięczna Why Is SQL Worth Learning? Nowadays, data is gathered from a variety of sources, and information is of great value to organizations. However, with an increasing amount of data comes the need for databases that can store information for retrieval and analysis by trained specialists. That’s where Structured Query Language comes in. Is SQL worth learning? In this article, I’ll explain why it definitely is. Relational databases, which logically group information into chunks, are basically used to store and organize large amounts of data. Read more 21 Aug 2017 Kamila Ostrowska 5 Reasons Why No One Should Be Afraid to Learn SQL Think SQL is just for tech experts? Think again. In this article, we'll bust some common myths and show you that anyone can learn SQL. Let's dive in and make SQL simple. In today’s world, even those in non-technical jobs need some technical skills. And you don’t have to be a hard-core nerd to get these skills. Everywhere you look, from marketing to management, a touch of tech knowledge can set you apart. Read more 4 Apr 2017 Aldo Zelen 5 Books That Will Grow Your SQL Skills Which books will help you build your database skills? We look at five awesome SQL books. There’s a common saying that “all wise men read books”. I would say that all professionals read books – particularly those related to their field. There are many books about databases and SQL; most are tied to specific vendors (DB2, Oracle, MS SQL) but there are also plenty that are vendor-neutral. In this article, I’m going to review a few books that I would recommend to SQL learners at various levels of proficiency. Read more 21 Feb 2017 LearnSQL.com Team The Complete Beginner’s Guide to SQL Fundamentals LearnSQL.com is a great place to learn SQL. If you’re a complete beginner, it’s best to have an overview of what SQL is, what a database is, and how they work together. In this article, you’ll find a complete guide to SQL fundamentals. SQL Fundamentals: Database Let’s begin our guide to SQL with basic definitions. You might have already heard that SQL is used with databases. What exactly is a database? Read more 13 Dec 2016 Aldo Zelen How to Learn SQL: 6 Ideas for Newbies Learning a new skill can be a daunting task, especially in programming. SQL is not immune to this. Luckily, with the Internet and the explosion of programming-related information out there, there are a lot of options you can use to undergo your SQL training! But we then come to a new roadblock. Where to begin? How will we know which option is best for our budget, skill level, and schedule? Read more