|
After taking this course, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.
Objectives:
After completing this course, students will be able to:
- Choose column types and other column properties
- Create databases and tables
- Insert records, select, update and delete data
- Use conditionals and functions
Topics:
- MySQL
- Choosing column types
- Choosing other column properties
- Using mysql client
- Creating databases and tables
- Inserting records
- Selecting data
- Using conditionals
- Using LIKE and NOT LIKE
- Sorting and limiting query results
- Updating and deleting data
- Using text and numeric functions
- Formatting date and time functions
|