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 add column with default value to an existing table [SOLVED]
SQL ALTER TABLE statement is used to make changes in the existing SQL table and can be used to add column with default values
Using SQL UPDATE from SELECT statement [7 Methods]
There are 3 different methods to use SQL UPDATE from Select. Using INNER Join, Using Merge statement and using sub query statement.
SQL Remove Characters from String with Examples [SOLVED]
SQL remove characters from string from left side, right side. Remove first character, remove last character, remove last n characters, remove specific …
Find and Delete Duplicate Rows in SQL [100% Working]
Learn how to find and delete duplicate rows in SQL or completely delete records in SQL including Joins using different methods. You can also automate the …
SQL Drop Constraint Explained [Practical Examples]
drop constraint, drop constraint sql server, sql drop constraint, drop sql constraint, sql server drop constraint, drop foreign key sql server, alter table drop …
SQL Floor() function Explained [Practical Examples]
sql floor, floor sql, floor function in sql, floor in sql, floor sql server, sql floor function, sql server floor
SOLVED: SQL ambiguous column name [5 Possible Causes]
ambiguous column name join, sql ambiguous column name, ambiguous column name, ambiguous column name sql, column reference is ambiguous, ms sql ambiguous column …
SQL Mapping Carnality Explained with Examples
SQL mapping cardinalities define the relationship between the entities or tables of one relationship set with the entities or tables of another relationship
Use SQL Ranking Functions Like a PRO: Don't be a Rookie
Explore the transformative potential of SQL Ranking Functions to revolutionize your database queries and analytics. Dive deep into robust strategies, avoid …
SQL Stored Procedure Explained [Practical Examples]
SQL stored procedures are generally precompiled group of an ordered series of Transact-SQL statements stored into a single logical unit which allow for
35+ SQL Functions Explained in Detail [Practical Examples]
Related Keywords: sql create function, sql functions example, sql function syntax, oracle sql functions, sql functions list pdf, function in sql server, sql …
SQL Transactions Explained [Practical Examples]
SQL Transactions consists of a sequence of SQL statements and/or queries, the SQL standard specifies that a transaction begins implicitly when an SQL
SQL Domain Constraints (NOT NULL, Check, UNIQUE)
Domain constraint is used to restrict the values to be inserted in the column or relation, domain constraint defines a valid set of values for a table
SQL TOP Explained [Practical Examples]
SQL TOP clause is used to limit the records returned as the result set of SQL select query by specified number of rows or percentage of rows in SQL Server.
SQL FULL OUTER JOIN Explained [Practical Examples]
Examples to use SQL Full Outer Join with two tables, three tables, multiple tables with Where Clause, multiple tables with Group by Clause, Using Union Clause, …