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
Pandas Iterate Over Rows with Best Practices [SOLVED]
We can iterate over rows in the Pandas DataFrame using the following methods, Using index attribute, Using loc[] function, Using iloc[] function, Using …
SQL CONTAINS Explained [Practical examples]
we have covered the SQL Contains which is used to do the searching operation for a word or phrase or nearby word on a full-text index, we have started with an …
How to PROPERLY add comments in SQL [Multiple Ways]
We will cover different practical examples to explain how to add SQL comments for Single line comments, Multi-line comments, Inline comments
SQL OUTER JOIN Explained [Practical examples]
SQL OUTER JOIN is used to preserve all of the records that have values in either the left or right table, In the SQL OUTER JOIN all the content of both tables …
SQL INSERT INTO SELECT with Practical Examples
This article of SQL INSERT INTO SELECT, the article begins with the overview of SQL INSERT INTO SELECT with syntax, use of each syntax argument and clause, the …
Delete table in SQL / DROP TABLE in SQL [Practical Examples]
In this article of delete table in SQL, we have covered the delete table command DROP TABLE used to delete a table in SQL with syntax and explanation of each …
How to alter table and add column SQL [Practical Examples]
In SQL, to add column(s) to the existing table SQL ALTER TABLE ADD statement is used, there is no statement like SQL ADD COLUMN to add the column or to modify …
SQL Data Types Explained [Practical Examples]
an overview of SQL data types, also define a list of SQL data types, we have explained each category of data types and described each category data type with …
DATEADD SQL Function Tutorial [Practical Examples]
DATEADD SQL date function that is used for manipulating DateTime datatype values, DATEADD function is used to add or subtract the specific numerical value to a …
SQL Not Equal Tutorial [Practical Examples]
SQL Not Equal is a comparison operator used to compare two not null operand values or an expression, if the left operand value is not equal to the right operand …
SQL If Statement Tutorial [Practical Examples]
practical examples to use sql if statement explained. Use multiple if conditions, sql if else condition, sql nested if else condition with examples
SQL RANK Function Explained [Practical Examples]
Practical examples of SQL RANK function with a single table, multiple tables, with partition argument and ORDER BY ASC and DESC, also mention an example of SQL …
SQL Replace Function Explained [Practical Examples]
SQL REPLACE performs comparisons based on the collation of the input. To perform a comparison in a specified collation, you can use COLLATE to apply an explicit …
Getting started with SQL - Detailed Explanation
Getting started with SQL. Overview on relational database, What is SQL, Comparison between SQL and MySQL, Steps to install SQL on both Windows and Linux …
SQL NOT IN Operator Explained [8 Practical Examples]
Examples of SQL NOT IN with Numeric list of values, String list of values, Date list of values, Subquery, columns, Update statement, Delete statement, HAVING …