This book aims to be an introduction to SQL, the query language we use to interact with relational databases.
This book was published in late 2024.
Flavio Copes, 2024. All rights reserved.
Downloaded from flaviocopes.com.
No part of this book may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher.
The information in this book is for educational and informational purposes only and is not intended as legal, financial, or other professional advice. The author and publisher make no representations as to the accuracy, completeness, suitability, or validity of any information in this book and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its use.
This book is provided free of charge to the newsletter subscribers of Flavio Copes. It is for personal use only. Redistribution, resale, or any commercial use of this book or any portion of it is strictly prohibited without the prior written permission of the author.
If you wish to share a portion of this book, please provide proper attribution by crediting Flavio Copes and including a link to flaviocopes.com.
The goal of this handbook is to get you up and running with SQL, starting from zero knowledge.
You will learn the terms and the main ideas, what is a DBMS, how to structure a database, how to insert data into it, how to query the database.
I will only teach you the basics, and once you’re done with this you’ll have the knowledge you need to dive deeper.
I called this “SQL Handbook” but I assume zero database knowledge, so I’m first going to give you an introduction to databases, in particular relational databases.
The modern world is completely centered around information and data.
What's the difference between information and data?
Data is a singular unit of knowledge. It has no intrinsic value on its own. We can't extract meaning out of it, without knowing more about it.