Repo: https://github.com/z1n0v1/M03-MySQL

Here you can find all the solutions for SoftUni’s MySQL course.

MySQL is the first course of SoftUni’s Java DB track, a gentle introduction to relational databases. It is 5 weeks long. This is the first course that prepares you for your professional career.

In this course you’ll learn about:

  • Databases Introduction. Data Definition and Datatypes - (Lab) - (Exercise)
    • Structured Query Language
    • Basic SQL Queries
    • Data Types in MySQL Server
    • Data Management
    • Table Customization
  • Basic CRUD - (Lab) - (Exercise)
    • Query Basics
    • Retrieving Data
    • Writing Data in Tables
    • Modifying Existing Records
  • Built-in Functions - (Lab) - (Exercise)
    • Functions in MySQL Server
    • String Functions
    • Arithmetical Operators and Numeric Functions
    • Date Functions
    • Wildcards
  • Data Aggregation - (Lab) - (Exercise)
    • Grouping – consolidating data based on criteria
    • Aggregate Function – COUNT, SUM, MAX, MIN, AVG
    • Having – using predicates while grouping.
  • Table Relations - (Lab) - (Exercise)
    • Database design
    • Table Relation
    • Retrieving Related Data
    • Cascade Operations
    • E/R Diagram
  • Subqueries and JOINs - (Lab) - (Exercise)
    • JOINS – Gathering Data From Multiple Tables
    • Subqueries – Query Manipulation on Multiple Levels
    • Indices – Clustered and Non-Clustered Indices
  • Database Programmability and Transactions - (Lab) - (Exercise)
    • User-Defined Functions
    • Stored Procedures
    • Transactions
    • Triggers

The next course part of the Software Engineering track is Spring Data.