MySQL introduction
Book Preface
About the author
Antun Peicevic is a systems engineer with more than 10 years of experience in the internetworking field. His certifications include CCNA Routing and Switching, CompTIA Network+, CompTIA Security+, and much more. He is the founder and editor of geek-university.com, an online education portal that offers courses that cover various aspects of the IT system administration. Antun can be reached at [email protected].
About this book
This book teaches you how to work with MySQL, a popular relational database management system. The book is written for people without much database experience and is suitable for beginners.
What will you learn
You will learn how to download and install MySQL on your Windows or Linux system. You will learn how to access MySQL through the command line or GUI, how to create a database, how to query a database, sort results, and much more. We will also guide you through some more advanced MySQL topics, such as MySQL functions, aliases, keys, and such.
Table of Contents
Chapter 1 – Introduction
- What is MySQL?
- Database terms
- Install MySQL on Windows
- Install MySQL on Ubuntu
- Access MySQL
- Start the command-line interface
Chapter 2 – SQL command syntax
- SQL commands syntax
- Create a database
- Create a user
- Create a table
- Data types
Chapter 3 – Important SQL commands
- Insert new records
- Modify a table
- Query a database
- Advanced SELECT statements
- Remove a row
- LIMIT clause
- Update the contents of a field
- Sort results
- Use logical operators
Chapter 4 – Advanced usage
- Primary keys
- MySQL functions
- MySQL string functions
- MySQL date functions
- MySQL aggregate functions
- Aliases
- Combine multiple SELECT statements
Download Ebook | Read Now | File Type | Upload Date |
---|---|---|---|
Download here
|
Read Now | May 30, 2020 |
How to Read and Open File Type for PC ?