Databases and SQL for Applications
Relational databases for application developers: data modelling, SQL queries and joins, transactions, indexes and safe, parameterized access from code.
WEB-201 Year 2 3 credits 12 lessons planned ▶ Video lessons coming soon
Offered by HSM University · Web Development
Course content
- 1Why applications need databasesComing
- 2Tables, keys and relationshipsComing
- 3Data modelling and normalizationComing
- 4SELECT, filtering and sortingComing
- 5Joins across tablesComing
- 6Grouping and aggregate functionsComing
- 7Inserting, updating and deleting dataComing
- 8Transactions and integrity constraintsComing
- 9Indexes and query performanceComing
- 10Parameterized queries and SQL injection defenceComing
- 11Migrations and schema changesComing
- 12Capstone: designing and querying an application databaseComing
Requirements
Recommended background. You can start any course at any time.
Description
Relational databases for application developers: data modelling, SQL queries and joins, transactions, indexes and safe, parameterized access from code.
Part of the Information Technology stream, typically taken in year 2.