Tag: Extras How to Install PostgreSQL on Windows 10 in 5 Minutes Tags: extras get started guide learn sql Ignacio L. Bisso Ignacio is a database consultant from Buenos Aires, Argentina. He’s worked for 15 years as a database consultant for IT companies like Informix and IBM. These days, he teaches databases at Sarmiento University and works as a PostgreSQL independent SQL consultant. A proud father of four kids with 54 years in his backpack, Ignacio plays soccer every Saturday afternoon, enjoying every match as if it’s his last one. 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: Our Picks for 2020’s 7 Best Online SQL Schools Tags: data analysis extras get started learn sql SQL basics SQL rank Dorota Wdzięczna Data Science Writer @ Vertabelo 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. Essential SQL Terms to Know for Beginners and Pros Tags: extras how to in sql SQL basics Aldo Zelen Aldo is a data architect with a passion for the cloud. From leading a team of data professionals to coding a data warehouse in the cloud, Aldo has experience with the whole lifecycle of data-intensive projects. Aldo spends his free time forecasting geopolitical events in forecasting tournaments. Working with databases can seem daunting to a non-technical person. Right away, you’re bombarded with new terms that make your head spin. Database, database instance, table, SQL and others are some of the basic terms that you need to understand just to have a normal conversation with your technical colleagues. In this article, we’ll explore some basic SQL database terminology you need to know to succeed. Imagine you’re attending a meeting with the development staff and suddenly feel as if you’re listening to white noise. 15 Best SQL Articles for Beginners Published in 2017 Tags: extras SQL basics Dorota Wdzięczna Data Science Writer @ Vertabelo For this post, I’ve gathered 15 of the most interesting SQL articles published in 2017. If you’re looking for articles on SQL for beginners, want to learn more about databases and SQL queries, or just expand your knowledge of SQL, this article is perfect for you. Let’s dive right in! Top 3 Vertabelo Academy Articles I’ll start off the list with three of the most popular Vertabelo Academy SQL articles. How to Draw a Christmas Tree in SQL Tags: common table expressions CTE extras recursive queries SQL basics sql string functions WITH Aldo Zelen Aldo is a data architect with a passion for the cloud. From leading a team of data professionals to coding a data warehouse in the cloud, Aldo has experience with the whole lifecycle of data-intensive projects. Aldo spends his free time forecasting geopolitical events in forecasting tournaments. You can use SQL to manipulate all kinds of data, from huge analytical queries to brief single-purpose statements. But you can also use SQL just for fun, without any business requirements stifling your creativity. So, get out your jolly hat and prepare to sing O Christmas Tree as we create some quirky art with plain old SQL. Today, we’re going to generate some holiday-themed ASCII art, just for fun. That’s right. SQL Hacks To Control Family Budget On Black Friday Weekend Tags: data analysis extras GROUP BY how to in sql join reporting with SQL SQL basics Dorota Wdzięczna Data Science Writer @ Vertabelo If you’re in the US, chances are you’ve been eagerly awaiting the approach of Black Friday just as much as Thanksgiving. Though the shopping frenzy takes hold of nearly everyone, some people have to stick to their budgets and shop prudently. In this article, we’ll take a look at how generating an SQL report can help you track how much your family spent shopping on Black Friday. Storing Black Friday Purchases in a Database Before we can create an SQL report, we first need some data we can use. What Is Vertabelo’s SQL Cheat Sheet? Tags: extras SQL basics Dorota Wdzięczna Data Science Writer @ Vertabelo Everyone, from rookie programmers to SQL ninjas, needs a bit of help now and again. Enter Vertabelo's SQL Cheat Sheet! Working with databases is hard. There's a lot of data to manage, which can be daunting. But the main challenge many database users face is the SQL commands themselves. It's all right when you're using the same familiar ones day after day, but what about the commands you dust off once or twice a year? The 5 Highest Paying Jobs That Use SQL Tags: extras how to in sql SQL job market Marek Pankowski IT provides a wide and growing job market, offering many excellent opportunities in both career development and earning potential. Today we’ll take a look at several very interesting types of database jobs that use SQL. Every year, many in the work force set their sights and aim for new and better jobs. When it comes to jobs, “better” means different things to different people, but earning potential is almost always a top priority. SQL Mythbuster – 5 Reasons Why No One Should Be Afraid of SQL Tags: eLearning extras get started how to in sql SQL basics Kamila Ostrowska Learning Project Manager Anyone can learn SQL. It’s not as hard as you think! 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. Let me tell you my own story. A few years ago, I wasn’t considering learning SQL or anything else that I labelled “technical”. My background is in sociology, journalism, and scriptwriting, and I thought computer languages were pretty sci-fi. 5 Books That Will Grow Your SQL Skills Tags: book review extras get started SQL basics Aldo Zelen Aldo is a data architect with a passion for the cloud. From leading a team of data professionals to coding a data warehouse in the cloud, Aldo has experience with the whole lifecycle of data-intensive projects. Aldo spends his free time forecasting geopolitical events in forecasting tournaments. 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. Should I Learn SQL? 4 Convincing Reasons Tags: extras Magdalena Brych There are 250+ computer programming languages in popular use. Why should you learn SQL, or Structured Query Language? Why Should You Learn SQL? Why learn SQL? To answer this question, you should start with reflecting on your professional life. Are you interested in boosting your career? Wondering what skills are worth investing in? If you’re currently in your dream job, still searching for it, or even thinking about starting your own business, it pays to develop your technical skills.