learnstuff logo

SQL

Structured Query Language is the most common element of almost any application developed in our time. Regardless of the nature of the application companies have always found value in storing information. own it is application data, user provided values, statistics, reports or user credentials there is always the need to be able to store, read and manipulate information.
Learn how to create your own database and tables, modify their structure and perform CRUD (create, read, update, delete) operations using SQL.
  • 1
    Introduction to SQL
    About: Learn what SQL is and how to use it. Understand what a RDBMS and what it is used for. Get familiarized with terms and their meaning; understand how to create tables, how to identify in an unique way entries in a table and how to create relations between different table entries.
    Requirements: PostgreSQL, MySQL or any other Database Server
  • 2
    SQL functions and aggregators
    About: Learn the tools, functions and aggregators SQL provides in order to enrich the query language. Learn how to perform SQL CRUD operations (create, read, update, delete) and the multitude of features SQL provides to ensure you only select exactly the information you need.
    Requirements: PostgreSQL, MySQL or any other Database Server
  • 3
    Advanced SQL
    About: Learn advanced techniques for extracting the required information out of the relations you built with the knowledge you have gained so far. Understand Unions and the various types of Joins how they work and when they should be used.
    Requirements: PostgreSQL, MySQL or any other Database Server