Basic computer skills
This course is aimed at anyone who is completely new to SQL.
After completing the course, you should then understand the main principles and components of a relational database and be able to extract the data you need, and be able to arrange, summarise and format it as required for the reports you need to provide.
Basic SQL
• SQL Server Management Studio
• Viewing table data
• WHERE clause
• AND & OR clauses
• ORDER BY clause
• IN operator
• BETWEEN operator
• LIKE operator
• Null values
• Comments
• Databases and schemas
Joining Tables
• Primary and foreign keys
• Inner joins
• Link tables
• Outer joins
• Non-standard Joins
• Self-joins
Functions
• Text functions
• Date functions
• Aggregate functions
• CASE functions
Sub Queries
• Nested sub-queries
• Correlated sub-queries.
• Inline view ( Common Table Expression)
• ANY, ALL, EXISTS operators.