Skip to content
/ database-free-tutorials Public

Free Database tutorials for beginners with 115 interactive lessons. Easy-to-follow programming guides with hands-on practice exercises.

labex.io/skilltrees/database
0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

labex-labs/database-free-tutorials

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

28 Commits
README.md
README.md
ย 
ย 
README_de.md
README_de.md
ย 
ย 
README_es.md
README_es.md
ย 
ย 
README_fr.md
README_fr.md
ย 
ย 
README_ja.md
README_ja.md
ย 
ย 
README_ko.md
README_ko.md
ย 
ย 
README_pt.md
README_pt.md
ย 
ย 
README_ru.md
README_ru.md
ย 
ย 
README_zh.md
README_zh.md
ย 
ย 

Repository files navigation

Practice Database Free Tutorials

Languages

๐Ÿ‡จ๐Ÿ‡ณ ็ฎ€ไฝ“ไธญๆ–‡ ๐Ÿ‡ฏ๐Ÿ‡ต ๆ—ฅๆœฌ่ชž ๐Ÿ‡ช๐Ÿ‡ธ Espaรฑol ๐Ÿ‡ซ๐Ÿ‡ท Franรงais ๐Ÿ‡ฉ๐Ÿ‡ช Deutsch ๐Ÿ‡ท๐Ÿ‡บ ะ ัƒััะบะธะน ๐Ÿ‡ฐ๐Ÿ‡ท ํ•œ๊ตญ์–ด ๐Ÿ‡ง๐Ÿ‡ท Portuguรชs ๐Ÿ‡บ๐Ÿ‡ธ English

A comprehensive learning path for mastering popular database systems including MySQL, Redis, MongoDB, and PostgreSQL. This Skill Tree offers structured learning for database beginners, covering essential concepts, database design, and administration across different database types. Through hands-on, non-video courses and practical exercises in interactive database playgrounds, you'll gain real-world experience in database management and querying.

