What do you think?
Rate this book
MySQL: Database, In 8 Hours, For Beginners, Quick Start Guide: MySQL Language, Crash Course Textbook & Exercises
The length of this book is around 200 pages; you may not complete reading this book in 8 hours!
About This Book
"MySQL Database" is a textbook for high school and college students; it covers all essential MySQL database knowledge. You can learn complete primary skills of MySQL administration fast and easily.
The textbook includes a lot of practical examples for beginners and includes exercises for the college final exam, the engineer certification exam, and the job interview exam.
"MySQL Database" is a useful textbook for beginners. The straightforward definitions, the plain examples, the elaborate explanations and the neat layout feature this helpful and educative book. You will be impressed by its distinctive and tidy writing style. Reading this book is a great enjoyment!
Note
This book is only suitable for MySQL database beginners, high school students and college students; it is not for the experienced MySQL administrators.
Table of Content
Chapter 1
What is MySQL?
The Feature of Database
Install MySQL
Show Databases
Summary
Chapter 2
Use a Database
Show Tables
Create a Database
Remove a Database
Create a Table
Remove a Table
MySQL Comments
Create a Database (2)
Remove a Database (2)
Create a Table (2)
Remove a Table (2)
Table Format
Data Types
Field Modifiers
A Table Sample
Insert Table Data
Summary
Chapter 3
Display Table Data
Alter Table Commands
Update Data
Remove Data
Describe Command
Update Fields
Add Records
Show Specified Fields
Show a Specified Record
Summary
Chapter 4
Create Another Table
Primary Key
Delete Data
Sort Data
Sort Ascending
Sort Descending
Copy a Table
Comparison Operators
Between…And…
Not Equal
Less / More Than
Summary
Chapter 5
And Operator
Or Operator
“And” & “Or”
“Or” & “And”
In Operators
Like %
Like _
Regular Expression
MySQL REGEXP
Connect Fields
Trim Spaces
Field Alias
Arithmetical Operators
Text Functions
Summary
Chapter 6
Numeric Functions
Datetime Functions
System Functions
Count the Records
Display the Unique Values
Count the Unique Values
Total Values
Group Data
Filter Group
Summary
Chapter 7
Select Precedence
Show Multiple Tables
Union Tables
Sort the Combined Table
Join Multiple Tables
Join Tables(1)
Join Tables(2)
Left Join
Right Join
Mysql Transaction
Summary
Chapter 8
Roll Back
Rename a Table
Get Random Record
Get Max/Min Records
MySQL Variable (1)
MySQL Variable (2)
Create a View
Alter the View
Remove the View
Create Stored Procedure
Alter Stored Procedure
Remove Stored Procedure
Summary
Appendix
MySQL Statements
MySQL Questions & Answers
Questions
Answers<
About This Book
"MySQL Database" is a textbook for high school and college students; it covers all essential MySQL database knowledge. You can learn complete primary skills of MySQL administration fast and easily.
The textbook includes a lot of practical examples for beginners and includes exercises for the college final exam, the engineer certification exam, and the job interview exam.
"MySQL Database" is a useful textbook for beginners. The straightforward definitions, the plain examples, the elaborate explanations and the neat layout feature this helpful and educative book. You will be impressed by its distinctive and tidy writing style. Reading this book is a great enjoyment!
Note
This book is only suitable for MySQL database beginners, high school students and college students; it is not for the experienced MySQL administrators.
Table of Content
Chapter 1
What is MySQL?
The Feature of Database
Install MySQL
Show Databases
Summary
Chapter 2
Use a Database
Show Tables
Create a Database
Remove a Database
Create a Table
Remove a Table
MySQL Comments
Create a Database (2)
Remove a Database (2)
Create a Table (2)
Remove a Table (2)
Table Format
Data Types
Field Modifiers
A Table Sample
Insert Table Data
Summary
Chapter 3
Display Table Data
Alter Table Commands
Update Data
Remove Data
Describe Command
Update Fields
Add Records
Show Specified Fields
Show a Specified Record
Summary
Chapter 4
Create Another Table
Primary Key
Delete Data
Sort Data
Sort Ascending
Sort Descending
Copy a Table
Comparison Operators
Between…And…
Not Equal
Less / More Than
Summary
Chapter 5
And Operator
Or Operator
“And” & “Or”
“Or” & “And”
In Operators
Like %
Like _
Regular Expression
MySQL REGEXP
Connect Fields
Trim Spaces
Field Alias
Arithmetical Operators
Text Functions
Summary
Chapter 6
Numeric Functions
Datetime Functions
System Functions
Count the Records
Display the Unique Values
Count the Unique Values
Total Values
Group Data
Filter Group
Summary
Chapter 7
Select Precedence
Show Multiple Tables
Union Tables
Sort the Combined Table
Join Multiple Tables
Join Tables(1)
Join Tables(2)
Left Join
Right Join
Mysql Transaction
Summary
Chapter 8
Roll Back
Rename a Table
Get Random Record
Get Max/Min Records
MySQL Variable (1)
MySQL Variable (2)
Create a View
Alter the View
Remove the View
Create Stored Procedure
Alter Stored Procedure
Remove Stored Procedure
Summary
Appendix
MySQL Statements
MySQL Questions & Answers
Questions
Answers<
217 pages, Kindle Edition
Published September 28, 2022
9 people are currently reading
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.