Tutorials, Exercises published recently
Trending Exercises / Tutorial :
Python PCEP Certification Preparation Guide: Exam Details & Syllabus
Learn Data Structures and Algorithms (DSA)
Array Coding Problems: Classic & Challenging Challenges
100 Python Projects for Beginners with solution
13 December, 2024
Understanding SQLite Data Types: A Complete Guide
Understanding SQLite Comments: Syntax and Examples
Understanding SQLite Composite Primary Keys: A Comprehensive Guide
How to show all tables in an SQLite Database?
SQLite DROP TABLE command with syntax and examples
Using Better SQLite3 for Fast SQLite Operations in Node.js
Airtable and SQLite integration for Seamless Data Sync
Drizzle ORM and SQLite Simplified for Database Management
SQLite Boolean Data type and its implementation Explained
A Complete Guide to Creating Tables in SQLite3
A Comprehensive guide to SQLite .sqlite files
12 December, 2024
SQLite Code of Ethics Guiding Principles and their Impact
Understanding LibSQL features and its differences from SQLite
Understanding SQLite Turso and its Edge-Based Features
Learn SQLite Database Operations using Bun
SQLite JSON vs PostgreSQL JSONB Compare Storage & Querying
How to Use Expo SQLite in React Native?
Integrating SQLite with Supabase for Efficient Data Management
Drizzle ORM and SQLite Integration: A Developer's Guide
Using SQLite with PocketBase for Modern Applications
Using UUIDs in SQLite: Storage and Querying
RocksDB vs SQLite: A Detailed Comparison
Rusqlite vs SQLite: Features, use Cases, and Examples
Comprehensive Guide to SQLite Indexes
11 December, 2024
SQLite3.dll Guide: How to use SQLite DLL for Applications
Detailed Comparison: DuckDB vs SQLite3
Comprehensive Guide to Prisma with SQLite
Comprehensive Guide to SQLite Data Starter Packs
Better-SQLite3 Node.js Integration Made Simple
Comprehensive Guide to SQLite in Expo Projects
Comprehensive Guide to using SQLite in Flutter
Comprehensive Guide to SQLite integration in Rust
A Complete Guide to TypeORM Integration with SQLite3
Understanding SQLite vs PostgreSQL: Key Differences and Examples
10 December, 2024
Master SQLite Snippets and Examples for Real-World Applications
09 December, 2024
Comprehensive Guide to PostgreSQL LIMIT Clause
Integrating PostgreSQL with Spring Boot: Complete Guide
07 December, 2024
A Comprehensive Guide to PostgreSQL TEXT Data Type
DELETE CASCADE in PostgreSQL for Relational Integrity
Mastering PostgreSQL ON CONFLICT DO NOTHING
PostgreSQL SERIAL: Auto-Incrementing Made Simple
Postman and PostgreSQL Integration: A Step-by-Step Guide
Comprehensive Guide to PostgreSQL High Availability Options
06 December, 2024
Update: Practical Guides to NumPy Snippets and Examples
05 December, 2024
Practical Guides to NumPy Snippets and Examples
04 December, 2024
Update: Top PostgreSQL Snippets and Code examples for Developers
03 December, 2024
Understanding Date Differences in PostgreSQL with Examples
Understanding PostgreSQL Max Connections Configuration
Understanding PostgreSQL Update from Select Queries
Getting Started with Amazon Aurora PostgreSQL
Complete Guide to PostgreSQL VACUUM Command
30 November, 2024
Step-by-Step Guide to Installing MongoDB on Red Hat or CentOS
Comprehensive Guide to Installing MongoDB Community Edition on Ubuntu
Step-by-Step Installation Guide for MongoDB Community Edition on Debian
Step-by-Step Installation Guide for MongoDB Community Edition on SUSE
Step-by-Step Guide to Install MongoDB Community Edition on Amazon Linux
Update: Rust Programming Tutorial Series with Practical Guides
29 November, 2024
Update: Rust Programming Tutorial Series with Practical Guides
28 November, 2024
Update: Top PostgreSQL Snippets and Code examples for Developers
27 November, 2024
Update: Top PostgreSQL Snippets and Code examples for Developers
26 November, 2024
MongoDB db.collection.deleteOne Method Explained with Examples
Comprehensive Guide to MongoDB db.collection.deleteMany Method
Detailed Guide to MongoDB db.collection.findOneAndDelete Method
Update: Rust Programming Tutorial Series with Practical Guides
25 November, 2024
Update: Rust Programming Tutorial Series with Practical Guides
Update: Top PostgreSQL Snippets and Code examples for Developers
23 November, 2024
Rust Programming Tutorial Series with Practical Guides
21 November, 2024
Comprehensive Guide to db.collection.countDocuments in MongoDB
Understanding db.collection.estimatedDocumentCount() in MongoDB
20 November, 2024
Guide to Using db.collection.insertOne in MongoDB
Comprehensive Guide to Using db.collection.insertMany in MongoDB
Comprehensive Guide to db.collection.updateOne in MongoDB
Comprehensive Guide to db.collection.updateMany in MongoDB
Comprehensive Guide to db.collection.findOneAndUpdate in MongoDB
19 November, 2024
Apple Magic Keyboard for iPad: Transform Your Tablet Experience
Magic Keyboard with Touch ID: Seamless Security Meets Elegance
Install MongoDB Community Edition on macOS Step-by-Step
Installing MongoDB with Docker
PostgreSQL UPSERT: Insert or Update Rows
PostgreSQL Full-Text Search: Examples and Best Practices
PostgreSQL: Terminate Processes by PID
PostgreSQL pg_dump: Backup and Restore Database Easily
PostgreSQL Connection Pooling with PgBouncer
18 November, 2024
Update: Install MongoDB on Windows
Postgres Exporter for Monitoring PostgreSQL.
How to Use PostgreSQL BYTEA Data Type for Binary Storage?
Comprehensive Guide to Setting Up PostgreSQL Patroni.
Complete Guide to Using PostgreSQL with DataGrip.
PostgreSQL CASE WHEN - Complete Guide with Examples.
PostgreSQL vs MongoDB - Which Database is Right for You?
How to Change Column Types in PostgreSQL Tables
Top PostgreSQL Clients - Tools for every Developer
Conditional Logic in PostgreSQL - IF and CASE Explained
Step-by-Step Guide to Creating a User in PostgreSQL
PostgreSQL and QGIS Integration for Geospatial Analysis
Converting Timestamps to Dates Simplified
Apple Magic Keyboard (Standard): The Perfect Blend of Style and Functionality
Apple Magic Keyboard with Numeric Keypad: Boost your Productivity
16 November, 2024
PostgreSQL Regex - Pattern Matching and String Manipulation.
How to set the PostgreSQL default Password securely?
Heroku PostgreSQL - Setup, Connection, and Management Guide
Amazon Aurora PostgreSQL Setup and Key Features Guide.
How to Install and Configure PostgreSQL on Ubuntu?
PostgreSQL SQLAlchemy Integration - Examples and Guide.
PostgreSQL integration with Django - Setup and Examples.
PostgreSQL with Node.js - Setup, Configuration, and CRUD Examples.
Guide to Using Psycopg2 for PostgreSQL in Python.
PostgreSQL and Go (Golang): Setup, CRUD Examples, and Connection Guide.
Integrating PostgreSQL with Azure: Setup Guide and Key Features.
Deploying PostgreSQL on Kubernetes .
15 November, 2024
Understanding and Configuring the PostgreSQL Default Port.
PostgreSQL ANY operator: Flexible Array and Subquery matching.
Analyzing PostgreSQL Queries with the EXPLAIN Command.
Using PostgreSQL LIKE for Flexible Text Matching
Understanding and implementing PostgreSQL Partitioning
Decoding Base64 Encoded Data in PostgreSQL.
Fixing "psql Command Not Found" Error in PostgreSQL.
Using PostgreSQL Foreign Data Wrappers to Access External Data.
PostgreSQL CREATE TABLE IF NOT EXISTS Usage Guide.
Using Terraform to Automate PostgreSQL Database Management.
SQLite vs. PostgreSQL - Key Differences and Use Cases
PostgreSQL Identity Column - Auto-Increment IDs simplified
PostgreSQL Replication: Setup, Types, and Benefits
PostgreSQL TimescaleDB: Handling Time-Series Data Efficiently.
14 November, 2024
Using PostgreSQL with DuckDB for aalytical workloads.
How to use PostgreSQL array_agg for array aggregation?
Postico for PostgreSQL - A GUI Tool for Database Management.
PostgreSQL NULLIF Function: Handle Null Values in Queries.
PostgreSQL Logical Replication - Setup and Guide for Data Sync.
How to Use COALESCE in PostgreSQL to Handle NULL Values.
Using EXPLAIN ANALYZE in PostgreSQL to Optimize Queries.
MariaDB vs. PostgreSQL - Key Differences and use Cases.
Using the DISTINCT Clause in PostgreSQL for Unique Data Retrieval.
Using Unique Constraints in PostgreSQL for Data Integrity.
Understanding PostgreSQL row_number for Ordered Row.
Listing all users and roles in PostgreSQL.
Listing Schemas in PostgreSQL.
Common Table Expressions (CTE) in PostgreSQL.
PostgreSQL INSERT INTO Statement..
13 November, 2024
How to connect to PostgreSQL in a Docker container from Outside?
How to kill a PostgreSQL Session/Connection?
Restoring a PostgreSQL Database from a Backup File.
Updating table rows in PostgreSQL with Subqueries.
PostgreSQL Database Size Command: Syntax and Examples.
How to list tables in Schemas in PostgreSQL?
Changing ownership of all tables in PostgreSQL.
Randomly select rows in PostgreSQL.
Introduction to PostgreSQL with Supabase.
How to Use PostgreSQL with Vercel for Backend Data?
Getting Started with Neon PostgreSQL - A Serverless Solution.
Using Pgvector in PostgreSQL for Vector similarity Searches.
Using Drizzle to Connect PostgreSQL with JavaScript and TypeScript.
How to Query JSON Data in PostgreSQL with JSONB?
12 November, 2024
How to reset a PostgreSQL primary key sequence when out of synchronize?
Understanding the PostgreSQL connection string format
How to specify a Password for psql non-interactively?
How to import an SQL Dump into PostgreSQL?
Understanding PostgreSQL equivalent to MySQL AUTO_INCREMENT
How to insert data in PostgreSQL only if it does not exist?
How to generate a UUID in PostgreSQL for insert statements?
How to copy a PostgreSQL Database to another Server?
How to Create a Read-Only user in PostgreSQL?
Where Does PostgreSQL Store Configuration Files?
How to Use the equivalent of "USE database_name" in PostgreSQL?
How to make case-insensitive Queries in PostgreSQL?
How to find row count for all tables in PostgreSQL.
How to fix Password Authentication failed for user "postgres" in PostgreSQL
How to use SELECT DISTINCT on Multiple Columns in PostgreSQL?
11 November, 2024
How to Find Documents by IDs in an Array in MongoDB.
How to count documents Grouped by a field in MongoDB.
List all Databases in MongoDB Shell.
MongoDB Query by Date - Retrieve Documents in Date Range.
Query Array of Objects in MongoDB Easily.
How to display more than 20 Documents in MongoDB's Shell?.
How to Combine Data from Multiple Collections in MongoDB?
Querying Nested Objects in MongoDB - A Complete Guide.
Rename Field for All MongoDB Documents Using $rename Operator.
MongoDB Naming Conventions - Best Practices for Collections & Fields.
Inserting Integers in MongoDB - Example and Syntax Guide.
How to Display all Documents from every Collection in MongoDB.
Update every document on one field in MongoDB - Full Guide.
09 November, 2024
Retrieve Specific Array Elements in MongoDB with $elemMatch.
How to add a new field to all documents in MongoDB Collection?
Export all Collections in MongoDB Database with mongodump.
Retrieve a Random Document in MongoDB Using $sample.
Secure MongoDB Access with Username and Password Authentication.
How to Search for a Document by ObjectId in MongoDB.
How to Select a Single Field in MongoDB for all Documents.
How to make a Case-Insensitive Query in MongoDB?
How to Retrieve all Unique Key Names in a MongoDB Collection.
Upgrading a PostgreSQL User to Superuser.
08 November, 2024
Creating a Copy of a Database in PostgreSQL
How to Run a PostgreSQL .sql File from the Command Line?
Importing CSV Data into a PostgreSQL Table.
Top MongoDB Snippets and Code Examples for Developers
How to use MongoDB’s Like Query with Regex for Pattern Matching
Dropping a MongoDB Database from the Command Line.
Listing all Collections in MongoDB Shell.
Using MongoDB to check if a field contains a Substring.
Finding Documents in MongoDB with an Array containing a specific value.
How to Retrieve the Last N Records in MongoDB?
Query for "Is Not Null" in MongoDB Using $ne and $exists
Perform SQL Join Equivalent in MongoDB with $lookup.
Renaming a MongoDB Database using a Copy-and-Drop Workaround.
Enable Pretty Print by Default in MongoDB Shell.
Query MongoDB for Documents Between Two Dates Using $gte and $lte.
Update MongoDB Field Based on Another Field's Value.
Delete all data in a MongoDB Database with dropDatabase().
Execute MongoDB Commands via Shell Scripts for Automation.
Remove a Field from MongoDB Document with $unset Operator.
07 November, 2024
Top PostgreSQL Snippets and Code examples for Developers
How to Show Tables in PostgreSQL
Describe Table Structure in PostgreSQL
Select the first row of each set of rows grouped with a GROUP BY in PostgreSQL
How to Change a PostgreSQL user Password?
Dropping All Tables in a PostgreSQL Database
How to Switch Databases in PostgreSQL psql Command Line
Starting the PostgreSQL Server on macOS
Checking your PostgreSQL Version
How to save PostgreSQL PL/pgSQL Output to a CSV File
Understanding the difference between text and varchar in PostgreSQL
06 November, 2024
Restaurant Reservation System for Table, Order, and Payment Management
05 November, 2024
Update: C Snippets, Examples, Code
01 November, 2024
SQL Projects: School Course Enrollment System
30 October, 2024
SQL Projects: Hotel Booking System - Database Design and Management
29 October, 2024
SQL Projects: Complete Movie Rental System with Efficient Database Design and Management
25 October, 2024
Develop a Quiz Game with Timer in Python
Stock Price Checker: Real-Time Stock Prices in Python
Python - Basic Movie Database: Add, Edit, Delete, and View Movies
24 October, 2024
SQL Projects For Beginners: Employee Payroll System
SQL Projects: Online Store Database Management System
23 October, 2024
SQL Projects For Beginners: Inventory Management System
SQL Projects For Beginners: Hospital Patient Database
22 October, 2024
SQL Projects for Beginners with Solutions and Explanation
21 October, 2024
18 October, 2024
Number Guessing Game with GUI in Python
Python - Basic POS System: Console and GUI Solutions
17 October, 2024
Python Project - Create a Weather Application
Build a Basic Alarm Clock in Python with Tkinter
16 October, 2024
Word Cloud Generator in Python
15 October, 2024
Python Project - Encrypt and Decrypt files with Symmetric Encryption
Python Project: Extract Information from URLs
Currency Exchange Rate Checker in Python
Build a Basic Paint App in Python
07 October, 2024
Basic Drawing with Python Turtle Graphics
Simple Text Editor in Python with Tkinter
Build a URL Scraper in Python to Extract URLs from Webpages
How to Build a Contact Book Program in Python
03 October, 2024
Java Projects for Beginners with Solutions and Explanation
01 October, 2024
Pandas Machine Learning Integration: Exercises and Solutions for Data Integrity
28 September, 2024
PCEP Certification Practice: Exception Propagation through Function Boundaries
27 September, 2024
Pandas Visualization Integration: Exercises and Solutions for Data Visualization
PCEP Certification Practice: Delegating Responsibility for Handling Exceptions
PCEP Certification Practice: Exception Propagation through Function Boundaries
26 September, 2024
Pandas Data Cleaning and Preprocessing: Exercises, Solutions with Explanation
PCEP Certification Practice: try-except Exception Handling
PCEP Certification Practice: Ordering except branches in Python
25 September, 2024
PCEP Certification Practice: TypeError Questions & Explanations
PCEP Certification Practice: ValueError Questions & Explanations
24 September, 2024
Pandas Advanced Merging and Joining: Exercises with Solutions and Explanation
23 September, 2024
PCEP Certification Practice Test: LookupError Exceptions
PCEP Certification Practice: IndexError Questions & Explanations
PCEP Certification Practice: KeyError Questions & Explanations
Pandas Custom Functions: Apply, Map, and Applymap Explained with Exercises