SQL Queries in 1 Hour.
Who has a birthday this month?
Course summary:
Fun and informative 1-hour SQL Queries Tutorial, online, instructor-led.
This 1 HOUR course is packed with power query techniques.
We will in this hour reveal, which employee has a birthday this month
Course Outline:
Relational Database Concepts:
- What is a Relationship? Primary Keys and Foreign Keys
SQL Language Essentials:
- The SQL Select Statement
- SQL Where Clause
- Like, Wildcards
- The SQL Order By Clause
- SQL Column Aliases
- Working with Null Values
Expressions :
- Arithmetic Operations and Expressions
- Group by and Aggregates: Sum
- T op / Limit
- Inner J oins
Date functions:
- Todays date
- Get the Year, Month, Day from a date
- Use this in a group by
What is included in the SQL Course:
- SQL Basics 1-Hour Course Certificate on completion.
- SQL Course notes.
- Practical SQL Course exercises.
- Max group size on this SQL Online Course is 4.
