w3resource logo

 


Tutorials, Exercises published recently

Trending Exercises / Tutorial :

Python PCEP Certification Preparation Guide: Exam Details & Syllabus

Number Conversion

Learn Data Structures and Algorithms (DSA)

Array Coding Problems: Classic & Challenging Challenges

100 Python Projects for Beginners with solution

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

Python - Code Snippet Manager

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, 2024

Comprehensive 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, 2024

C 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, 2024

PCEP 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, 2024

PCEP Certification Practice: Checking the Existence of Dictionary Keys

PCEP Certification Practice: Dictionary Methods keys(), items(), and values()

05 September, 2024

PCEP 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, 2024

Python 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, 2024

Python 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, 2024

PCEP 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, 2024

Python Hello World Project: Solutions and Explanations

Python Simple Calculator Project with Solutions and Explanations

31 August, 2024

Python 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, 2024

Testing 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, 2024

Understanding 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, 2024

Python 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

Python Namedtuples: To Create Lightweight Object Types

27 August, 2024

Python PCEP Exam - Control Flow if, if-else, if-elif-else

Python PCEM Exam: Conditional Statements (If, If-Else, If-Elif-Else)

Python PCEP Exam: Nested if, else, and elif Statements

Mastering Python's Pass Statement: Purpose, Usage, and Examples

PCEP Exam - Control Flow in Python: Mastering Conditional Statements and Loops

Python PCEP Exam - Iterating Through Sequences

Python PCEP Exam: Loops - while-else and for-else Explained

Python File I/O: Reading, Writing, and Managing Files

Python CSV Files: Handling CSV files Using the 'csv' module

Python JSON: Parsing JSON Data and Converting Python Objects to JSON

26 August, 2024

Python Exceptions: Understanding and Handling Errors

Understanding Python Try-Except: Examples and Use Cases

Raising Exceptions in Python: How and When to Use Them

24 August, 2024

Mastering Pythons sep= and end= Parameters for PCEP-30-02

PCEP-30-02 Exam: Python I/O Operations - int() and float() functions

Python Lambda Functions: A Practical Guide

Python map(), filter(), reduce(): A Comprehensive Guide

Understanding Python Closures: Concepts and Practical Examples

23 August, 2024

Python Classes

Python Inheritance: How to use Inheritance in Classes

Python Polymorphism: How to implement and use Polymorphism

Python Iterators: Creating and Using Iterators

Python Generators: Using yield to Create Generators

PCEP-30-02 Exam Prep: In-Depth Practice on Relational Operators in Python

PCEP-30-02 Exam Prep: Understanding Floating-Point Accuracy in Python

PCEP-30-02 Exam Prep: Understanding Type Casting in Python

PCEP-30-02 Exam: Mastering Python's print() and input() Functions

Python Encapsulation: Using Private and Protected Members in Classes

Python Abstraction with examples: Abstract Classes and Interfaces

Python Decorators: Understanding Function and Class Decorators

PCEP - Python interpreting and the interpreter, compilation and the compiler

Prepare for the PCEP-30-02 Exam: Lexis, Syntax, and Semantics Mastery

Python Keywords: Essential Guide for PCEP-30-02 Exam Preparation

Python Instructions: Essential Practice for PCEP-30-02 Exam

Understanding Python Indentation: PCEP Exam Practice

Understanding Python Comments: Essential Practice for PCEP-30-02 Exam

20 August, 2024

Python PCEP Certification Preparation Guide

3 August, 2024

Java Nested Classes - Exercises, Practice, Solution

2 August, 2024

Java Static Members - Exercises, Practice, Solution

1 August, 2024

Java Constructor - Exercises, Practice, Solution

30 July, 2024

Update: Java Encapsulation - Exercises, Practices, Solutions

29 July, 2024

Pandas Advanced Grouping and Aggregation Exercises with Solutions

25 July, 2024

Pandas Resampling and Frequency Conversion Exercises with Solutions

05 July, 2024

Mastering advanced indexing and slicing in Pandas DataFrames

03 July, 2024

Mastering Python: 100 Exercises with Solutions

02 July, 2024

Mastering Pandas: 100 Exercises with solutions for Python data analysis

01 July, 2024

Optimize Pandas Performance: Exercises, Practice, Solutions

29 June, 2024

NumPy Integration with SciPy: Exercises, Practice and Solutions

27 June, 2024

NumPy Structured Arrays: Exercises, Practice and Solutions

26 June, 2024

NumPy Masked Arrays: Exercises and Solutions

25 June, 2024

NumPy Universal Functions : Exercises, Practice, and Solutions

24 June, 2024

NumPy Advanced Indexing: Exercises, Practice, and Solutions

22 June, 2024

NumPy I/O Operations: Exercises, Practice, and Solutions

21 June, 2024

NumPy Interoperability Exercises, Practice, Solutions

20 June, 2024

NumPy Performance Optimization Exercises with Solutions

19 June, 2024

NumPy Memory Layout Exercises, Practice, Explanation, Solution

18 June, 2024

NumPy Broadcasting Exercises, Practice, Solution

17 June, 2024

NumPy: Advanced Exercises, Practice, Solution

12 June, 2024

Create Java Classes for Pets with Dog and Bird Subclasses

Java Program for GymMembership and PremiumMembership Classes

10 June, 2024

Java Program for Managing Customer and Online Orders

Java Program for Managing Reservations with Resort and Railway Subclasses