Learn SQL in a weekend: The definitive guide for creating and querying databases

By Antonio Padial Solier

The best-seller finally in English

Without 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 ContentsPREFACECHAPTER 1.1 - INTRODUCTIONCHAPTER 1.2 - WHAT IS A RELATIONAL DATABASE?CHAPTER 1.3 - PREPARING THE ENVIRONMENTCHAPTER 1.4 - WHAT CAN I STORE IN A DATABASE?CHAPTER 1.5 - YOUR FIRST DATABASECHAPTER 1.6 - CREATING TABLESCHAPTER 1.7 - STORE AND QUERY DATACHAPTER 1.8 - FIRST DAY SUMMARYCHAPTER 2.1 - SQL LANGUAGECHAPTER 2.2 - CREATE, ALTER AND DROP TABLECHAPTER 2.3 - INSERT INTOCHAPTER 2.4 - USAGE OF PRIMARY KEYCHAPTER 2.5 - BASIC SELECTCHAPTER 2.6 - SELECT + WHERECHAPTER 2.7 - JOINCHAPTER 2.8 - UNION AND EXCEPTCHAPTER 2.9 - UPDATE AND DELETECHAPTER 2.10 - SECOND DAY SUMMARYCHAPTER 3.1 - FUNCTIONSCHAPTER 3.2 - GROUP BYCHAPTER 3.3 - SUBQUERIESCHAPTER 3.4 - VIEWSCHAPTER 3.5 - OUTER JOINCHAPTER 3.6 - OPERATIONS WITH DATETIMECHAPTER 3.7 - FINAL PROJECT

• Format: Paperback
• Language: English
• ISBN: B08SPM81J3
• ISBN13: 9798593667380
• Release Date: January 2021
• Publisher: Independently Published
• Length: 124 Pages
• Weight: 0.39 lbs.
• Dimensions: 0.3" x 6.0" x 9.0"