Database Tutorials
Our database tutorials provide well-structured learning paths for both SQL and NoSQL databases. Covering essential concepts, query languages, database design, and optimization techniques, our tutorials are suitable for both beginners and intermediate developers. With free labs and practical examples, you'll gain hands-on experience in database operations across different database systems.
Other Skill Trees
LinuxDevOpsCybersecurityDevOps EngineerCybersecurity EngineerDevSecOpsKali LinuxRed Hat Enterprise LinuxRHCSA TrainingRHCE in Enterprise Linux TrainingLFCS TrainingShellGitDockerKubernetesCKA TrainingCKAD TrainingCKS TrainingAnsibleRHCE in Ansible TrainingJenkinsNmapWiresharkHydraCompTIAMySQLPostgreSQLRedisMongoDBSQLitePythonGolangJavaCC++Web DevelopmentData Science
Setting Up SQLite in Linux
In this lab, you will learn how to set up SQLite on a Linux system using the LabEx VM environment. This hands-on tutorial covers installing SQLite, verifying the installation, accessing the SQLite CLI, and running basic commands like .help and .exit. Perfect for beginners, it provides practical experience with a lightweight, file-based RDBMS in the ~/project directory.
SQLite
Exploring MySQL User Permissions
In this project, you will learn how to retrieve and view the user permission information from the MySQL database. This project is designed to help you understand the MySQL user management and permission system, which is an essential skill for database administrators and developers.
SQLMySQL
Wuxu Reform Duration Calculation
In this project, you will learn how to access a MySQL database using the sudo command and write an SQL query to calculate the duration of the Wuxu Reform, also known as the 'Hundred Days' Reform'.
SQLMySQL
Updating Student GPA in MySQL Database
In this project, you will learn how to update a student's GPA (Grade Point Average) in a database using the UPDATE statement in SQL.
MySQL
View for Course Information
In this project, you will learn how to create and use database views in MySQL. Database views are virtual tables that provide a customized perspective of the underlying data, allowing you to hide certain data processes from users and simplify data access.
SQLMySQL
University Information Query System
In this project, you will learn how to create a university information query system using Java and MySQL. This project will guide you through the process of setting up a MySQL database, connecting to it using Java, and querying information about students, courses, and instructors.
JavaMySQL
Creating and Updating Database Views
In this project, you will learn how to create a student view in a MySQL database and update the data in the view.
MySQL
Top 5 Countries by Land Area
In this project, you will learn how to retrieve the top 5 countries by land area from the MySQL country table. You will learn how to access MySQL, import data, and write SQL queries to retrieve the desired information.
MySQLSQL
SQL Subqueries for Data Analysis
In this project, you will learn how to use subqueries to retrieve relevant information from the employee (emp) and department (dept) tables in the personnel database. You will practice writing complex SQL queries to access and analyze data from multiple tables.
SQLMySQL
Creating Database Views in MySQL
In this project, you will learn how to create a database view based on the student table in the edusys database. The view will include the ID, name, and dept_name columns from the student table, providing a simplified and focused view of the student data.
MySQLSQL
Stored Procedure Cursor Database Retrieval
In this project, you will learn how to use a cursor to output the course information from the section table where the semester is Spring. You will create a stored procedure to retrieve the course details and then execute the procedure to display the results.
SQLMySQL
Statement for Querying Classroom Table
In this project, you will learn how to use JDBC (Java Database Connectivity) to query data from a MySQL database using the Statement object. You will also learn how to encapsulate the result set using ResultSet.
JavaMySQL
Salary Range for Teachers by Department.
In this project, you will learn how to retrieve the maximum and minimum salary for each department in a MySQL database using built-in functions and SQL queries.
SQLMySQL
Querying Official Languages of Each Country
In this project, you will learn how to retrieve the official languages of each country using an equijoin query in MySQL. This project will help you understand how to work with relational databases, perform complex queries, and extract specific information from a database.
SQLMySQL
Search for Favorite Courses
In this project, you will learn how to create a 'favorite' table in a MySQL database. The 'favorite' table will store the courses with the longest study time for each user in the 'usercourse' table.
SQLMySQL
Querying Official Languages and Sorting
In this project, you will learn how to query and sort the official languages spoken in different countries using SQL. You will access the MySQL database, import the necessary data, and write a SQL script to retrieve and order the official languages.
SQLMySQL
Querying Country Codes Range
In this project, you will learn how to retrieve countries that speak the same official language as the country with the country code 'FRO' using a multi-row subquery operation in MySQL.
SQLMySQL
Query Teacher Salary Using PreparedStatement
In this project, you will learn how to use JDBC (Java Database Connectivity) to query a MySQL database using a PreparedStatement. The goal is to retrieve the names and salaries of teachers whose salary is higher than 6000 from the instructor table in the edusys database.
MySQLJava
- Prev
- 1
- 2
- 3
- 4
- 5
- 6
- ...
- 27
- Next