Extras

Rebecca McKeown

SQL INSERT, SQL UPDATE, SQL DELETE – Oh My!

Need to understand SQL INSERT, UPDATE, or DELETE? We'll get you up to speed with a comprehensive How-To and useful examples! SQL INSERT, UPDATE, and DELETE statements—what are they all about? If you're a data engineer, a database administrator, or even just your average data fanboy or girl, one day you're going to find yourself with a database that becomes your "baby." Charged with this special bundle of joy, you're going to need to feed and change the little fella.

Jakub Romanowski

SQL, Databases, and Hollywood Movies

Policemen, doctors, lawyers, scientists, teachers: These are the professions that we often see in Hollywood movies. But are movies also trying to show what the work of data analysts looks like? Here is a list of six movies in which screenwriters, directors, and producers decided to cast SQL and databases in the main roles. Data analysis is most often associated with business, reporting, and making key decisions for the company.

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.

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.

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:

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.

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.

Aldo Zelen

Essential SQL Terms to Know for Beginners and Pros

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.

Dorota Wdzięczna

15 Best SQL Articles for Beginners Published in 2017

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.

Aldo Zelen

How to Draw a Christmas Tree in SQL

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.

Dorota Wdzięczna

SQL Hacks To Control Family Budget On Black Friday Weekend

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.

Dorota Wdzięczna

What Is Vertabelo’s SQL Cheat Sheet?

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?

Marek Pankowski

The 5 Highest Paying Jobs That Use SQL

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.

Kamila Ostrowska

SQL Mythbuster – 5 Reasons Why No One Should Be Afraid of SQL

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.

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.

Magdalena Brych

Should I Learn SQL? 4 Convincing Reasons

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.