Congratulations!

Introduction to SQL Server

John MacKintosh

Instructor

What we learned...

• Selecting: SELECT
• Ordering: ORDER BY
• Filtering: WHERE and HAVING
• Aggregating: SUM, COUNT, MIN, MAX and AVG
• Text manipulation: LEFT, RIGHT, LEN and SUBSTRING

What we learned (II)...

• GROUP BY
• INNER JOIN, LEFT JOIN, RIGHT JOIN
• UNION and UNION ALL
• Create, Read, Update and Delete (CRUD)
• Variables
• Temporary tables

Next Steps

• Intermediate SQL Server
• Joining Data in SQL

Congratulations!

Introduction to SQL Server