MySQL Intermediate 3-day Course
Learn how to get valuable information, trends, summaries, statistics and insights from your company data. This course is ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information. This course uses MySQL Workbench. MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
Prerequisites: Understanding of data
Who should attend: Beginners, starting from scratch, going through to intermediate
Session 1,2and 3: Comprehensive revision of mySql select queries, covering WHERE clauses, In, Between, AND/OR, Distinct, Limit, Expressions, CASE, working with nulls Inner joins, aggregates.
Session 4: LIMIT, UNION and AGGERGATE Functions
The LIMIT clause, Union, Union all, Aggregate, GroupBy , Rollup with group By, Having.
Session 5: Joins and Subqueries. Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products. Correlated and uncorrelated Subqueries.
Session 6: Numeric and Character Functions. DATE, TIME and Other functions.
Session 7: Create, alter and drop Views. Stored procedures, without and with parameters. Custom Functions.
Session 8: Create and drop Databases. Create, alter and drop Tables. Datatypes. Constraints.
Session 9: Create, alter and drop Indexes.
Session 10: Managing Data
Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits
Session 11: Access Control Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges
Session 12: Import and Export
What is included in this mySQL Course:
mySQL Course Certificate on completion (assessment based)
mySQL Course notes
Practical mySQL Course exercises, mySQL Course Homework / mySQL Course Revision work
Bring your own laptop, or make arrangements beforehand to use ours
Tea, coffees, but no lunch
After the course, 1 free, online session forquestions or revision on the mySQL Course.
Max group size on this mySQL Course is 4.