| Outcomes
By the end of the course, learners will be able to:
|
Level: | 01 |
| Duration: | 20 Hours | |
| Pre-requisites: | Data Engineering: Level 01 | |
| What’s next: | NA |
Course
Structured Query Language (SQL): Level 01
Structured Query Language (SQL) is a domain-specific language used in querying data and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables. SQL offers two main advantages over the older read–write APIs such as ISAM or VSAM; firstly, it introduced the concept of accessing many records with one single command; secondly, it eliminates the need to specify how to reach a record, e.g. with or without an index. Originally based upon relational algebra and tuple relational calculus, SQL consists of many types of statements, which may be informally classed as sub-languages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML). The scope of SQL includes data query, data manipulation (insert, update and delete), data definition (schema creation and modification), and data access control.