Database Tutorials and Administration Guides
Explore database tutorials including SQL, MySQL, PostgreSQL, MongoDB, and database administration techniques for performance and scalability.
The Databases section helps you learn database management and optimization techniques.
Databases are essential for storing and managing application data efficiently. This category includes tutorials on SQL, MySQL, PostgreSQL, and NoSQL databases.
You may also explore Programming for application integration.
Topics covered
- SQL queries and optimization
- Database design
- Backup and recovery
- Performance tuning
Who should read this
- Developers
- Database administrators
- DevOps engineers
123 articles
SQL IN Operator Explained [10 Practical Examples]
SQL IN with Numeric list of values, with String list of values, with Date list of values, with Subquery, with columns, Multiple SQL IN in a single query, with …
SQL BETWEEN Explained with Practical Examples
SQL between syntax and examples. Using with update and delete statement. SQL NOT between examples and syntax, SQL Between Range with Numeric values
SQL DISTINCT Explained [Practical Examples]
SQL Distinct with SQL select statement, on one column and on multiple columns, difference between SQL Distinct and Group By clause and SQL Distinct with SQL …
Learn to use SQL ORDER BY like a PRO with Our Guide
Enhance your SQL queries with advanced SQL ORDER BY techniques. Elevate the efficiency and functionality of your database interactions.
Foreign Key in SQL Usage Explained [Practical Examples]
Foreign Key in SQL can be specified as the referential integrity in Relational Database management system, in technical term foreign key in SQL is a constraint …
SQL Date Format Explained with Examples
Different types and formats of SQL date format explained with examples. SQL datetime format syntax, type and examples. sql server date format.
How to Delete Row in SQL Server [10 Practical Examples]
sql delete multiple rows, sql delete row if exists, sql delete all rows, sql delete duplicate rows, sql delete from select, sql delete row where column …
SQL WITH Clause Explained [Practical Examples]
The SQL WITH clause allows you to give the name to the output of referenced in subsequent queries, this process is interchangeably called as common table …
Concat SQL Function Explained [Practical Examples]
Concat SQL function is used to concatenate strings. difference between SQL concat and SQL concat_ws.
SQL NOT NULL Constraint Explained [Easy Examples]
The SQL NOT NULL constraint on an attribute or column specifies that the NULL value is not allowed for that attribute, in other word, the constraint in SQL …
SQL ISNULL Function Explained [Easy Examples]
SQL ISNULL is Advanced SQL function which takes two parameters first one is expression or column name and second is value which is return if expression or …
SQL Time Functions Explained [Easy Examples]
SQL Time functions can have different versions in different Database Management Systems like MySQL, ORACLE, and MS SQL Server. NOW(), CURDATE(), CURRENT_TIME(), …
SQL Left Join Multiple Tables [Easy Examples]
Examples to use SQL LEFT JOIN Multiple tables. In SQL Left join, if a specific row is present in the left table but not in the right, the result will include …
SQL Union Operator Explained [Easy Examples]
SQL Union Operator or clause is a one of the SQL Set operators which is used to merge or combine two or more SQL Select Query results into single result set.
SQL COUNT, AVG, SUM Functions | Aggregate Functions in SQL
SQL COUNT, AVERAGE and SUM are most commonly used aggregate functions of SQL.