|
|
|
|
|
|
SQL201S: Accelerated Introduction to SQL Queries using MySQL
|
Book List |
Course Links
|
|
|
|
Tuition: $195.00 per student |
Length: 1 day |
|
|
Synopsis:
Introduction to SQL queries using MySQL. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL201W Accelerated Introduction to SQL Using MYSQL which also includes modifying data and data structures.
|
|
Formats:
Small groups onsite at your facility or online. Single individuals may arrange a private online session.
|
|
Scheduling:
Flexible. Both onsite and online classes are custom scheduled to suit.
|
|
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote
|
|
|
|
| Session 1 | Introduction & Basic SQL Data Retrieval | 3.0 Hours | | |
- Relational database foundations
- Using the MySQL Workbench front end tool.
- Basic SQL data retrieval operations, DML
- SQL Select statement
- SQL Predicates, SQL Where clause
- Operators
- Removing duplicates
- Sorting
- Limit by
| | | Session 2 | SQL Functions, Multi-table Retrieval | 3.0 Hours | | |
- Inner join, outer joins, self join
- Single and multi-valued subqueries
- A look at correlated subqueries
- Unions
- Calculated fields
- Concatenation
- String, date functions
- SQL Aggregate functions (SUM, AVG, etc.)
- Group by
- Having
| |
|
|
Materials:
Manual with PowerPoint slides, text book, and training certificate.
|
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
|
Related Services |
|
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|
