MySQL Essential Training

1h 59mIntermediate2023-03-14

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.

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. Sring 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. Math Functions

34 - Value functions
35 - Basic math
36 - Simple trigonometry
37 - Logarithms
38 - Radians and degrees

6. Differences from Standard SQL

39 - String concatenation
40 - Quote marks
41 - Integer division
42 - Comments

Conclusion

43 - Thank you