MySQL Introduction will allow you to work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various SQL commands, indexes, and views, you can work with and modify data efficiently within a database.
Course Outline:
- Definitions
- Databases and the Web
- Database Design
- Identifying Entities
- Creating Entity-Relationship Diagrams
- Identifying Relationships
- Creating Tables
- Normalization
- Basic SQL Statements
- SQL/MySQL Functions
- Table Joins
- Subqueries
- User Management
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.