Index Name Difficulty Tutorial Link
001 ๐Ÿ“– Explore MySQL System Tables Beginner ๐Ÿ”— View
002 ๐Ÿ“– How to start PostgreSQL in Kali Linux Beginner ๐Ÿ”— View
003 ๐Ÿ“– Create Your First MySQL Database Beginner ๐Ÿ”— View
004 ๐Ÿ“– Book Search Challenge Beginner ๐Ÿ”— View
005 ๐Ÿ“– Create a Product Catalog Table Beginner ๐Ÿ”— View
006 ๐Ÿ“– Record Movie Data Challenge Beginner ๐Ÿ”— View
007 ๐Ÿ“– MySQL Basic Data Manipulation Beginner ๐Ÿ”— View
008 ๐Ÿ“– MySQL Data Filtering and Sorting Beginner ๐Ÿ”— View
009 ๐Ÿ“– MySQL Table Structure and Data Types Beginner ๐Ÿ”— View
010 ๐Ÿ“– Database Management Fundamentals with MySQL Beginner ๐Ÿ”— View
011 ๐Ÿ“– Installation and Basic Configuration of MySQL Intermediate ๐Ÿ”— View
012 ๐Ÿ“– Your First MongoDB Lab Intermediate ๐Ÿ”— View
013 ๐Ÿ“– Create MongoDB Collection Beginner ๐Ÿ”— View
014 ๐Ÿ“– Insert Data in MongoDB Intermediate ๐Ÿ”— View
015 ๐Ÿ“– Delete MongoDB Data Beginner ๐Ÿ”— View
016 ๐Ÿ“– Update MongoDB Records Beginner ๐Ÿ”— View
017 ๐Ÿ“– Honor Roll Tracker Beginner ๐Ÿ”— View
018 ๐Ÿ“– Populate the Students Collection Beginner ๐Ÿ”— View
019 ๐Ÿ“– Basic Data Operations in PostgreSQL Beginner ๐Ÿ”— View
020 ๐Ÿ“– Data Filtering and Simple Queries in PostgreSQL Beginner ๐Ÿ”— View
021 ๐Ÿ“– Database Management Basics with PostgreSQL Beginner ๐Ÿ”— View
022 ๐Ÿ“– Installation and Initial Setup of PostgreSQL Intermediate ๐Ÿ”— View
023 ๐Ÿ“– PostgreSQL Table Creation and Data Types Intermediate ๐Ÿ”— View
024 ๐Ÿ“– MySQL Backup and Recovery Beginner ๐Ÿ”— View
025 ๐Ÿ“– MySQL Common Table Expressions (CTEs) Beginner ๐Ÿ”— View
026 ๐Ÿ“– MySQL Configuration and Tuning Beginner ๐Ÿ”— View
027 ๐Ÿ“– MySQL Error Handling and Logging Beginner ๐Ÿ”— View
028 ๐Ÿ“– MySQL Event Scheduler Beginner ๐Ÿ”— View
029 ๐Ÿ“– MySQL Full-Text Search Capabilities Beginner ๐Ÿ”— View
030 ๐Ÿ“– MySQL Functions and Custom Logic Beginner ๐Ÿ”— View
031 ๐Ÿ“– MySQL Import and Export Operations Beginner ๐Ÿ”— View
032 ๐Ÿ“– MySQL Indexes and Performance Optimization Beginner ๐Ÿ”— View
033 ๐Ÿ“– MySQL JSON Data Handling Beginner ๐Ÿ”— View
034 ๐Ÿ“– MySQL Partitioning for Large Datasets Beginner ๐Ÿ”— View
035 ๐Ÿ“– MySQL Security Best Practices Beginner ๐Ÿ”— View
036 ๐Ÿ“– MySQL Stored Procedures Basics Beginner ๐Ÿ”— View
037 ๐Ÿ“– MySQL Subqueries and Nested Operations Beginner ๐Ÿ”— View
038 ๐Ÿ“– MySQL Temporary Tables and Session Data Beginner ๐Ÿ”— View
039 ๐Ÿ“– MySQL Transactions and Data Integrity Beginner ๐Ÿ”— View
040 ๐Ÿ“– MySQL Triggers for Automation Beginner ๐Ÿ”— View
041 ๐Ÿ“– MySQL Views and Virtual Tables Beginner ๐Ÿ”— View
042 ๐Ÿ“– MySQL Window Functions Beginner ๐Ÿ”— View
043 ๐Ÿ“– PostgreSQL Advanced Data Types Beginner ๐Ÿ”— View
044 ๐Ÿ“– PostgreSQL Advanced Query Writing Beginner ๐Ÿ”— View
045 ๐Ÿ“– PostgreSQL Backup and Restore Beginner ๐Ÿ”— View
046 ๐Ÿ“– PostgreSQL Database Maintenance Beginner ๐Ÿ”— View
047 ๐Ÿ“– PostgreSQL Date and Time Operations Beginner ๐Ÿ”— View
048 ๐Ÿ“– PostgreSQL Error Handling Beginner ๐Ÿ”— View
049 ๐Ÿ“– PostgreSQL Event Trigger Setup Beginner ๐Ÿ”— View
050 ๐Ÿ“– PostgreSQL Full-Text Search Beginner ๐Ÿ”— View
051 ๐Ÿ“– PostgreSQL Index Optimization Beginner ๐Ÿ”— View
052 ๐Ÿ“– PostgreSQL JSON/JSONB Advanced Operations Beginner ๐Ÿ”— View
053 ๐Ÿ“– PostgreSQL PgBouncer Connection Pooling Beginner ๐Ÿ”— View
054 ๐Ÿ“– PostgreSQL PostGIS Extension Beginner ๐Ÿ”— View
055 ๐Ÿ“– PostgreSQL Relationships and Joins Beginner ๐Ÿ”— View
056 ๐Ÿ“– PostgreSQL Role and Permission Management Beginner ๐Ÿ”— View
057 ๐Ÿ“– PostgreSQL Stored Function Development Beginner ๐Ÿ”— View
058 ๐Ÿ“– PostgreSQL Streaming Replication Beginner ๐Ÿ”— View
059 ๐Ÿ“– PostgreSQL Table Partitioning Beginner ๐Ÿ”— View
060 ๐Ÿ“– PostgreSQL Transaction Management Beginner ๐Ÿ”— View
061 ๐Ÿ“– PostgreSQL Trigger Automation Beginner ๐Ÿ”— View
062 ๐Ÿ“– PostgreSQL Views Management Beginner ๐Ÿ”— View
063 ๐Ÿ“– Verify PostgreSQL Connection Details Beginner ๐Ÿ”— View
064 ๐Ÿ“– Create Your Own Recipe Database Beginner ๐Ÿ”— View
065 ๐Ÿ“– Create Employee Table in PostgreSQL Beginner ๐Ÿ”— View
066 ๐Ÿ“– Manage Employee Data in PostgreSQL Beginner ๐Ÿ”— View
067 ๐Ÿ“– Find Marketing Employees in PostgreSQL Beginner ๐Ÿ”— View
068 ๐Ÿ“– Installation and Initial Setup of Redis Beginner ๐Ÿ”— View
069 ๐Ÿ“– Basic Data Management in Redis Beginner ๐Ÿ”— View
070 ๐Ÿ“– Basic Key-Value Operations in Redis Beginner ๐Ÿ”— View
071 ๐Ÿ“– Introduction to Redis Data Structures Beginner ๐Ÿ”— View
072 ๐Ÿ“– Persistence and Simple Configuration in Redis Beginner ๐Ÿ”— View
073 ๐Ÿ“– Redis Advanced Key Management Beginner ๐Ÿ”— View
074 ๐Ÿ“– Redis Hash Operations Beginner ๐Ÿ”— View
075 ๐Ÿ“– Redis HyperLogLog Operations Beginner ๐Ÿ”— View
076 ๐Ÿ“– Redis List Operations Beginner ๐Ÿ”— View
077 ๐Ÿ“– Redis Lua Scripting Beginner ๐Ÿ”— View
078 ๐Ÿ“– Redis Performance Monitoring Beginner ๐Ÿ”— View
079 ๐Ÿ“– Redis Persistence Management Beginner ๐Ÿ”— View
080 ๐Ÿ“– Redis Pub/Sub Messaging Beginner ๐Ÿ”— View
081 ๐Ÿ“– Redis Security Settings Beginner ๐Ÿ”— View
082 ๐Ÿ“– Redis Set Operations Beginner ๐Ÿ”— View
083 ๐Ÿ“– Redis Sorted Set Operations Beginner ๐Ÿ”— View
084 ๐Ÿ“– Redis Transactions Beginner ๐Ÿ”— View
085 ๐Ÿ“– Verify Redis Server Status Beginner ๐Ÿ”— View
086 ๐Ÿ“– Expire Keys In Redis Cache Beginner ๐Ÿ”— View
087 ๐Ÿ“– Add Item to Redis To-Do List Beginner ๐Ÿ”— View
088 ๐Ÿ“– Configure Redis Maxmemory Limit Beginner ๐Ÿ”— View
089 ๐Ÿ“– Increment Redis Counter for Website Visits Beginner ๐Ÿ”— View
090 ๐Ÿ“– Setting Up SQLite in Linux Beginner ๐Ÿ”— View
091 ๐Ÿ“– Building Tables in SQLite Beginner ๐Ÿ”— View
092 ๐Ÿ“– Creating and Managing SQLite Databases Beginner ๐Ÿ”— View
093 ๐Ÿ“– Querying and Filtering Data Beginner ๐Ÿ”— View
094 ๐Ÿ“– Working with Data in SQLite Beginner ๐Ÿ”— View
095 ๐Ÿ“– SQLite Constraint Management Beginner ๐Ÿ”— View
096 ๐Ÿ“– SQLite CTE Queries Beginner ๐Ÿ”— View
097 ๐Ÿ“– SQLite Data Grouping Beginner ๐Ÿ”— View
098 ๐Ÿ“– SQLite Database Backup Beginner ๐Ÿ”— View
099 ๐Ÿ“– SQLite Database Maintenance Beginner ๐Ÿ”— View
100 ๐Ÿ“– SQLite Error Handling Beginner ๐Ÿ”— View
101 ๐Ÿ“– SQLite Full-Text Indexing Beginner ๐Ÿ”— View
102 ๐Ÿ“– SQLite Index Optimization Beginner ๐Ÿ”— View
103 ๐Ÿ“– SQLite JSON Processing Beginner ๐Ÿ”— View
104 ๐Ÿ“– SQLite PRAGMA Tuning Beginner ๐Ÿ”— View
105 ๐Ÿ“– SQLite Subquery Techniques Beginner ๐Ÿ”— View
106 ๐Ÿ“– SQLite Table Joining Beginner ๐Ÿ”— View
107 ๐Ÿ“– SQLite Temporary Storage Beginner ๐Ÿ”— View
108 ๐Ÿ“– SQLite Transaction Handling Beginner ๐Ÿ”— View
109 ๐Ÿ“– SQLite Trigger Automation Beginner ๐Ÿ”— View
110 ๐Ÿ“– SQLite View Creation Beginner ๐Ÿ”— View
111 ๐Ÿ“– SQLite Window Analytics Beginner ๐Ÿ”— View
112 ๐Ÿ“– Install and Verify SQLite on Linux Beginner ๐Ÿ”— View
113 ๐Ÿ“– Build SQLite Database For Contacts Beginner ๐Ÿ”— View
114 ๐Ÿ“– Filter SQLite Data for IT Department Beginner ๐Ÿ”— View
115 ๐Ÿ“– Query Specific Data in SQLite Beginner ๐Ÿ”— View

More

About

Free Database tutorials for beginners with 115 interactive lessons. Easy-to-follow programming guides with hands-on practice exercises.

labex.io/skilltrees/database

Topics

awesome programming database tutorials free awesome-list exercises hands-on free-tutorials labex

Resources

Readme
Activity
Custom properties

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published