25 Apr 2023 Alexandre Bruffa Learn SQL in 10 Minutes SQL, or Structured Query Language, is a programming language used to communicate with databases. With SQL, you can retrieve data from a database, insert new data, and update or delete existing data. You can even modify the structure of a database: you can add or delete tables or columns and change the relationships between tables. SQL is a standard, meaning it is a reference. Read about the history of the SQL standard in our article “The History of SQL Standards. Read more 16 Feb 2023 Alexandre Bruffa How to Concatenate Two Columns in SQL – A Detailed Guide In SQL, concatenation is the operation of joining together strings, or pieces of text information. Learn how to concatenate two columns in SQL with this detailed guide. SQL concatenation is the process of combining two or more character strings, columns, or expressions into a single string. For example, the concatenation of ‘Kate’, ‘ ’, and ‘Smith’ gives us ‘Kate Smith’. SQL concatenation can be used in a variety of situations where it is necessary to combine multiple strings into a single string. Read more 10 Jan 2023 Alexandre Bruffa Database Jobs to Choose in 2023 In this article, we will explore some of the top database jobs to choose from in 2023. So you want to land yourself a database job in 2023. It’s a great choice, and there are lots of options. Let’s talk about the most popular data-related jobs and what you need to do to get one. SQL Is Essential for a Database Job It’s important to mention that most of the popular databases nowadays are relational – i. Read more 27 Dec 2022 Alexandre Bruffa Learn Advanced SQL with LearnSQL.com In this article, we will propose a learning path that will cover advanced SQL topics. If you already know the basics of SQL, you probably have figured out that most online and offline SQL tutorials and courses usually cover the basic and intermediate concepts: SELECT, FROM, WHERE, ORDER BY, GROUP BY, and joining tables. Even university database courses typically don’t cover more advanced SQL topics. While this is enough SQL for most everyday tasks, there are some relatively new features that have been added to SQL in the last 20 years: window functions, recursive queries, and GROUP BY extensions (ROLLUP, CUBE, GROUPING SET). Read more 18 Nov 2022 Alexandre Bruffa I’m a Software Developer. How Do I Learn SQL? What do you need to know about relational databases and SQL as a software developer? In this article, we’ll explain the topics you need to know and how you can acquire this knowledge. If you are a software developer, you may have noticed that SQL skills are often required in some development roles. Although you are not a database manager or a data scientist, you will need solid SQL foundations to continue your developer journey. Read more 16 Aug 2022 Alexandre Bruffa PostgreSQL vs. MySQL: Is It Difficult to Switch? So you know PostgreSQL, but the boss has decided to switch to MySQL. What are the differences between these two SQL dialects? We discuss PostgreSQL vs. MySQL in this article. PostgreSQL has gained popularity in the last decade, and many developers and database specialists learned PostgreSQL as their first SQL dialect. But PostgreSQL is not the only relational database; during your IT career, you will probably be asked to use another SQL dialect – like MySQL. Read more 19 Jul 2022 Alexandre Bruffa I Already Know PostgreSQL. Is it Hard to Start Using MS SQL Server? What are the differences in PostgreSQL vs. MS SQL Server? We discuss the similarities and the differences between these two popular SQL dialects. Many of us developers and database specialists began working with free relational databases like PostgreSQL or MySQL for personal projects or small organizations. Some of us have since moved on to organizations using MS SQL Server and have had to learn to use the new tool. You may be wondering how challenging that is and whether you would struggle with SQL Server under similar circumstances. Read more