Open Daily: 10am - 10pm | Alley door pickup 10am - 7pm 3038 Hennepin Ave Minneapolis, MN
612-822-4611

  • Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
Learn SQL in a weekend: The definitive guide for creating and querying databases

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

Padial Solier, Antonio

Paperback

Series: Aprende en un Fin de Semana

Databases

ISBN13: 9798593667380
Publisher: Independently Published
Published: Jan 11 2021
Pages: 124
Weight: 0.39
Height: 0.26 Width: 6.00 Depth: 9.00
Language: English
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 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

Also in

Databases

View All