MySQL Intermediate Course
Short course
Online
Description
-
Type
Short course
-
Level
Intermediate
-
Methodology
Online
-
Duration
3 Days
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.
Facilities
Location
Start date
Start date
About this course
Learn how to get valuable information, trends, summaries, statistics and insights from your company data.
Ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information.
Previous experience with data
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- MySQL
- Database
- Database training
- Web
- Intermediate
- Data Types
- Functions
- Queries
- Access Control
- Joins
Teachers and trainers (1)
Sarah Barnard
Coder, Instructor
Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.
Course programme
SQL Course Contents:
Session 1, 2 Brief revision of Basics
Session 3: Union, Union All, Intersect, Minus
Session 4: AGGERGATE Functions
Aggregate, GroupBy , Rollup with group By, Having.
Session 5: Joins
Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products.
Session 5: Subqueries.
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.
Session 7: Custom Functions.
Session 8: Managing Data
Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits
Session 9: Create and drop Databases. Create, alter and drop Tables. Datatypes. Constraints.
Session 10: Create, alter and drop Indexes.
Session 11: Access Control
Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges
Session 12: Import and Export
MySQL Intermediate Course