SQL Syntax
Explore the SQL syntax and how to employ it to query SQL-compatible databases, like MySQL and PostgreSQL.
An Introduction to SQL Indexes
SQL indexes are used to improve a database's performance during query lookups. This guide discusses unique indexes, primary keys, and composite primary keys.
Database Sharding: Concepts, Examples, and Strategies
Database sharding divides data into smaller chunks and distributes it across different database nodes. Learn more about sharding practices and strategies.
Introduction to SQL Data Types
SQL supports various data types including Binary, Numeric, and Character data types. This guide explains each data type's storage requirements, syntax, and provides examples.
Introduction to SQL Grouping and Totaling
SQL aggregate functions calculate a set of values by using grouping and totaling. This guide uses various examples to demonstrate how to calculate values using the Where and Having clauses.
Introduction to SQL Joins
SQL Joins are used to compare and select rows from tables. This guide discusses Cross Joins, Inner Joins, Left Joins, Right Joins, and Full Joins and provides examples for each SQL Join.
Part 1: SQL Server Security Best Practices
Learn about the SQL Server security best practices and guidelines to keep your server and data safe. For example, disable unused ports and SQL Server features.
Part 2: SQL Server Security Best Practices
Learn about the SQL Server security best practices and guidelines to keep your server and data safe. For example, selecting a SQL Server authentication mode.
SQL Database Security: User Management
SQL database security relies on user management, permissions, groups, and roles. This guide discusses each of these aspects of SQL database security with examples.
SQL Triggers in SQL Server: An Overview
This guide explains SQL trigger statements, special database objects, and how to enforce referential integrity for primary/foreign key relationships with them.
Introduction to SQL Commands
SQL commands can be used across relational database systems like MySQL and PostgreSQL. Learn the fundamental SQL commands used to insert and modify data in a SQL table.