MySQL Practice Challenges (Deprecated)
Beginner
This course contains lots of challenges for MySQL, each challenge is a small MySQL project with detailed instructions and solutions. You can practice your MySQL skills by solving these challenges, improve your problem-solving skills, and learn how to write clean and efficient code.
databasemysql
- Intro
- Syllabus
A Simple Course Database
Managing Database Indexes in MySQL
Add Student Information to Table
Add Student Personal Information
Adding Constraints to the Course Schedule
Adding Unique Constraint to City Names
Average Salaries Per Department
Backup MySQL Database with Mysqldump
Biology Course Alumni Search
Calculate User's Encrypted Password
Change Default Value for Countrylanguage Table
Changing the Error Log Location
Cities with Over One Million Population
City Names and Respective Countries
Database Management and SQL Self-Join
Columbus Discovery of the New World
MySQL Basic Functions Challenge
Comprehensive SQL Query Challenge
Manipulating Dates in Personnel Database
Database Constraint Design and Implementation
Countries and Codes in Region
Countries with 1 Billion+ Population
Accessing MySQL Database and Querying GNP
Country GNP and Population Query
Creating Stored Procedures for Course Data Retrieval
Creating Secure MySQL User Accounts
Creating Product Information Table
SQL Queries for Student Course Analysis
MySQL Database Management Fundamentals Coming Soon
Database Management with SQL
Delete Course Schedule View Data
Delete Expired Course Information
Comprehensive MySQL Data Manipulation
SQL Querying for Employee Data
MySQL Database Management
Format Query for Teacher Salary
General Function Comprehensive
Accessing MySQL Database and SQL Querying
Identify MVP Recipient in Game
Database Joins for Personnel Data
Largest Population by Country
Largest Population in Five Countries
Create MySQL Maximum Value Function
Modifying MySQL Database Table Constraints
Modify Primary Key of Countrylanguage Table
Modify Student Table Attributes
Modifying the Teacher Table Using PreparedStatement
MySQL Data Analysis
Number of Users with Modify Permissions
Obtain Pi with Two Decimals
Official Languages in Various Countries
Personnel Management System Database Setup
Print Current Login User Information
Printing Current Time with MySQL
Print Standard Body Temperature in Fahrenheit
Query City Information for Specified IDs
Query City Names with Country
Query GDP for All Countries
Query Is So Slow
Query Population of All Countries
Query Teacher Salary Using PreparedStatement
SQL Database Creation and Non-Equijoin Query
Query User Levels with Left Join
Querying Country Codes Range
Querying Official Languages and Sorting
Querying Official Languages of Each Country
Reverse Print File Content Command
Right Outer Join Query User Level
Salary Range for Teachers by Department.
Search for Favorite Courses
Stored Procedure Cursor Database Retrieval
Statement for Querying Classroom Table
Student Grade Management System
Creating Database Views in MySQL
SQL Subqueries for Data Analysis
Top 5 Countries by Land Area
University Information Query System
Updating Student GPA in MySQL Database
Creating and Updating Database Views
MySQL Database Administration Essentials
Manage MySQL User Permissions
View for Course Information
Exploring MySQL User Permissions
Wuxu Reform Duration Calculation
Teacher
Labby
Labby is the LabEx teacher.
Share to Google Classroom
Join Our Discord and Learn Together
Join NowUser Reviews
" Great way to explain everything!"
— Araceli Rivera Jaime
" thanks this lab makes us learn interactively rather than just theory"
— austin wamono
Recommended For You

