Your Training Partner
+41 22 570 09 31 [fr] +41 55 505 27 60 [en, de]
Contact
Smart Gecko Academy

SQL – Data Analysis for Business Analysts

SQL pour Business Analyse - cylindre de base de donnée

Advantages and objectives

  • understand the selection instruction
  • understanding table joins
  • understanding aggregation functions
  • know how to model database elements
  • understand the concept of relational databases and information normalization
  • evaluate and qualify data structures in an existing system
  • understanding table and column creation
  • understand Excel querying
  • other information storage principles

Course content

Illustration of a conceptual data model
Data analysis is an important part of Business Analysis. The ability to analyze not only the structure of the data, but also the structure of the database, is the basis of any analysis.

SQL (Structured Query Language) is the standard query language for relational databases. The language has evolved since its adoption in the 1980s, and is now available in its 9th version: SQL:2023.

The language is not only integrated into all major databases (Oracle, SQL-Server, DB/2, PostgreSQL, MySQL, MariaDB, etc.), but also forms part of office tools such as Excel and Access.

The use of SQL is therefore an essential part of any Business Analyst’s toolbox.

See also…