SQL Injection and Secure Database Access in Java Applications
Learn about SQL Injection vulnerability in Java and discover step by step how to secure your application using PreparedStatement.
MongoDB Query Guide: Methods for Pulling Data from Collections
Learn step by step how to extract data from MongoDB collections with the find() method, comparison operators, and embedded document query techniques.
Using MongoDB Indexes: A Guide to Speeding Up Collection Queries
Learn step by step what indexes do in MongoDB, how to create them, and how to analyze query performance.
Using MySQL Functions
Calculate, transform and summarize your MySQL data using SQL functions (ROUND, CONCAT, DATEDIFF, COUNT).
Guide to Creating MySQL Tables and Adding Data
Learn step by step how to create a table with CREATE TABLE, add data with INSERT, and update records with UPDATE in MySQL.
Using MySQL Trigger: Automatic Data Processing with BEFORE and AFTER Triggers
Automate INSERT, UPDATE and DELETE operations using MySQL triggers. Maintain data integrity, manage archiving and statistics updates.
MySQL and MariaDB Database Backup (Export) and Restore (Import) Guide
Learn how to backup MySQL and MariaDB databases with mysqldump, restore with mysql client, and optimize large SQL files.
SQL Comparison and IS NULL Operators: Data Filtering Basics
Learn how to filter query results using Comparison Operators (=, >, <) and the IS NULL expression in a SQL WHERE clause.
Guide to Permanently Deleting SQL Data (DELETE)
Learn how to delete data from single and multiple tables with the SQL DELETE command, ON DELETE CASCADE and SET NULL behaviors.
Using SQL Foreign Key: Ensuring Data Integrity
Learn how to ensure Referential Integrity and prevent data inconsistency by using Foreign Key in SQL.
Using SQL JOIN: Guide to Joining Tables
Learn how to combine multiple tables into a single query using SQL JOIN, INNER-OUTER JOIN differences, and the use of aliases.
SQL SELECT Query: Basics of Retrieving Data from Database
Learn how to query and sort data from database tables using SELECT, FROM, DISTINCT, WHERE and ORDER BY statements in SQL.
Using SQL UNION: Combining Data from Different Tables into a Single Result
Learn how to pull data from different tables, join them, and manage duplicate records with SQL UNION and UNION ALL commands.
Updating SQL Data (UPDATE) Guide
Learn how to safely modify existing data with the SQL UPDATE command, multiple table updates with JOIN, and foreign key constraints.
Creating and Using SQL View: Data Security and Ease with Virtual Tables
Learn how to create virtual tables, restrict data access, and simplify complex queries using SQL View.
Using SQL WHERE: Data Filtering Guide
Learn how to filter query results, apply comparison operators, and logical expressions using the WHERE clause in SQL.
Using SQL BETWEEN and IN Operators: Comprehensive Data Filtering
Learn how to effectively filter your queries with the WHERE clause using the BETWEEN (Range) and IN (Set Membership) operators in SQL.
Guide to Adding Data with SQL INSERT INTO Command
Learn how to insert data into tables manually with the SQL INSERT INTO command, with a SELECT query, or with automatic (AUTO_INCREMENT, DEFAULT) values.
MariaDB Installation: Power Up Your Ubuntu 22.04 Server
Learn step by step to install MariaDB on Ubuntu 22.04, configure security settings and test its functionality.
MySQL Installation and Secure First Configuration on Ubuntu Servers
Learn step by step how to install MySQL on Ubuntu, create a root password, user management and UFW security settings.
phpMyAdmin Installation and Safe User Guide on Ubuntu
Guide to installing phpMyAdmin on Ubuntu, MySQL access settings and creating an additional layer of security with Apache .htaccess.
PostgreSQL Installation and Usage: Ubuntu 22.04 Database Guide
PostgreSQL (Postgres) installation on Ubuntu 22.04, user and database creation, table and data management steps.
Database Normalization and Application Guide with Example
Reduce data duplication with database normalization, increase data integrity and learn 1NF, 2NF, 3NF, BCNF stages with sample SQL applications.