SQL: querying and analysing databases in Chad

This course is run on demand: in a virtual classroom or at your premises, on dates that suit you. Ask us for the next dates or a quote for your team.

• Understand the relational model and read a database schema
• Write selection and filtering queries
• Join several tables
• Aggregate and group data
• Use subqueries and window functions for analysis

• Analysts, management controllers, reporting officers
• BI tool users
• Project managers and product owners

Spreadsheet skills. No programming knowledge required.

1. Module 1

   Understanding a database

   • –Tables, primary and foreign keys
   • –Reading a relational schema
   • –Query tools

2. Module 2

   Querying

   • –SELECT, WHERE, ORDER BY
   • –Operators, dates and text
   • –Null values

3. Module 3

   Joining and aggregating

   • –Inner and outer joins
   • –GROUP BY and HAVING
   • –Aggregate functions

4. Module 4

   Advanced analysis

   • –Subqueries and CTEs (WITH)
   • –Window functions: rankings, running totals
   • –Business case studies

Queries on a realistic company database. Groups of up to 10 participants, in a virtual classroom or at your premises, with a practitioner trainer. For 30 days after the course, you can email your questions to the trainer.

• Exercise database and answers
• SQL cheat sheet
• Collection of standard analysis queries

Initial assessment, hands-on exercises and a final quiz. Certificate of attendance; Onarcle certificate of achievement from a 70% score on the final quiz.