DATABASE AND SQL PRACTICAL GUIDE Very simple approach – for real 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 – About Databases, Structure of a Relational Database, Relationships Between Tables;Module 02 – Data About Data Model, Entity and Relationship Diagram Introduction, [ERD] Relationships;Module 03 – About SQL, [CREATE TABLE], [INSERT] Entering data, [UPDATE] Updating data, [DELETE] Deleting data;Module 04 – SQL About SQL SELECT, Selecting data, [WHERE] Selecting with filters, [ORDER BY] Ordering data set results, Functions, [GROUP BY], Joining tables;Modulo 05 – Solved +50 Solved Exercises