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