SQL is a powerful query language that provides the necessary constructs for data definition and manipulation with a goal set to empower a variety of real-world applications with data-centric tasks. In this seminar, participants will go through the basic SQL constructs and will learn how to construct and execute SQL queries against relational database management systems.
Main takeaways
- Background on the relational model and relational database management systems
- Creating and modifying relations using SQL
- Basic SELECT-FROM-WHERE statements
- Math operations and constant expressions in the SELECT clause
- Boolean and complex conditions in the WHERE clause
- Pattern matching in the WHERE clause
- Cross products and join operations
- Aggregation and Grouping
- Standard aggregation functions
- GROUP BY and HAVING clauses
- UNION, INTERSECT, and EXCEPT operations
- The ORDER BY clause
- NULL values
- Nested queries
Preparation
The seminar includes a hands-on session to get participants familiar with querying a relational database using SQL. Participants will need to install before the seminar
Participants that are not confident or have troubles with the installation can schedule a meeting with the workshop facilitator before the seminar to go though the installation.
Workshop Facilitator
Fotis Psallidas is a PhD Candidate in the Computer Science department supervised by professor Eugene Wu. His research interests include data visualizations and data provenance for interactive systems. Contact Information: