SQL Tutorial for Beginners

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