SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.
SQL: Getting Started | |
1. Download and Install SQL Server 2. Login to SQL Server 3. Create a Database User 4. Authentication in SQL Server 5. Create new database | 6. Backup SQL database 7. Restore SQL database 8. Import data to SQL database 9. Export data to SQL database 10. Your first line of SQL command |
|
SQL: Syntax | |
1. SELECT 2. INSERT 3. UPDATE 4. DELETE 5. WHERE 6. DISTINCT 7. HAVING 8. ORDER BY 9. AND/OR/NOT 10. IN 11. BETWEEN 12. LIKE 13. GROUP BY | 14. EXISTS 15. CREATE TABLE 16. DROP 17. COUNT 18. ASC 19. DESC 20. UNION 21. ALTER TABLE 22. USE 23. INNER JOIN 24. LEFT JOIN 25. NULL VALUES 26. ANY/ALL |
|
SQL: Data Types | |
1. Numeric Data Types 2. DateTime Data Types 3. Character Strings Data Types | 4. Binary Data Types 5. Misc Data Types |
|
SQL: Operators | |
1. SQL Arithmetic Operators 2. SQL Comparison Operators | 3. SQL Logical Operators |
|
SQL: Expressions | |
1. Boolean Expressions 2. Numeric Expression | 3. Date Expressions |
|