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
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
0. Introduction
- 01 - Harness the power of MySQL
- 02 - The exercise files
1. Overview of SQL
- 03 - A brief overview of SQL
- 04 - Database organization
- 05 - Selecting rows
- 06 - Selecting columns
- 07 - Counting rows
- 08 - Inserting data
- 09 - Updating data
- 10 - Deleting data
- 11 - Joining queries across tables
- 12 - Finding databases, tables, and columns
2. Data Types
- 13 - What are data types
- 14 - The CREATE TABLE statement
- 15 - Numeric types
- 16 - Date and time types
- 17 - String types
- 18 - Enumeration types
- 19 - The SERIAL type alias
3. Operators and Functions
- 20 - Comparison operators
- 21 - Logical operators
- 22 - Arithmetic operators
- 23 - Operator precedence
- 24 - The CASE statement
- 25 - The IF function
4. String Functions
- 26 - String comparisons
- 27 - Regular expressions
- 28 - String concatenation
- 29 - Numeric conversions
- 30 - Trimming and padding
- 31 - Case conversion
- 32 - Substrings
- 33 - Soundex
5. Mathematical Functions
- 34 - Value functions
- 35 - Basic math
- 36 - Simple trigonometry
- 37 - Logarithms
- 38 - Radians and degrees
6. Differences from Standard SQL
- 39 - String contactenation
- 40 - Quote marks
- 41 - Integer division
- 42 - Comments
Conclusion
- 43 - Thank you