MySQL Essential Training (2019)

2h 3mIntermediate2019-07-16

Authors

Bill Weinman

Tech Advocate, Entrepreneur, Programming Expert

Course details

MySQL is one of the most popular database management systems for small- to medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as working with data types, operators, and string and mathematical functions. Plus, learn about the key differences between standard SQL and SQL as implemented by MySQL.

Learning objectives
Writing queries
Creating and updating databases and tables
Data types in MySQL
Using MySQL built-in functions
Working with string and mathematical functions
Differences between MySQL and standard SQL

Skills covered

MySQLDatabase DevelopmentDatabase ManagementEssential TrainingOpen SourceSoftware Development

Concepts

Introduction

Harness the power of MySQL
The exercise files

Overview of SQL

A brief overview of SQL
Database organization
Selecting rows
Selecting columns
Counting rows
Inserting data
Updating data
Deleting data
Joining queries across tables
Finding databases, tables, and columns

Data Types

What are data types
The CREATE TABLE statement
Numeric types
Date and time types
String types
Enumeration types
The SERIAL type alias

Operators and Functions

Comparison operators
Logical operators
Arithmetic operators
Operator precedence
The CASE statement
The IF function

String Functions

String comparisons
Regular expressions
String concatenation
Numeric conversions
Trimming and padding
Case conversion
Substrings
Soundex

Mathematical Functions

Value functions
Basic math
Simple trigonometry
Logarithms
Radians and degrees

Differences from Standard SQL

String contactenation
Quote marks
Integer division
Comments

Conclusion

Thank you