LECTURE: Basics of Bluetooth Low Energy and LoRaWAN and their applications in IoT systems PDF

LECTURE

Eng. Almerindo Oliveira

 Escola Superior de Tecnologia e Gestão (ESTG), integrated in the Polytechnic Institute of Porto (IPP), Portugal

 Introduction to SQL: Your Gateway to Data Management

Ever wondered how applications store and retrieve information? This lecture will unlock the power of SQL (Structured Query Language), the essential tool for interacting with databases.

We’ll start with the basic SQL commands and functions you’ll use daily to retrieve and analyze data. Then, we’ll dive into SQL for data definition (DDL), showing you how to structure and organize your databases by creating tables, defining relationships, and setting constraints. You’ll then learn SQL for data manipulation (DML), covering how to insert, update, and delete data within your tables. Finally, we’ll focus on the crucial skill of querying a database, empowering you to extract specific insights and answer critical questions from your datasets.

By the end of this session, you’ll have a solid understanding of how SQL works and be ready to confidently interact with databases.

Monday 2 June 2025

Conference Room

School of Engineering

15:15 – 16:00

 Giorgos Papadourakis and Konstantinos Karampidis