MySql 3-Day Course

From £750 - FAQ's - Included - Course outline - Bespoke SQL Course

MySQL Intermediate 3-day Course

Course summary

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

Course Contents:

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.

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.

Free Examples and Tips