SQL Essentials
SQL Essentials
all you need to know as a junior dev
About the Book
RDBMS, or Relational Database Management Systems are the most popular systems today in managing large databases. Most of the data management applications are backed up by an RDBMS like MySQL, or Postgres, or Oracle, or SQL Server or other. For that reason, it is very important to learn SQL, Structured Query Language, the language that is used to retrieve and manipulate data that are stored inside a relational database. MySQL is going to be the RDBMS that we will install and use for learning. MySQL is very popular in many production systems. So, learning to work with MySQL will give you a very good asset as a Web developer.
About the Author
Table of Contents
- Credits To Photo on Cover Page
-
About and Copyright Notice
-
1 - Introduction to RDBMS
- Summary
- Learning Goals
- Introduction
- RDBMS Server
- Client - Server Model
- SQL
- Data Modeling
- Like sheets on EXCEL or Google spreadsheets
- Tables and Business Entities
- Database Design
- MySQL
- Tasks and Quizzes
-
2 - Manage MySQL Server
- Summary
- Learning Goals
- Introduction
- MySQL Installation
- Verifying MySQL Running as Server
- Starting and Stopping MySQL server
- Communicating With MySQL Server
- MySQL Settings
- Closing Notes
- Tasks and Quizzes
-
3 - Basic SQL Commands
- Summary
- Learning Goals
- Introduction
- Create the database
- Select Database To Work With
- Creating Tables
- Inserting Data Into a Table
- Selecting Rows from Table
- Limiting the Rows Returned Using Criteria - where Clause
- Counting number of Entries
- Deleting Rows from Tables
- Updating Rows on a Table
-
likeoperator - Closing Note
- Tasks and Quizzes
-
4 - Adding Columns And Indexes
- Summary
- Learning Goals
- Introduction
- Adding a New Column
- Indexes
- Creating an Index
- Removing an index
- Unique Indexes
- Closing Note
- Tasks and Quizzes
-
5 - Counting And Sorting Records - Limiting Results
- Summary
- Learning Goals
- Introduction
- Creating Table products
- Unique Name
- Inserting a Product
- Counting
- Sorting - Ordering Results
- Limiting Number Of Records Returned
-
Combining
where,order byandlimit - Closing Note
- Tasks and Quizzes
-
6 - Foreign Keys
- Summary
- Learning Goals
- Introduction
- Model Details
- Implementation
-
Create
orderstable - Inserting Orders
- Inserting Wrong Data
- Unique order number
- Inserting Wrong Customer Id
- Try to Insert Bad Data Again
-
Creating
order_itemstable -
Referential Integrity between
ordersandorder_items -
Referential Integrity between
productsandorder_items - Inserting Data Into The Details
- Unique Index On Multiple Columns
- Closing Note
- Valentina Studio
- Tasks and Quizzes
-
7 - Joins, Left Joins And Subqueries
- Summary
- Learning Goals
- Introduction
- Review Database Schema
- Retrieving Data
- Deleting Existing Data
- Inserting Necessary Data
-
Selecting All the Information -
joinorinner join - More Complex Queries
- Closing Note
- Tasks and Quizzes
-
1 - Introduction to RDBMS
Causes Supported
Code Club
https://www.codeclub.org.ukA nationwide network of volunteer-led after school coding clubs for children aged 9-11.
Authors have earned$10,261,184writing, publishing and selling on Leanpub, earning 80% royalties while saving up to 25 million pounds of CO2 and up to 46,000 trees.
Learn more about writing on Leanpub
The Leanpub 45-day 100% Happiness Guarantee
Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets) and MOBI (for Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Top Books
- #1
C++20
Rainer GrimmC++20 is the next big C++ standard after C++11. As C++11 did it, C++20 changes the way we program modern C++. This change is, in particular, due to the big four of C++20: ranges, coroutines, concepts, and modules.
- #2
500 QUIZ MMG COMMENTATI
ALS Medicina Generale500 Quiz degli ULTIMI Concorsi di Medicina Generale (2014/2016/2017/2018/2019)
Riassunti e suddivisi per area con Griglia risposte vuota e Griglia risposte esatte Ministeriale
Commentati con link alla fonte per approfondimento e ausilio allo studio
- #3
R Programming for Data Science
Roger D. PengThis book brings the fundamentals of R programming to you, using the same material developed as part of the industry-leading Johns Hopkins Data Science Specialization. The skills taught in this book will lay the foundation for you to begin your journey learning data science. Printed copies of this book are available through Lulu.
- #4
Ansible for DevOps
Jeff GeerlingAnsible is a simple, but powerful, server and configuration management tool. Learn to use Ansible effectively, whether you manage one server—or thousands.
- #5
Atomic Kotlin
Bruce Eckel and Svetlana IsakovaFor both beginning and experienced programmers! From the author of the multi-award-winning Thinking in C++ and Thinking in Java together with a member of the Kotlin language team comes a book that breaks the concepts into small, easy-to-digest "atoms," along with exercises supported by hints and solutions directly inside IntelliJ IDEA!
- #6
Continuous Delivery Pipelines
Dave FarleyThis practical handbook provides a step-by-step guide for you to get the best continuous delivery pipeline for your software.
- #7
C++ Best Practices
Jason TurnerLevel up your C++, get the tools working for you, eliminate common problems, and move on to more exciting things!
- #8
Visualise, document and explore your software architecture
Simon BrownA short guide to visualising, documenting and exploring your software architecture.
- #9
Discrete Mathematics for Computer Science
Alexander Shen, Alexander S. Kulikov, Vladimir Podolskii, and Aleksandr GolovnevThis book supplements the DM for CS Specialization at Coursera and contains many interactive puzzles, autograded quizzes, and code snippets. They are intended to help you to discover important ideas in discrete mathematics on your own. By purchasing the book, you will get all updates of the book free of charge when they are released.
- #10
Functional Design and Architecture
Alexander GraninSoftware Design in Functional Programming, Design Patterns and Practices, Methodologies and Application Architectures. How to build real software in Haskell with less efforts and low risks. The first complete source of knowledge.
Top Bundles
- #1
Software Architecture for Developers: Volumes 1 & 2 - Technical leadership and communication
2 Books
"Software Architecture for Developers" is a practical and pragmatic guide to modern, lightweight software architecture, specifically aimed at developers. You'll learn:The essence of software architecture.Why the software architecture role should include coding, coaching and collaboration.The things that you really need to think about before... - #2
Software Architecture and Design Practice Reference
2 Books
Dive deeper in Software Architecture with the Design Practice Reference. Learn all about software architecture and design from the books in this bundle:Software Architecture covers topics from quality attributes to designing and modeling components, interfaces, connectors, and containers, all the way to services and microservices. The Design... - #6
Linux Administration Complet
4 Books
Ce lot comprend les quatre volumes du Guide Linux Administration :Linux Administration, Volume 1, Administration fondamentale : Guide pratique de préparation aux examens de certification LPIC 1, Linux Essentials, RHCSA et LFCS. Administration fondamentale. Introduction à Linux. Le Shell. Traitement du texte. Arborescence de fichiers. Sécurité... - #7
The Python Craftsman
3 Books
The Python Craftsman series comprises The Python Apprentice, The Python Journeyman, and The Python Master. The first book is primarily suitable for for programmers with some experience of programming in another language. If you don't have any experience with programming this book may be a bit daunting. You'll be learning not just a programming... - #8
All the Books of The Medical Futurist
6 Books
We put together the most popular books from The Medical Futurist to provide a clear picture about the major trends shaping the future of medicine and healthcare. Digital health technologies, artificial intelligence, the future of 20 medical specialties, big pharma, data privacy, digital health investments and how technology giants such as Amazon... - #10
Mastering Containers
2 Books
Docker and Kubernetes are taking the world by storm! These books will get you up-to-speed fast! Docker Deep Dive is over 400 pages long, and covers all objectives on the Docker Certified Associate exam.The Kubernetes Book includes everything you need to get up and running with Kubernetes!
