Learning MySQL
Download free course intituled Learning MySQL, a PDF document created by StackOverflow Documentation, a 300-page tutorial on the basics of this language to learn and manipulate databases created with MySQL.
Table of contents
- Get started with MySQL
- Examples of information schemas
- ALTER TABLE
- ALTER COLUMN OF TABLE
- ALTER table add INDEX
- Change the auto increment value
- Renaming a MySQL table
- Renaming a column in a MySQL table
- LOAD DATA INFILE
- import Export
- MySQL client
- Basic connection
- Execute commands
- Run the command from a string
- Comment Mysql
- Add comments
- Definitions of comment tables
- Configuring the SSL connection
- Add keys to MySQL
- Test the SSL connection
- SSL application
- Configuration and adjustment
- InnoDB minimum configuration
- Securing MySQL Encryption
- Connection with UTF-8 using various programming languages.
- Basic conversion
- Convert all tables in a database
- Creation of databases
- Create a database, users and grants
- Table creation
- Base table creation
- Set default values
- Table creation with primary key
- Delete all rows from a table
- Delete deletions
- TINYINT as an alternative
- VARCHAR as an alternative
- Add a new option
- Error 1055: ONLY_FULL_GROUP_BY: Something is not in the clause
- Regular expressions
- Read the value of the JSON array
- AUTO_INCREMENT key
- Server information
- INSERT
- INSERT SELECT (Insert data from another table)
- INSERT with AUTO_INCREMENT + LAST_INSERT_ID ()
- Install the Mysql Container with Docker-Compose
- What character set and what collection?
- Defining character sets on tables and fields
- JOINS: Join 3 table with the same id name.
- Inner-join for 3 tables
- Joined visualization
- Insert a simple JSON
- Insert mixed data into a JSON field.
- Have an INDEX
- Limit and Offset Relationship
- LIMIT clause with an argument
- LIMIT clause with two arguments
- MySQL Admin
- Select the optimization of the declaration
- Optimizing the storage layout for InnoDB tables
- Build a composite index
- LOWER () / LCASE ()
- REPLACE()
- SUBSTRING ()
- UPPER () / UCASE ()
- LENGTH()
- CHAR_LENGTH ()
- HEX (str)
- Date and time operations
- GROUP USING THE SUM Function
- Group using the MIN function
- GROUP USING THE COUNT FUNCTION
- GROUP BY using HAVING
- Group using Group Concat
- GROUP BY with AGGREGATE functions
- partitioning
- Using backticks
- Create a function
- Create a procedure with built preparation
- Stored Procedure with IN, OUT, INOUT Parameters
| Size | 2134.07 Kb |
|---|---|
| File type | |
| Downloads | 3928 |
| Created | 2019-04-21 |
Others MySQL tutorials
Others related eBooks about Learning MySQL
-
Microsoft Access Tutorial
Downloaf Microsoft Access Tutorial in PDF , it'a a free training document intended for beginner's to learn the basics of Microsoft Access database....
-
Guide to NoSQL with Azure Cosmos DB
Download free course Guide to NoSQL with Azure Cosmos DB, pdf file on 205 pages by Gaston C. Hillar , Daron Yöndem....
-
Download PLSQL tutorial in pdf
Download free PLSQL tutorial course in PDF, training file in 14 chapters and 47 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
-
SQL Server Backup and Restore
Download free course SQL Server Backup and Restore, pdf file on 381 pages by Shawn McGehee....
-
Oracle Advanced PL/SQL Developer Professional Guide
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta ....
-
PostgreSQL tutorial
Download free PostgreSQL tutorial course in PDF, training file in 29 chapters and 93 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
-
Introduction to SQL
This tutorial is a brief overview about SQL language and free training document courses under 39 pages for beginners....
-
Performance Tuning with SQL Server Dynamic Management Views
Download free course Performance Tuning with SQL Server Dynamic Management Views, pdf file on 326 pages by Louis Davidson, Tim Ford....
-
Oracle Database Notes for Professionals
This book is the definitive guide to undocumented and partially-documented features of the Oracle Database server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to Oracle databases. It is packed with of experience over deca...
-
Oracle database tutorial
Download free Oracle tutorial course in PDF, training file in 33 chapters and 104 pages. Free unaffiliated ebook created from Stack OverFlow contributor....