MySQL - Nicholas Brown - Bog

This book is an excellent guide for you on how to use SQL (Structured Query Language) in relational database management systems. Everything related to SQL has been explored, making it the best book for those in need of learning SQL for both academic and commercial purposes. The author helps you understand what SQL is and how you can use it to manage your data. You will learn how to create a new database and create tables within the database. SQL supports and discusses the various data types. You store data for future retrieval. The process and the viewing of table data have been discussed. You will also learn the various SQL statements that you can cause to filter the data that you get for viewing. Examples of these statements include unions, intersections, limits, ordering, comparisons etc. You will also learn how to create and impose constraints on the table columns to restrict the kind of data that can be stored. The author uses many examples in the book and these have been accompanied by thorough explanations. The use of images makes this book the best for SQL Beginners. The following topics are discussed in this book:
- SQL Basics
- Creating a Database
- SQL Data Types
- Creating a Table
- SQL Constraints
- SQL Operators
- Inserting Records
- Retrieving Data
- SQL Joins
- SQL Unions
- Creating Subqueries
- Time and Date
- Views
- Cloning Tables
- Creating Temporary Tables
Subjects include: ms access, sql basics, sql for dummies 2019, ms access sql, mysql, sql server, sql practice problems, sql for dummies, database sql, sybase, mongodb, oracle sql, linux sql, sql quickstart guide