Overview
-
Learn how to create, update, and maintain MySQL databases.
Syllabus
-
Introduction
- Harness the power of MySQL
- The exercise files
- 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
- What are data types?
- The CREATE TABLE statement
- Numeric types
- Date and time types
- String types
- Enumeration types
- The SERIAL type alias
- Comparison operators
- Logical operators
- Arithmetic operators
- Operator precedence
- The CASE statement
- The IF function
- String comparisons
- Regular expressions
- String concatenation
- Numeric conversions
- Trimming and padding
- Case conversion
- Substrings
- Soundex
- Value functions
- Basic math
- Simple trigonometry
- Logarithms
- Radians and degrees
- String contactenation
- Quote marks
- Integer division
- Comments
- Thank you
