SQL Tutorial

SQL Introduction SQL Aggregate Functions SQL Aliases SQL And SQL Any All SQL Avg SQL Between SQL Case SQL Comments SQL Count SQL Delete SQL Distinct SQL Exists SQL GROUP BY SQL Having SQL In SQL INSERT INTO SQL Is Not Null SQL Join SQL Full Outer Join SQL Inner Join SQL Left Join SQL Right Join SQL Self Join SQL Like SQL Min Max SQL NOT Operator SQL Null SQL Operators SQL OR operator SQL ORDER BY SQL Select SQL Select Into SQL Top Limit Fetch SQL Stored Procedures SQL Sum SQL Union SQL Update SQL Where SQL Wildcards

SQL Database

SQL Alter Table SQL Auto increment SQL Backup Database SQL Check SQL Constraints SQL Create View SQL Create Database SQL Create Table SQL Data types SQL Dates SQL Default Constraint SQL Drop Database SQL Drop Table SQL Foreign Key SQL Hosting SQL Index SQL injections SQL Not NULL SQL PrimaryKey SQL Unique SQL Views

SQL Hosting

SQL hosting means running a database on infrastructure that an application can connect to. The database may live on the same server as the application, on a managed database service, or on dedicated infrastructure maintained by a team.

What matters when choosing SQL hosting

Connection example

Applications normally connect using a host, database name, user and password. The exact format depends on the language and driver.

-- The SQL query is the same after the connection is established.
SELECT customer_id, customer_name
FROM customers
ORDER BY customer_name;

Local vs hosted database

A local database is useful for development and learning. A hosted database is designed to be reachable by an application, protected by permissions and maintained with backups. Production databases deserve boring reliability. Exciting databases usually mean someone is awake at 3 AM.

Related topics

Continue with SQL Backup Database, SQL CREATE DATABASE and SQL Injection.