Two ways to access this course

  • $50.00

    Relational Databases and SQL

    One time purchase to buy this course and keep it as yours forever
    Buy Now

  • $8.99 / month

    All Access Pass

    Monthly subscription that unlocks this and every other course on this site as a member. Binge away to your heart's content!
    Subscribe

Master the Essentials

RDBMS and SQL for Backend Engineers

The nitty-gritty of Relational Databases and SQL can seem foreign for backend engineers who often find themselves interacting with databases only occasionally. This course is designed specifically for you, offering a clear, structured, and essential roundup of the most important aspects of RDBMS and SQL.

Backend engineers don't need to be database gurus. But with this course, you will walk away with the confidence to connect to databases, run essential SQL queries, and understand the intricacies of relational data management. This course is your pragmatic guide to the world of RDBMS and SQL.

Course outcomes

After watching this course, you will gain...

  • A clear understanding of the features and benefits of relational databases

  • Proficiency in essential SQL commands and their real-world applications

  • Text length of individual points can be shorter or longer depending on your needs

  • Hands-on experience with creating, manipulating, and optimizing SQL tables

  • Mastery over database operations like joins, subqueries, and transactions

  • Knowledge to optimize your database queries and understand the logic behind them

Course curriculum

    1. Introduction and the relational model

      FREE PREVIEW

    2. Features of a relational database

    3. Introduction to SQL

    4. Types of SQL

    5. MySQL and starter data setup

    6. The SQL "Hello World"

    1. SQL Data Types

    2. Data definition language

    3. Table creation walkthrough

    4. Creating a table hands on

    5. Data manipulation language

    6. Data manipulation language hands on

    1. Understanding NULL in SQL

    2. Query clauses

    3. SQL evaluation order explained

    4. SQL table types

    5. Views

    6. Group by and order by

    1. Data Control Language overview

    2. Foreign key

    3. Joins

    4. Inner and Outer Joins

    5. Joins on derived queries

    6. Subqueries and nested queries

    1. Understanding SQL Indexes

    2. SQL triggers

    3. Query optimization with EXPLAIN

    4. DB Security essentials for developers

    5. Transactions

    6. Lock granularities

    1. Conclusion

About this course

  • $50.00
  • 31 lessons
  • 3.5 hours of video content

Discover your potential, starting today

Join to access this and every other course on this site!

Get started now