Relational Databases & SQL: Complete Guide for Developers

Course Overview

• Course Title: Relational Databases & SQL: Complete Guide for Developers
• Instructor: Andrii Piatakha
• Target Audience:
  • Developers
  • Anyone interested in learning relational databases and SQL
• Prerequisites: No specific prerequisites

Curriculum Highlights

• Key Topics Covered:
  • Relational Databases
  • Data Modelling
  • Database Architecture
  • SQL
  • MySQL Server & MySQL Workbench
  • PostgreSQL
  • Database Normalization & Denormalization
  • Database optimization
  • Indexes in Databases
  • JDBC
  • DML
  • DDL
  • ORM/JPA
  • Hibernate
  • Spring Data JPA
  • Spring JDBC
• Key Skills Learned:
  • Database design and architecture
  • SQL querying and scripting
  • Database management and optimization
  • Integration with Java applications
  • Use of ORM frameworks

Course Format

• Duration: 13 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 13 articles
  • Access on mobile and TV
  • Certificate of completion
  • Q&A support
  • Free mobile app for practice
  • Open source code examples