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 FundamentalsCreate your Data ModelLearn how to create SQL QueriesCreate your own Database+50 solved exercises
SUMMARYModule 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], NSERT Entering data, PDATE 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