-
Understanding JOIN Clauses in SQL
In a previous article, I demonstrated how we can manipulate and retrieve data from any single table in our database, which covers a wide range of uses. However, this leaves out some of the most important functionality of a relational database – the ability to work with data across multiple tables. JOIN clauses are the […]
-
Working with JSON in PostgreSQL
Structured Query Language (SQL) is an excellent tool when working with a database that follows a traditional relational model – one that contains data that is organized into structured tables with fixed schema and established relationships. However, things have the potential to break down when introducing unstructured data into the mix. Doing so requires careful […]
-
Manipulating and Querying Data with SQL
The biggest draw to learning SQL is the ability to query and manipulate data in complex ways in order to serve the needs of any application. In this article, I’ll be discussing some of the most important statements and clauses in SQL. I’ll begin by explaining how we can fill the example table we constructed […]
-
SQL Database Structure
In this article, I’ll be discussing the building blocks that make up databases and give them their important attributes. To do so, we will be working further with our example database “test_database”, which we created in this previous article. General Structure Databases are potentially enormous collections of data, intended to be made easily available to […]
-
Introduction to Databases and SQL
Since I started developing software professionally, SQL has proven itself to be one of the most valuable tools in my toolbox. The versatility of the language makes learning it one of the most effective uses of time I can think of. Without a doubt, it’s something that I feel every programmer should be familiar with. […]
