Course Overview
MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, you’ll learn how to correctly structure your database, how to author efficient SQL statements and clauses, and how to manage your SQL database for scalable growth. This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications.
Pre-requisites
This course is ideal for those who already have understanding of Web, HTML and CSS. Knowledge of some programming language would be advantage.
MySQL Basic - Schedule
|
Day 1
|
|
09.00am – 10.00am
|
Introduction
- Welcome
- Things you should know before starting this course
- Tools you need for database design
- Installation and configuration
Database Basics
- What is database?
- Different type of databases?
- What’s the role of database in application programming?
|
| 10.00am – 10.30am |
Breakfast
|
|
10.30am – 12.45pm
|
Relational Databases
- Determine the goal of the database
- Consider the current system
- Gathering requirements of the database
- Finding exceptions to the rules
Database Design
- Identifying entities
- Defining the attributes
- Normalisation
- Design considerations
MySQL Basics
- Understanding MySQL terminology: database, table, column, row and field
- Finding information
- Exploring MySQL data types
- Understanding declarative language
MySQL Basics
- Understanding MySQL terminology
- Tables and relations
- Primary and foreign keys and other constraints
- Storage engins
- Exploring MySQL data types
- Understanding declarative language
|
|
12.45pm – 02.15pm
|
Lunch
|
|
02.15pm – 05.00pm
|
SQL Querying
- Creating a database
- Creating and altering table
- Reading from a table
- Adding and updating data
- Grouping data
- Basic functions
- Sorting results
- Limiting results
|
|
Day 2
|
|
09.00am – 10.00am
|
More Advanced Querying
- Date and number functions
- String functions
- Columns aliases
- Comparing strings and numbers with operators
- Filter operations
|
|
10.00am – 10.30am
|
Breakfast
|
|
10.30am – 12.45pm
|
Joining Tables
- Tables aliases
- Relationships
- Types of joins
- Joining tables with matching fields
- Joining tables regardless of matching data
- Complex multi table joins
Subqueries
- Filtering using subqueries
- The EXISTS clause
- Subqueries as alternatives to joins
- Derived tables
|
|
12.45pm – 02.15pm
|
Lunch
|
|
02.15pm – 05.00pm
|
Transaction Control
- What are transactions
- Initiating a transaction
- The COMMIT and ROLLBACK commands
Using Views To Simplify Table Access
- Creating views
- Replacing views
- Dropping views
Extras
- How to read MySQL documentation
- Import and export
- User management and privileges
|
