SQL Queries Course, 1 hour basics, Manchester

SQL 90 minutes Crash Course

What is a Relational Database?

• Tables, Rows and Columns, Data Types
• Relationships, Primary Keys and Foreign Keys

• SQL Queries with the Select Statement
• The Select and From Clause
• Column Aliases
• The Order By Clause
• Conditions and the Where Clause
• Wildcards
• Working with null values

• Expression queries
• SQL Arithmetic Operation

• SQL Query Summarizing and Grouping
• SQL Aggregate Functions
• Sum, Avg, Count, Max, Min
• The Group By Clause
• The Having Clause

• Querying Multiple Tables
• Joining Tables Inner Joins

WHAT IS INCLUDED:

• SQL Course Certificate
• Course notes
• C ourse exercises and worked examples
• Personal attention, max group size is 4.

Host or Publisher PCWorkshops