Product Description
by Julian James James McKinnon (Author)
Learn SQL (Structured Query Language) from Installation to Database Management and Database Administration
Anything that stores data records is called a database. It can be a file, CD, hard disk, or any number of storage solutions.
From a programming point of view, a database is a methodically structured repository of indexed data information that can be easily accessed by the users for creating, retrieving, updating, and deleting information.
Data can be stored in many forms. Most applications require a database for storing information.
A database can be of 2 types:
- Flat database
- Relational database.
As the name suggests a flat database has a 2-dimensional structure that has data fields and records stored in one large table.
It is not capable of storing complex information, which creates a need for relational databases.
A relational database stores data in several tables that are related to each other. SQL is a computer language we can use to work with various database management systems.
It is the standard language for the various relational database management systems such as Oracle, MySQL, MS Access, SQL Server, Postgres, Sybase, etc.
In this book you can learn:
- What is SQL?
- How this works with your database
- Installation
- Creating a MySQL database
- Users and roles
- How do I normalize the database?
- Security of databases
- The components of a database
- Running the maintenance plan
- Backup and Recover
...and so much more!
This book is an excellent guide for you to learn SQL. It explores everything about this computer database language.
Having said that, take a step ahead and purchase a copy of this book to enjoy more information.
Scroll up to the top of the page and click the "Buy Now" button
