About this ebook
The Relational Database Management System (RDBMS) is extensively used by these tech giants to not only store the large volume of data but as an advanced tool to gain insight from massive volume of data generated by our increasingly digital lives. The Structured Query Language (SQL) is the language of choice to define, manipulate, control and query the data within a RDBMS.
This book is written to serve as your personal guide so you can efficiently and effectively learn and write SQL statements or queries to retrieve from and update data on relational databases such as MySQL. You will be able to install the free and open MySQL user interface with the instructions provided in this book. This will allow you to get hands-on practice utilizing a variety of exercises included in this book, so you will be able to create not only correct but efficient SQL queries to succeed at work and ace those job interview questions.
Some of the highlights of this book are:
- Foundational concepts of SQL language as well as 5 fundamental types of SQL queries namely
- Learn the thumb rules for building SQL syntax or query
- A variety of SQL data types that are a pre-requisite for learning SQL
- Overview of a wide range of user interfaces available with MySQL servers
- Learn how to create an effective database on the MySQL server
- Learn the concept of temporary tables, derived tables and how you can create a new table from an existing one
- Learn how to create new user accounts, update the user password as needed, grant and revoke access privileges
- Learn CREATE VIEW, MERGE, TEMPTABLE, UNDEFINED, Updatable SQL Views and ALTER VIEW
- The properties of SQL transactions as well as various SQL transaction statements with controlling clauses
Don't miss the opportunity to quickly learn a programming language like SQL. Don't you think it can be that easy? If you really want to have proof of all this, don't waste any more time!
Grab your copy now!
