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: 3882
Created: 2019-04-21

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others MySQL Tutorials

MySQL tutorial for professionals

MySQL – Create Database free PDF

MySQL Notes for Professionals

Essential MySQL

Others related eBooks about Learning MySQL

Graph Databases For Beginners

Whether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....

Microsoft Access 2013 course

Download free Microsoft Office Access 2013 file under 448 pages,step by step to learn Access and build your skills , course tutorial training on pdf by Joyce Cox and Joan Lambert....

Tutorial Oracle Database 11g: SQL Fundamentals in PDF

Download tutorial in PDF about Oracle Database 11g: SQL Fundamentals, free training document for beginners....

Microsoft SQL Server 2012

This PDF tutorial will teachs you how to use SQL Server Data Tools to develop and deploy an Analysis Services project with examples,it's a free training course under 169 pages by Microsoft....

MySQL – Create Database free PDF

Download free course MySQL – Create Database free PDF, pdf file on 3 pages by tutorialkart.com....

Learning Microsoft SQL Server

Download free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....

Database Design, 2nd Edition

This book covers database systems and database design concepts. It provides short, easy-to-read explanations of how to get database design right the first time. It also offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. ...

Oracle Database Notes for Professionals

Download free course Oracle Database Notes for Professionals, pdf file on 117 pages by Stack Overflow Community....

MongoDB Tutorial free PDF

Download free course MongoDB Tutorial free PDF, pdf file on 5 pages by tutorialkart.com....

Learning access-vba PDF course

Download free Access vba tutorial course in PDF, training file in 5 chapters and 207 pages. Free unaffiliated ebook created from Stack OverFlow contributor....