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
Information Source: PCWorkshops | eventbrite

Birmingham

United Kingdom

Searching for information and tickets regarding SQL Intermediate 2-Day Course,  Birmingham or Virtual | One Victoria Square taking place in Birmingham on Oct 7, 2025 (UTC+1)? Trip.com has you covered. Check the dates, itineraries, and other information about SQL Intermediate 2-Day Course,  Birmingham or Virtual | One Victoria Square now! Trip.com has also prepared more similar exciting activities and discounted flight and hotel packages.

SQL Intermediate 2-Day Course,  Birmingham or Virtual | One Victoria Square: Tickets, Dates & Itineraries | Trip.com

SQL Intermediate 2-Day Course,  Birmingham or Virtual | One Victoria Square

SQL Intermediate 2-Day Course,  Birmingham or Virtual | Trip.com

null | Trip.com

Share your results and see what your friends think!

The Grand Hotel Birmingham

Near Birmingham New Street Railway Station|Business District, Birmingham

Cadbury World

Immediate access

Book now for today

Family-friendly Attractions

M27***62

Children love it, it&#39;s a must for families with kids! I saw British schools also organize students to play there. Overall, it&#39;s more worthwhile than the Whisky Museum and the Peter Rabbit Museum. The first two are actually worth going to the shopping malls to buy something, and the doors of the shopping malls are open to passers-by.

National SEA LIFE Centre Birmingham

Elbik

We made a dedicated trip and had a lovely few hours. There was lots to see with split levels that kept your interest. The penguins were nice, the octopus made an appearance and we would have loved to see more of the otters., we see the otters.. There is plenty to see, read and touch. My grand daughter loved it all, the turtle in the tunnel is beautiful . It was clean, and we had a great time, would definitely go back, staff were helpful,its really nice and deserve to be visited again and again.

Birmingham Museum & Art Gallery

Museums

Themed exhibition halls

M43***62

For a smaller town the Art Museum as great. We really enjoyed our visit and would recommend it if you are traveling to Birmingham. Make sure to call ahead to see if they are open.

Chinatown

BBOmBB

There are Chinese Super League, restaurants, and many other specialty restaurants to choose from.
It&#39;s not hard to find something to eat here.
However, the food at this restaurant was a bit disappointing.

Winterbourne House & Garden

Historic buildings

Hossain Hoq Prohor

Winterbourne House &amp; Garden in Birmingham is a hidden gem that perfectly combines history, nature, and charm. The Edwardian house offers a glimpse into early 20th-century family life, beautifully preserved with period furnishings and fascinating exhibits. Surrounding it are seven acres of stunning botanical gardens filled with rare plants, glasshouses, and peaceful walking paths. Each season brings new colors and blooms, making it delightful year-round. The tranquil atmosphere, alongside the picturesque lakeside and tea room, creates an ideal spot for relaxation and photography. Winterbourne House &amp; Garden is a must-visit for anyone seeking beauty, heritage, and serenity in Birmingham.

Time:	Oct 7, 2025 (UTC+1) ENDED
Location:	One Victoria Square

SQL Intermediate 2-Day Course, Birmingham or Virtual | One Victoria Square

Details

Vote

Are you interested in SQL Intermediate 2-Day Course, Birmingham or Virtual?

Recommended Products for SQL Intermediate 2-Day Course, Birmingham or Virtual | One Victoria Square

The Grand Hotel Birmingham

Cadbury World

National SEA LIFE Centre Birmingham

Birmingham Museum & Art Gallery

Chinatown

Winterbourne House & Garden

SQL Intermediate 2-Day Course, Birmingham or Virtual | One Victoria Square

Details

Vote

Are you interested in SQL Intermediate 2-Day Course, Birmingham or Virtual?

Recommended Products for SQL Intermediate 2-Day Course, Birmingham or Virtual | One Victoria Square

The Grand Hotel Birmingham

Cadbury World

National SEA LIFE Centre Birmingham

Birmingham Museum & Art Gallery

Chinatown

Winterbourne House & Garden

More contents about Birmingham