SQL Tutorial for Beginners

By FoxLearn 7/31/2019 9:59:21 PM 4.02K

In this tutorial we will cover all of the fundamentals of the SQL (Structured Query Language). This course is great for beginners and also intermediates

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