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 : pdf
Downloads: 3833
Created: 2019-04-21

Others MySQL Tutorials

MySQL tutorial for professionals

MySQL – Create Database free PDF

Essential MySQL

MySQL Notes for Professionals

Others related eBooks about Learning MySQL

Database Design

Download free course Database Design, pdf file on 153 pages by Adrienne Watt....

Essential SQL

This book written to provide clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

MySQL Notes for Professionals

Download free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....

Guide Microsoft Access 2010

This document is a quick tutorial guide about Microsoft Access 2010 to learn how to store informations in an easily retrievable form....

Quick Guide to SQL Server Management Studio

This PDF tutorial will teachs you how to install and use SQL Server Management Studio from Home using VPN,it's a free training courses for beginners...

Essential MySQL

This book written to provide clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

Mastering SQL Queries for SAP Business One

SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers..., download free SQL Queries tutorial in PDF (352 pages) created by Gordon Du ....

SQL Interview Questions free PDF

Download free course SQL Interview Questions free PDF, pdf file on 17 pages by tutorialkart.com....

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 ....

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....