3 Jan 2020 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. Read more 24 Dec 2019 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. 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 Updated on: May 4, 2024 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. 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 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 17 Apr 2018 Aldo Zelen Essential SQL Terms to Know for Beginners and Pros Updated on: April 11, 2024 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. Read more 21 Dec 2017 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. Read more 23 Nov 2017 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. Read more 6 Sep 2017 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. Read more 21 Aug 2017 Kamila Ostrowska 5 Reasons Why No One Should Be Afraid to Learn SQL Updated on: September 17, 2023 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 Updated on: April 18, 2024 Looking to take your database skills up a notch? I've spent some time digging into various resources, and I want to share five advanced SQL books that really stood out. These texts are not just about learning the basics: they're about mastering the intricacies of SQL and truly enhancing your database management prowess. Whether you're troubleshooting complex queries or optimizing performance, these books provide insights that are both practical and transformative. Read more