SQL Intermediate 2-Day Course, Birmingham or Virtual
SQL Intermediate 3-Day Course With SQL, one can easily and quickly, with the use of queries, retrieve valuable information, trends, summari
MySQL Intermediate Course
The first day is SQL basics, joins, group by's, inserts, updates, and deletes.
The second day covers built in functions like working with dates, subqueries, stored procedures, views, and functions.
The last day is about creating tables with constraints, indexes and importing data.
MySQL Intermediate Course Contents:
Session 1,2 and 3: Brief revision of Basics
Session 4: LIMIT, UNION and AGGREGATE Functions
The LIMIT clause, Union, Union all, Aggregate, Group By , Roll-up with group by, Having.
Session 5 : Joins and Sub-queries.
Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products.
Correlated and uncorrelated Sub-queries.
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
INCLUDED:
- MySQL Intermediate Certificate on completion,
- Course notes, Practical Class exercises.
- To assist after the course: 1-Hour mentoring, online
System requirements: Your MYSQL Database, Workbench query interface and sample data must be ready before the course starts.
Read more: https://pcworkshopslondon.co.uk/mysql-intermediate-course.html
SQL Intermediate 3-Day Course With SQL, one can easily and quickly, with the use of queries, retrieve valuable information, trends, summari
MySQL Intermediate Course
The first day is SQL basics, joins, group by's, inserts, updates, and deletes.
The second day covers built in functions like working with dates, subqueries, stored procedures, views, and functions.
The last day is about creating tables with constraints, indexes and importing data.
MySQL Intermediate Course Contents:
Session 1,2 and 3: Brief revision of Basics
Session 4: LIMIT, UNION and AGGREGATE Functions
The LIMIT clause, Union, Union all, Aggregate, Group By , Roll-up with group by, Having.
Session 5 : Joins and Sub-queries.
Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products.
Correlated and uncorrelated Sub-queries.
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
INCLUDED:
- MySQL Intermediate Certificate on completion,
- Course notes, Practical Class exercises.
- To assist after the course: 1-Hour mentoring, online
System requirements: Your MYSQL Database, Workbench query interface and sample data must be ready before the course starts.
Read more: https://pcworkshopslondon.co.uk/mysql-intermediate-course.html