Название: Learn SQL in less than 20 hours: Understand the Language and Do It Yourself
Автор: Juan Pablo Romero Aguirre
Издательство: Independently published
Год: 2024
Страниц: 213
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

Learn SQL in Less Than 20 Hours is your essential guide to mastering SQL and database management. Designed for beginners, this book takes you step by step through the fundamentals and basic commands of SQL, with a practical approach that allows you to start applying what you learn from day one.

In the information age, data is the most valuable resource. Whether you're interested in programming, data analysis, or simply want to acquire a new skill, this book provides you with a solid foundation in SQL, an indispensable language for working with databases and extracting value from information.

This book is structured as a practical course divided into five days, combining theory and exercises that help you consolidate your knowledge. Each chapter is designed to simulate the time you would spend in a real training environment, ensuring effective and results-oriented learning.

Learning SQL in less than twenty hours is possible. However, deliberate and continuous practice reinforces knowledge. If you don't practice it, you forget it. Nevertheless, once you've gone through the content, you have an idea that there's a way to solve a certain problem. And it's easier to find it.

The purpose of this book isn't just to introduce the language. It also aims to guide in practice, understanding, and making effective use of it. The book follows a narrative as if you were in a face-to-face course, with necessary comments and repetitions. These repetitions serve to emphasise and help remember points that are considered important. If you want a structured list where you specifically see a particular section or functionality, check the software developer's SQL reference manual—Oracle, MySQL, etc.—, they are free and available online.

What will you learn?
Day 1 (0-4 hours): Introduction to SQL and basic commands such as SELECT, WHERE, and GROUP BY.
Day 2 (4-8 hours): Subqueries and different types of JOINS.
Day 3 (8-12 hours): Data manipulation operations (DML) such as INSERT, UPDATE, and DELETE.
Day 4 (12-16 hours): Modifying table structures and views.
Day 5 (16-20 hours): Creating and managing indexes, sequences, synonyms, and roles.

At the end of the book, you will find an appendix with practical exercises to solidify your knowledge and become proficient in SQL. Additionally, you have access to a GitHub repository where exercises and code examples are regularly updated, ensuring you always have up-to-date material to practice with.

Requirements:
Being able to read, write, and use a computer. It's that simple! No programming knowledge is needed to learn about databases or SQL. The necessary tools are a computer with database software. The operating system can be Windows or Linux. On these, we install the database software. The software we use can be downloaded for free for these operating systems.

Why choose this book?
Practical approach: Learn SQL effectively through constant practice.
Clear structure: Follow a step-by-step journey that facilitates learning, ideal for beginners.
Versatility: Useful for students, IT professionals, data analysis experts, and anyone interested in programming.
Positive reviews: This book has helped many get started in the world of SQL and databases.