This course is appropriate for any professional who needs to communicate with relational databases, extracting data and/or producing reports. [+]
SQL (Structured Query Language) is a query language used to set up, maintain and retrieve information from modern relational databases. SQL is standardized by the ANSI Institute and represents the Lingua Franca in communicating with such tabular structures.
Whereas many reporting tools produce underlying SQL automatically, understanding the language at greater depth is fundamental in order to optimise data representation, work efficiently in business intelligence environments and to extract and report on data in the best possible way.
In the first part of this course we will study selected, more advanced topics related to the SQL language. The second part will focus on more administrative tasks, i.e. managing data in the databases and its overall integrity.
The course allows ample opportunitiy for practical work with relational databases and seeks to give students the knowledge necessary to write high quality code. The course participants will set up a database in their own environment and will be allowed to work with a number of exercises based on this data.
This course is appropriate for any professional who needs to communicate with relational databases, extracting data and/or producing reports. It is recommended that the participant have prior knowledge of SQL, at the level of having completed Course I: Data Extraction from SQL Databases. More specifically, the user should know how to specify select statements, use SQL functions, perform aggregations and summeries as well as defining joins and set operations in the language. Moreover, the participant should be able to understand and create queries using subqueries and or Common Table Expressions (CTEs).
It should be noted that the course may be adapted to suit the audience, and topics may be incorporated or removed upon request.
This course will cover selected, more advanced topics related to the SQL language, including rolling up data, different forms of conditional logic, inequality joins and window functions. We will also discuss how to create procedures through dynamic SQL as well as recursive queries. In the second part of the course, the focus is on setting up a database and its tables, defining metadata and setting up integrity constraints. Syntax for inserting and updating data in the respective tables will also be treated, followed by a chapter focusing on using the MySQL API to connect to a data base using another programming language (Python) and from another environment.
A full outline of the course contents may be obtained upon request.
CGI Group Inc. ble grunnlagt i 1976 og er verdens femte største uavhengige leverandør av tjenester innen IT- og forretningsprosesser. Med 78.000 medarbeidere over hele verden, leverer CGI en portefølje av ende-til-ende løsninger innen avanserte IT- og forretningskonsulenttjenester, systemintegrasjon og utsetting av IT- og forretningsprosesser. CGIs modell med kundenærhet, et globalt leveransenettverk og egne løsninger bidrar til at kundene hurtigere oppnår resultater og bidrar til deres digitale transformasjon. CGI har en samlet årlig omsetning på over 60 milliarder NOK. CGI-aksjene er notert på TSX (GIB.A) og NYSE (GIB). Hjemmeside: www.cginorge.no [-]