Publisher's Synopsis
***** Important *****
This book contains important concepts, procedures, and steps you need to start designing, creating, and manipulating relational databases using the Structured Query Language (SQL).
SQL is the standard computer language for communicating with databases. It is a unique and simple, yet powerful language that you can use to store, filter, manipulate, and retrieve data to satisfy the present need for timely, relevant, and accurate information.
This book is an all-in-one resource that will help you learn SQL in no time at all. A beginner-friendly book was designed with both the beginner and intermediate users in mind.
This book provides in-depth step-by-step tutorial to help you set up a database, create tables efficiently from scratch or from existing tables, modify table structures, and create a copy of your tables.
You will find practice exercises that you can work on to reinforce the concepts and skills you have learned.
In this book you'll find a comprehensive guide to get you started, including chapters on:
- Data definition language
- SQL joins and union
- Ensuring data integrity
- SQL Data Types
- SQL Commands
- Designing and Creating Databases
- Combining and Joining Tables
- Updating, Removing, and Inserting Data
- Performing Queries
At the end of this book, you will have gained appreciation for SQL and its simple powerful commands. You will be equipped with skills and knowledge that you can use to start a new career or enhance your current work prospects.
