Introduction to Databases and SQL

Introduction to Databases and SQL, Learn the Fundamentals of Relational Databases and the SQL Programming Language!

SQL is the most commonly used programming language for database management. In this course, I will introduce you to the core concepts of SQL and show you how to store, query, and manipulate data with SQL. You will learn how to request, edit and delete data from a relational database, how to filter, order, limit, aggregate, and group your results, and join multiple tables.

By the end of this course, you will have a solid understanding of the key functions of SQL and relational databases in general.

Course structure

The course is divided into 4 main sections, each focussing on a different aspect of databases and SQL. Every section consists out of a couple easy to follow videos, showing you hands-on examples of the material, and more than enough practice assignments and coding exercises. To practice with the materials, there is no installation or setup required. The course ends with an exam that allows you to test yourself on all discussed topics and see which topic you need to put some extra time in.

Topics

The following topics will be discussed:

• Section 1
  • Relational Database
  • Primary Key
  • Foreign Key
  • Entity-Relationship (E/R) Diagram
  • Cardinality
• Section 2
  • Creating tables (CREATE TABLE)
  • Inserting data (INSERT INTO, VALUES)
  • Basic select query (SELECT FROM)
  • Query all data (* )
  • Query unique values (DISTINCT)
  • Conditions (WHERE, AND, OR)
  • IN and NOT IN
  • Sorting results (ORDER BY ASC/DESC)
  • Aggregate functions (COUNT, AVG, MAX, MIN, SUM)
  • Grouping results (GROUP BY)
• Section 3
  • Joining multiple tables (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)
  • Using an alias (AS)
  • Limiting results (LIMIT)
  • Editing data (UPDATE)
  • Deleting data (DELETE)
  • Nested query (SELECT IN SELECT)
  • Combining results (UNION, UNION ALL)
• Section 4
  • Summary
  • Final exam