Tag: sql

  • Understanding JOIN Clauses in SQL

    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 […]

    Continue Reading

  • Working with JSON in PostgreSQL

    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 […]

    Continue Reading

  • Manipulating and Querying Data with SQL

    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 […]

    Continue Reading

  • SQL Database Structure

    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 […]

    Continue Reading

  • Introduction to Databases and SQL

    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. […]

    Continue Reading