Tutorials, Exercises published recently
Trending Exercises / Tutorial :
100 Python Projects for Beginners with solution
SQL Exercises, Practice, Solution
SQL Exercises, Practice, Solution - JOINS
Learn Data Structures and Algorithms (DSA)
Daily Coding Challenges & Projects
Python PCEP Certification Preparation Guide: Exam Details & Syllabus
Array Coding Problems: Classic & Challenging Challenges
06 February, 2026
Anthropic AI Tool SaaSpocalypse
03 February, 2026
29 January, 2026
28 January, 2026
pip install mysql-connector-python
27 January, 2026
24 January, 2026
12 January, 2026
50 PostgreSQL Query Challenges
09 January, 2026
06 January, 2026
Software Frameworks : The Ultimate Beginner's Guide
03 January, 2026
Mastering python-docx: Create and Manipulate
30 July, 2025
Update: C Programming Exercises, Practice, Solution : Do While Loop
16 July, 2025
Update: JavaScript Date - Exercises, Practice, Solution
09 July, 2025
Update: JavaScript fundamental - Exercises, Practice, Solution
02 July, 2025
Update: JavaScript basic - Exercises, Practice, Solution
26 June, 2025
Update: C# Sharp Basic Declarations and Expressions : Exercises, Practice, Solution
19 June, 2025
Update: HTML CSS Exercise
17 June, 2025
Update: HTML5 Basic (Tag and attribute) - Exercises, Practice, Solution
16 June, 2025
Update: HTML-CSS Practical Part-I: Exercises, Practice, Solution
13 June, 2025
Update: Swift Programming Exercises, Practice, Solution: Basic
12 June, 2025
Update: Scala Programming String - Exercises, Practice, Solution
11 June, 2025
Update: Scala Control Flow: Exercises, Practice, Solutions
10 June, 2025
Update: Rust Threads and Synchronization Exercises with Solutions and Explanations
09 June, 2025
Update: Rust Vectors Exercises with Solutions and Explanations
07 June, 2025
Update: Rust Beginners Exercises with Solutions and Explanations
06 June, 2025
Update: Ruby Basic: Exercises, Practice, Solution
05 June, 2025
Update: R Programming Vector: Exercises, Practice, Solution
04 June, 2025
Update: R Programming Basic: Exercises, Practice, Solution
03 June, 2025
Update: PHP Challenges: Exercises, Practice, Solution
02 June, 2025
Update: PHP String - Exercises, Practice, Solution
31 May, 2025
Update: PHP for loop - Exercises, Practice, Solution
30 May, 2025
Update: PHP arrays - Exercises, Practice, Solution
29 May, 2025
Update: PHP object oriented programming: Exercises, Practice, Solution
28 May, 2025
Update: PHP Basic Algorithm: Exercises, Practice, Solution
12 May, 2025
Update: Java Basic Programming : Exercises, Practice, Solution
09 May, 2025
Update: Java Array: Exercises, Practice, Solution
15 April, 2025
Update: Pandas Exercises, Practice, and Solutions
10 April, 2025
Update: Python Data Types: Dictionary - Exercises, Practice, Solution
Mastering Nested Dictionary Flattening in Python
Building a Universal Memoization Decorator with Python Dictionary Caching
Implementing a Self-Nesting Python Dictionary with Unlimited Depth
Sequential Python Dictionary Transformations with Functional Programming
Python Dictionary-Powered Graph Algorithms: From Theory to Implementation
Flexible Dictionary Merging: Implementing Custom Conflict Resolvers
Two-Way Python Dictionary: Building a Bidirectional Map with Equal Efficiency
LRU Cache Implementation: Optimizing Memory with Python Dictionary Tracking
Handling Circular References in Python Dictionary Serialization and Deserialization
Dictionary as Abstract Syntax Tree: Evaluating Complex Expressions
08 April, 2025
PostgreSQL User and Role Management Queries
How to create a New Role in PostgreSQL?
How to Create a PostgreSQL User with a Password
Grant SELECT Privileges to a User in PostgreSQL
How to Revoke Privileges from a PostgreSQL User
How to Change a PostgreSQL User's Password?
31 March, 2025
Update: Python filter function exercises
Update: Python Datetime - Exercises, Practice, Solution
Update: Python File Input Output: Exercises, Practice, Solution
Update: Python CSV File Reading and Writing - Exercises, Practice, Solution
Update: Python Regular Expression - Exercises, Practice, Solution
26 March, 2025
Update: Python Conditional Statements and loops
Update: NumPy Basic Exercises, Practice, Solution
Update: NumPy Array Exercises, Practice, Solution
Update: NumPy Mathematics Exercises, Practice, Solution
Update: NumPy Matrix Operations and Linear Algebra Exercises
Update: NumPy Statistics: Mean, Median, Covariance Exercises
22 March, 2025
Update: NumPy Basic: Exercises, Practice, Solution
Update: Python Programming Puzzles - Exercises, Practice, Solution
Update: Advanced Python Exercises and Solutions
17 March, 2025
Comprehensive Comprehensive Exercises for Managing PostgreSQL Partitioned Tables
Adding a New Partition to an Existing Table
Removing a Partition from a Partitioned Table
Attaching an Existing Table as a Partition
Efficient Strategies for Querying PostgreSQL Partitioned Tables
Retrieve All Data from a Partitioned Table
Query Data from a Specific Partition
Query Data using Partition Pruning
14 March, 2025
Practical Techniques for Returning Result Sets in PostgreSQL
Display all Employee Records with a PostgreSQL Function
Retrieve Employees by Department using a Function
Generate Regional Sales Summaries with a PostgreSQL Function
Comprehensive Guide to Table Partitioning in PostgreSQL
Design a Range Partition Table for Sales Data
Set Up Year-Based Partitions for Sales Table
Organize Orders by Region with List Partitioning
13 March, 2025
Comprehensive Guide to writing PL/pgSQL Functions in PostgreSQL
Create a PostgreSQL Function that returns a Fixed String
How to Create a PostgreSQL Function to Square a Number
Retrieve Employee Full Name using a PostgreSQL Function
Comprehensive Guide to Using Triggers with Stored Procedures in PostgreSQL
Implement an Audit Log Trigger for DML Operations
Update Record Timestamps Automatically with a Trigger
Propagate Parent Key Changes via Cascade Trigger
12 March, 2025
Practical Guide to Updating Views in PostgreSQL
Update Employee Data Through a Simple View
Update Records via View with Enforced Conditions
Perform Complex View Updates with INSTEAD OF Trigger
Optimizing Data with PostgreSQL Materialized Views
Build a Materialized Snapshot of Employee Data
Store Aggregated Sales Totals for Quick Reporting
Combine Order and Customer Data for Efficient Reporting
10 March, 2025
Master PostgreSQL Creating and managing views
Simplify Data Access with a Basic Employee View
Merge Employee and Department Data in a Single View
Display Only Sales Employees via a Dedicated View
Summarize Employee Data by Department in a View
Combine First and Last Names into a Computed Full Name
08 March, 2025
Master PostgreSQL Transactions with BEGIN, COMMIT, and ROLLBACK
Execute a Secure Salary Update Operation
Undo Updates Using Transaction Rollback
Execute Multiple DML Operations Atomically
Learn PostgreSQL Isolation Levels for Secure Transactions
Execute Transactions Using READ COMMITTED Level
Achieve Consistent Data with REPEATABLE READ
Maximize Data Integrity with SERIALIZABLE Isolation
Master PostgreSQL Locking and Deadlock Prevention Techniques
Securely Lock a Row to Prevent Concurrent Updates
Obtain an Exclusive Lock on the Entire Table
Prevent Delays by Using NOWAIT in Row Locking
06 March, 2025
Master Index Creation and Management in PostgreSQL
Optimize Lookups with a Basic Index on last_name
Ensure Unique Email Entries with a Unique Index
Enhance Query Performance with a Composite Index
Unlock Performance Insights with EXPLAIN and ANALYZE
Analyze a Simple SELECT Query Execution Plan
Measure Real-Time Performance of a SELECT Query
Review Execution Plan for Table Joins
Hands-on PostgreSQL Indexing Techniques and Exercises
Enhance Lookup Speed on last_name Column
Boost Salary Query Performance with a B-tree Index
Optimize Full Name Searches with a Composite Index
04 March, 2025
Hands-on MySQL Spatial Data Exercises and Solutions
Create a Table with a Spatial Column
Insert a Spatial Data Point Using ST_GeomFromText
Calculate Distance between Two Points
Find Locations Within a Radius
Check if a Point is Within a Polygon
03 March, 2025
Practical MySQL Backup and Restore Techniques
Full Database Backup using mysqldump
Backup a Specific Table using mysqldump
Backup all Databases using mysqldump
Backup Database with Compression
Restore a Full Database from Backup
01 March, 2025
MySQL Security and User Management Exercises with Solutions
28 February, 2025
Advanced Full-Text Search Techniques for MySQL Mastery
Basic Full-Text Search on a Single Column
Full-Text Search on Multiple Columns
Full-Text Search with Relevance Ranking
Full-Text Search Using Query Expansion
27 February, 2025
Hands-on MySQL JSON and NoSQL Features Exercises
Insert JSON Data into a Column
Query JSON Data with JSON_EXTRACT
Update a JSON Document with JSON_SET
Validate JSON Data using JSON_VALID
26 February, 2025
Practical Exercises for writing SQL Queries Across Multiple Databases
Writing a Query that Works in Both MySQL and PostgreSQL
Comparing how Window Functions are Implemented in SQL Server and PostgreSQL
Query with LIMIT in MySQL and FETCH FIRST in SQL Server
Handling String Concatenation Across Databases
Using Date Functions Across Databases
25 February, 2025
Practical SQL Exercises for Database Backup and Recovery
Creating a Full Backup of a Database
Restoring a Database from a Full Backup
Creating a Differential Backup
Restoring a Database Using Full and Differential Backups
Creating a Transaction Log Backup
24 February, 2025
Mastering Temporal Tables and Versioning Through Practical SQL Exercises
Creating a Temporal Table to Track Historical Data
Querying Current Data from a Temporal Table
Retrieving Historical Data from a Temporal Table
Retrieving Data as of a Specific Point in Time
Retrieving all Changes Between Two Points in Time
22 February, 2025
Practical Exercises for MySQL Replication and Clustering
Configuring a Slave Server in MySQL Replication
Master Server Configuration for MySQL Replication
Promoting a Slave to Master in MySQL
Monitoring Replication Lag in MySQL
Setting Up Multi-Master Replication
21 February, 2025
Practical Exercises for MySQL Query Optimization
Optimizing MySQL Queries with EXPLAIN for Order Date Filtering
Boosting Query Speed by Creating Indexes in MySQL
Efficient Data Retrieval using Indexed Columns in MySQL
Streamlining MySQL Databases by Removing Unnecessary Indexes
Improving Query Efficiency with Composite Indexes in MySQL
20 February, 2025
Practical Exercises to Master MySQL Stored Procedures and Triggers
Create a MySQL Stored Procedure for Employee insertion
How to Call a Stored Procedure for Employee Insertion
Create a MySQL Stored Procedure to Modify Employee Salary
How to Call a Stored Procedure for Salary Update
Create a MySQL Stored Procedure for Employee Deletion
19 February, 2025
Practical Exercises to Master MySQL Transactions and Concurrency
How to Start a MySQL Transaction and Commit Changes
Using MySQL ROLLBACK to Handle Transaction Errors
Setting MySQL Isolation Level to READ COMMITTED
Using SERIALIZABLE Isolation Level in MySQL
Managing MySQL Deadlocks with Rollback and Retry
18 February, 2025
Grok 3 AI: Revolutionizing Industries with Advanced AI Capabilities
Nugget AI Agent: Transforming Food Discovery and Delivery with AI
Practical Exercises to Master MySQL Window Functions and CTEs
MySQL Query to Rank Employees by Salary
MySQL Query to Compute Running Total of Sales
MySQL Query to Rank Employees by Salary in Each Department
MySQL Query for 3-Month Moving Average of Sales
MySQL Query to Find Salary difference from Previous Row
17 February, 2025
SQL - Practical Security and Access Control Exercises
How to Grant SELECT Permission on a Table in SQL?
How to Revoke INSERT Permission on a Table in SQL?
How to Grant EXECUTE Permission on a Stored Procedure in SQL?
How to Implement Row-Level Security (RLS) in SQL
How to Implement Column-Level Security (CLS) in SQL
15 February, 2025
SQL Error Handling and Debugging with Practical Exercises
Mastering Error Handling in SQL with TRY...CATCH
How to Debug SQL Queries Using Execution Plans
Logging SQL Errors for Debugging and Analysis
Troubleshooting SQL Bottlenecks with Query Profiling
Effective Deadlock Handling in SQL Transactions
14 February, 2025
Database Design and Normalization Exercises with Solutions
Convert a Table into First Normal Form (1NF)
Normalize a Table to Second Normal Form (2NF)
Achieve Third Normal Form (3NF) by Removing Transitive Dependencies
Convert a Table into Boyce-Codd Normal Form (BCNF)
Detect and Eliminate Update Anomalies in SQL
13 February, 2025
Optimize SQL Performance with Query Tuning Exercises with Solutions
Improve SQL Query Performance by Eliminating Unnecessary Joins
Boost Query Performance with Effective Indexing
Understand and Improve SQL Performance with Execution Plans
Improve Query Performance by Selecting Only Required Columns
Enhance Query Speed Using Covering Indexes
Update:SQL Subqueries
JavaScript Promises with setTimeout Examples
Efficiently Combine Sync and Async tasks with Promise.all
Create Debounced Functions in JavaScript with Promises
Using Async/Await with Dynamic imports in JavaScript
Promise.race in JavaScript with Practical Examples