SQL Syntax

10 Guides Available

SQL Triggers in SQL Server: An Overview

What are Triggers?SQL triggers are a special type of stored procedure that are executed when a data change takes place on a table.

Part 2: SQL Server Security Best Practices

This guide is the second in a series of articles that covers SQL Server security best practices.

Part 1: SQL Server Security Best Practices

SQL Server security is perhaps one of the most overlooked facets of database server maintenance. Without taking the necessary precautions, an instance of SQL Server can be ripe for abuse and failure.

Database Sharding: Concepts, Examples, and Strategies

Many software applications use a relational database management system (RDBMS) to store data. As the database grows, it becomes more time-and-storage intensive to store the data.

SQL Database Security: User Management

User management and permissions are essential to SQL database security. Typically, SQL database security schemes consist of one or more users, their authentication, and permissions.

An Introduction to SQL Indexes

In relational database systems, a database index is an extremely powerful tool for data retrieval. In this guide, you learn about unique indexes, primary keys, and composite primary keys.

Introduction to SQL Grouping and Totaling

One of the most powerful aspects of SQL is the ability to perform data aggregation. Two of the most powerful SQL data aggregation tools are grouping and totaling.

Introduction to SQL Data Types

Choosing the proper data type for a table column is an important decision. It reduces the need for data type conversions, enhances the performance of database queries, and minimizes storage requirements.

Introduction to SQL Joins

Traditionally, you pull data from two or more tables using a WHERE clause in a query.

Introduction to SQL Commands

In today’s world of increased digitization, big data, and cloud computing, data management is amongst the most important skills a software engineer can have.