The least you need to know about Databases and SQL: A practical and very simple approach. For true beginners
by Tiago P. Ribeiro
English | December 19, 2023 | ISBN: N/A | ASIN: B0CQPZPW7R | 110 pages | PDF | 11 Mb
by Tiago P. Ribeiro
English | December 19, 2023 | ISBN: N/A | ASIN: B0CQPZPW7R | 110 pages | PDF | 11 Mb
A practical and very simple approach – for true beginners.
Who is it for?
This book is for you. There are no prerequisites, even if you have never had contact with a Database or the SQL language and if you have, you are welcome too, the exercises will be very useful for you.
What will you learn?
- Database Fundamentals
- Create your Data Model
- Learn how to create SQL Queries
- Create your own Database
- +50 solved exercises
SUMMARY
- Module 01 – Databases: About Databases, Structure of a Relational Database, Relationships Between Tables;
- Module 02 – Data Model: About Data Model, Entity and Relationship Diagram Introduction, [ERD] Relationships;
- Module 03 – SQL: About SQL, [CREATE TABLE], [INSERT] Entering data, [UPDATE] Updating data, [DELETE] Deleting data;
- Module 04 – SQL SELECT: About SQL SELECT, Selecting data, [WHERE] Selecting with filters, [ORDER BY] Ordering data set results, Functions, [GROUP BY], Joining tables;
- Modulo 05 – Solved Exercises: +50 Solved Exercises