Book Description

The best-seller finally in EnglishWithout prior knowledge. Learn to manage and query databases quickly and easily.Are you developing a webpage and you want to use MySQL to store information? Are you studying and you are stuck on the database management subject? Do you want to learn SQL to improve your curriculum or change your career? Or simply, do you have curiosity to learn this language and its possibilities? To all of you, welcome. You have found the appropriate book. Over 100 examples, numerous exercises, and additional subjects to learn the necessary to use SQL in your projects. Table of Contents PREFACE CHAPTER 1.1 - INTRODUCTION CHAPTER 1.2 - WHAT IS A RELATIONAL DATABASE? CHAPTER 1.3 - PREPARING THE ENVIRONMENT CHAPTER 1.4 - WHAT CAN I STORE IN A DATABASE? CHAPTER 1.5 - YOUR FIRST DATABASE CHAPTER 1.6 - CREATING TABLES CHAPTER 1.7 - STORE AND QUERY DATA CHAPTER 1.8 - FIRST DAY SUMMARY CHAPTER 2.1 - SQL LANGUAGE CHAPTER 2.2 - CREATE, ALTER AND DROP TABLE CHAPTER 2.3 - INSERT INTO CHAPTER 2.4 - USAGE OF PRIMARY KEY CHAPTER 2.5 - BASIC SELECT CHAPTER 2.6 - SELECT + WHERE CHAPTER 2.7 - JOIN CHAPTER 2.8 - UNION AND EXCEPT CHAPTER 2.9 - UPDATE AND DELETE CHAPTER 2.10 - SECOND DAY SUMMARY CHAPTER 3.1 - FUNCTIONS CHAPTER 3.2 - GROUP BY CHAPTER 3.3 - SUBQUERIES CHAPTER 3.4 - VIEWS CHAPTER 3.5 - OUTER JOIN CHAPTER 3.6 - OPERATIONS WITH DATETIME CHAPTER 3.7 - FINAL PROJECT