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
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
21 September, 2024
C Increment and Decrement Operators with examples
C Programming: Assignment Operators
C Programming: Conditional (Ternary) Operator
C Programming: Special Operators with examples
PCEP Certification Practice: Python ArithmeticError Exception
PCEP Certification Practice: Python Abstract Exceptions
Python PCEP Practice Questions: KeyboardInterrupt Exception
20 September, 2024
C Programming - Logical Operators Explained
C Arithmetic Operators Explained with Examples
C Relational Operators with Examples
19 September, 2024
Python Project - Basic URL Crawler for extract URLs
PCEP Certification Practice: Python Built-In BaseException Hierarchy
PCEP Certification Practice: Python Built-In Exception Class
PCEP Certification Practice: Python SystemExit Exception Handling
18 September, 2024
Multithreading in C with POSIX Threads: A Complete Guide
Understanding the Concept and use Cases of Unions in C
Understanding Bitwise Operators with examples in C
PCEP Certification Practice: Name Scopes, Name Hiding, and Global Keyword
PCEP Exam Practice: Default Parameter Values in Python Functions
Trivia Quiz Game Project: CLI and GUI Solutions in Python
17 September, 2024
PCEP Certification Practice Test: Positional, Keyword, and Mixed Arguments
Mastering Preprocessor Directives in C: #define, #include, and Macros
Comprehensive Guide to Error Handling in C: errno, perror(), and strerror()
Understanding Typedef and Enum in C Programming
16 September, 2024
Command-Line Arguments in C: Handling argc and argv
Dynamic Memory Allocation in C: malloc(), calloc(), realloc(), and free()
C File Handling: fopen(), fclose(), fread(), and fwrite() Tutorial
PCEP Certification Practice Test: Parameters vs. Arguments
14 September, 2024Comprehensive guide to Recursion in C Programming: Best Practices & Examples
PCEP Certification Practice Test: User-Defined Functions and Generators
PCEP Certification Practice Test: Understanding the None Keyword in Python
PCEP Certification Practice Test: Mastering Recursion in Python
13 September, 2024C Programming Functions: Declarations, Definitions & Examples
PCEP Practice Test: Mastering Quotes and Apostrophes in Python Strings
PCEP Practice Test: Understanding Multi-line Strings in Python
PCEP Practice Test: Basic String Functions and Methods in Python
12 September, 2024PCEP Certification Practice Test: Constructing Strings
PCEP Certification Practice Test: Indexing, Slicing, and String immutability
PCEP Certification Practice Test: Escaping using the Backslash character
Python URL Shortener Project: Comparing Hashing and Base62 Encoding Methods
Basic Music Player Project: Tkinter vs PyQt5 Solutions for Python
Palindrome Checker Project: Basic and Class-Based Python Solutions
Building a Basic Blog System in Python: Two Approaches
09 September, 2024PCEP Certification Practice: Checking the Existence of Dictionary Keys
PCEP Certification Practice: Dictionary Methods keys(), items(), and values()
05 September, 2024PCEP Certification Practice: Iterating through Dictionaries and their Keys and Values
PCEP Certification Practice: Iterating through Dictionaries and their Keys and Values
Python Project - Basic Drawing App using Tkinter and PyQt5
Python Image Downloader: Download Images from a URL
04 September, 2024Python Image Downloader: Download Images from a URL
PCEP Certification Practice: Tuples vs. Lists - Differences and Similarities
PCEP Certification Practice: Lists inside Tuples and Tuples inside Lists
03 September, 2024Python Project: Hangman Game - Solutions and Explanations
Python File Organizer Project - Solutions and Explanations
Create a Basic Web Server Project in Python: Flask vs. Django
Create a Secure Password Manager Project in Python: Two Approaches
Python Two-Player Tic-Tac-Toe Project - Solutions and Explanations
Python Project - Rock, Paper, Scissors Game: Solutions and Explanations
Python Project - Random Password Generator Solutions and Explanations
PCEP Certification Practice: Tuples - Indexing, Slicing, Building, and Immutability
02 September, 2024PCEP Practice Test: Initializing Loops in Python Lists
PCEP Practice Test: Lists in Lists - Matrices and Cubes
Python - Build a basic To-Do List Project: Solutions and Explanations
Python Guess the Number Game Project: Solutions and Explanations
Python Project: Dice Rolling Simulator - Solutions and Explanations
Python Simple Alarm Clock Project - Solutions and Explanations
Python Project Temperature Converter - Solutions and Explanations
Python Project - Random Password Generator Solutions and Explanations
Python Project: Text-Based Adventure Game - Solutions and Explanations
Python Project - Rock, Paper, Scissors Game: Solutions and Explanations
Python Project Currency Converter - Solutions and Explanations
Python Project - Basic Web Scraper Solutions and Explanations
01 September, 2024Python Hello World Project: Solutions and Explanations
Python Simple Calculator Project with Solutions and Explanations
31 August, 2024Python SQLite: Basics of Working with SQLite Databases
Python SQLAlchemy: Using SQLAlchemy ORM for Database Interactions
Update:100 Python Projects for Beginners with solutions
30 August, 2024Testing and Debugging in Python: A Comprehensive Guide
Understanding Python Metaclasses: A Comprehensive Guide
Python Memory Management: How Python Handles Memory Efficiently
Understanding Python GIL: The Global Interpreter Lock Explained
PCEP Certification Practice Test: Mastering the Python del Instruction
PCEP Certification Practice Test: Iterating Through Lists with the for Loop
PCEP Certification Practice Test: Using in and not in Operators
PCEP Certification Practice Test: List Comprehensions
PCEP Certification Practice Test: Copying and Cloning
29 August, 2024Understanding and creating Python Decorators
Python Multithreading: Working with Threads
Python Multiprocessing: A Comprehensive Guide to Parallel Execution
Python Asyncio: A Comprehensive Guide to Asynchronous Programming
Constructing Vectors with Lists in Python Exam preparation
Indexing and Slicing Lists in Python PCEP Exam preparation
Understanding and creating Python Decorators
Using the len() Function with Python Lists PCEP Exam preparation
28 August, 2024Python PCEP Exam - Nested Loops and Conditional Statements
Controlling Loop Execution in Python: Mastering Break and Continue
Python List Comprehensions: For Concise and Readable Code
Python Dictionary Comprehensions: For Creating Dictionaries in a Compact Form
Python Sets and Frozensets: Detailed Explanation and Use-Cases