Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
RDBMS & SQL: Fundamentals for Backend Developers
Rating: 4.3 out of 5(4 ratings)
24 students

RDBMS & SQL: Fundamentals for Backend Developers

RDBMS & SQL mastery, joins, and transactions for secure data
Created byJava Brains
Last updated 3/2025
English

What you'll learn

  • Grasp the relational model, ACID guarantees, and SQL’s edge for data integrity.
  • Install and configure MySQL, then practice with real-world data sets.
  • Get hands-on with DDL, DML, DCL, and TCL for complete database control.
  • Build robust tables, define keys, and handle diverse SQL data types.
  • Use SELECT, INSERT, UPDATE, DELETE, and manage NULL values effectively.
  • Master advanced clauses—GROUP BY, HAVING, ORDER BY—and harness subqueries.
  • Link tables using joins (inner, outer) and foreign keys for data relationships.
  • Optimize performance with indexes, EXPLAIN, and targeted query tuning.
  • Secure databases via user permissions, parameterized queries, and safe passwords.
  • Implement transactions, lock granularities, and rollback for fail-safe operations.
  • Automate logic and enforce rules with triggers to streamline application logic.
  • Leverage views, temporary tables, and derived queries for cleaner data retrieval.

Course content

6 sections • 31 lectures • 3h 20m total length

  • Introduction and the relational model18:08
  • Features of a relational database7:27

    Explore the relational model proposed by Dr. Codd, where data sits in tables linked by primary and foreign keys, and sql manages integrity and efficient joins.

  • Introduction to SQL1:59

    Explore SQL as the universal language for relational databases across RDBMS like Oracle, Microsoft SQL, MySQL, and Postgres, and its use with some NoSQL systems.

  • Types of SQL3:25
  • MySQL and starter data setup9:12
  • The SQL "Hello World"1:58

    See SQL hello world as a simple select that returns a table; the column hello world and its value illustrate a dml concept, with now returning the current time.

Requirements

  • Basic programming knowledge (any language)
  • Familiarity with the command line (optional but helpful)
  • A computer with MySQL installed or the ability to install it
  • Willingness to practice SQL commands regularly

Description

Are you preparing for a backend developer role or gearing up for a crucial technical interview? This comprehensive course will guide you through the world of Relational Database Management Systems (RDBMS) and Structured Query Language (SQL) from the ground up. You’ll learn how to design scalable, secure databases and master fundamental SQL commands while exploring real-world use cases and hands-on exercises.

From table creation and data manipulation to advanced topics like subqueries and joins, this course provides a structured approach that will help you confidently work with relational databases. You’ll see how key components such as primary and foreign keys maintain data integrity, discover the power of transactions and locks for multi-user environments, and learn how to optimize queries with indexing and the EXPLAIN keyword to boost performance.

By the end of this journey, you’ll be able to build robust databases, write optimized queries, manage user privileges with Data Control Language (DCL), and implement secure best practices against common vulnerabilities. We’ll also dig into triggers, views, and transaction control, giving you a complete toolbox for tackling complex data challenges in any production environment.

Whether you’re brushing up on SQL for an upcoming interview or looking to refine your backend development skill set, this course arms you with the practical knowledge and hands-on expertise to stand out. Join us and unlock the power of RDBMS and SQL for your projects and professional growth.



Who this course is for:

  • Aspiring backend developers seeking a solid foundation in databases
  • Programmers preparing for interviews that test SQL and RDBMS concepts
  • Computer Science students wanting hands-on SQL practice
  • Professionals looking to enhance or refresh their SQL and database design skills

Report abuse