bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths
Learn/SQL/SQL Database
SQL•SQL Database

SQL Hosting

If you want your web site to store and retrieve data from a database, your web server must have access to a database-system.

If your web server is hosted by an Internet Service Provider (ISP), you will have to look for SQL hosting plans.

Some common SQL hosting databases are MySQL, PostgreSQL, SQL Server, and Oracle.

MySQL

MySQL is a popular database software for web sites.

MySQL is known for speed, reliability, and ease of use.

MySQL is an inexpensive alternative to the expensive Microsoft and Oracle solutions.

Tip

Read our MySQL Tutorial .

SQL Server

Microsoft SQL Server is a popular database software for database-driven web sites with high traffic.

Microsoft SQL Server has a strong integration with other Microsoft products, powerful tools, and robust security features.

Oracle

Oracle is a popular database software for database-driven web sites with high traffic.

Oracle is known for extreme scalability, performance, reliability, and security.

Oracle has expensive licensing.

PostgreSQL

PostgreSQL is a popular database software for web sites.

PostgreSQL has advanced features, high standards compliance, extensibility, and strong data integrity.

PostgreSQL is open-source and free.

Tip

Read our PostgreSQL Tutorial .

Previous

SQL Prepared Statements

Next chapter

SQL References

Start with SQL Data Types for MySQL, SQL Server, and MS Access

This chapter

Overview
21

Lessons

50m

Read time

1. SQL CREATE DATABASE Statement2. SQL DROP DATABASE Statement3. SQL BACKUP DATABASE Statement4. SQL CREATE TABLE Statement5. SQL DROP TABLE Statement6. SQL ALTER TABLE Statement7. SQL Constraints8. SQL NOT NULL Constraint9. SQL UNIQUE Constraint10. SQL PRIMARY KEY Constraint11. SQL FOREIGN KEY Constraint12. SQL CHECK Constraint13. SQL DEFAULT Constraint14. SQL CREATE INDEX Statement15. SQL AUTO INCREMENT Field16. SQL Working With Dates17. SQL Views18. SQL Injection19. SQL Parameters20. SQL Prepared Statements21. SQL Hosting

On this page

MySQLSQL ServerOraclePostgreSQL