SQL Intermediate 2-Day Course, Birmingham or Virtual

Schedule

Mon, 06 Aug, 2018 at 11:00 am to Thu, 30 Oct, 2025 at 04:00 pm

UTC+01:00

Location

One Victoria Square | Birmingham, EN

Advertisement
SQL Intermediate 3-Day Course
With SQL, one can easily and quickly, with the use of queries, retrieve valuable information, trends, summari
About this Event

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

Advertisement

Where is it happening?

One Victoria Square, One Victoria Square, Birmingham, United Kingdom

Event Location & Nearby Stays:

Tickets

GBP 400.00 to GBP 1401.99

Icon
Know what’s Happening Next β€” before everyone else does.
PCWorkshops

Host or Publisher PCWorkshops

Ask AI if this event suits you:

Discover More Events in Birmingham

OVER 30s DAYTIME CLUBBING BIRMINGHAM
Sat, 25 Oct at 03:00 pm OVER 30s DAYTIME CLUBBING BIRMINGHAM

Sector 57, Birmingham

HALLOWEEN
BodyHeal - HIPS, PELVIS & LOWER BACK
Sat, 25 Oct at 03:00 pm BodyHeal - HIPS, PELVIS & LOWER BACK

498-506 Moseley Road, Birmingham

WORKSHOPS HEALTH-WELLNESS
Aston Villa FC vs Manchester City FC at Villa Park
Sat, 25 Oct Aston Villa FC vs Manchester City FC at Villa Park

Villa Park

TRIPS-ADVENTURES
Turning The Tables on Cancer
Sat, 25 Oct at 03:00 pm Turning The Tables on Cancer

PIRATE.COM - Rehearsal & Recording Studios

NONPROFIT
Girls Get Spooky: Gal-loween Party \ud83c\udf83
Sat, 25 Oct at 04:00 pm Girls Get Spooky: Gal-loween Party πŸŽƒ

Birmingham City Centre

PARTIES ENTERTAINMENT
Amapiano Sip and paint \ud83c\udfa8
Sat, 25 Oct at 04:00 pm Amapiano Sip and paint 🎨

Braai Spot

ART SIP-AND-PAINT
Gospel Express 21st Anniversary 2025
Sat, 25 Oct at 04:00 pm Gospel Express 21st Anniversary 2025

Beacon Church Pheasey

October Read the Room Book Club Event
Sat, 25 Oct at 04:00 pm October Read the Room Book Club Event

Crowne Plaza Birmingham City Centre, an IHG Hotel

ART WORKSHOPS
MS SQL Server Advanced 2-Day Course, Birmingham
Thu, 02 Aug at 11:00 am MS SQL Server Advanced 2-Day Course, Birmingham

One Victoria Square

WORKSHOPS
SQL Intermediate 2-Day Course,  Birmingham or Virtual
Mon, 06 Aug at 11:00 am SQL Intermediate 2-Day Course, Birmingham or Virtual

One Victoria Square

WORKSHOPS VIRTUAL
Python Programming Beginners 3-Day Course, Birmingham
Mon, 06 Aug at 11:00 am Python Programming Beginners 3-Day Course, Birmingham

One Victoria Square

WORKSHOPS IT
Time Management Training (1-day course Birmingham)
Thu, 14 Feb at 09:00 am Time Management Training (1-day course Birmingham)

Birmingham Central

WORKSHOPS HEALTH-WELLNESS
Treasure Hunt Birmingham - Tow Paths and Trades - 1\u00bd - 2\u00bd hours
Fri, 24 Apr at 08:00 am Treasure Hunt Birmingham - Tow Paths and Trades - 1Β½ - 2Β½ hours

Birmingham School of Art

FESTIVALS WORKSHOPS
Google Analytics 4 ( GA4) Training Course - BIRMINGHAM
Tue, 30 Jun at 09:00 am Google Analytics 4 ( GA4) Training Course - BIRMINGHAM

Comfort Inn

WORKSHOPS
Phlebotomy & Simulated Practice Training in Birmingham
Wed, 04 Nov at 09:00 am Phlebotomy & Simulated Practice Training in Birmingham

Passion4Training

WORKSHOPS HEALTH-WELLNESS
Three Embossed Hanging Decorations
Sat, 02 Oct at 10:00 am Three Embossed Hanging Decorations

The Old Print Works

WORKSHOPS ART
Rowheath Community Garden - Fridays
Fri, 13 May at 10:00 am Rowheath Community Garden - Fridays

Rowheath Pavilion

HEALTH-WELLNESS
Holloway Hall Community Garden
Mon, 16 May at 10:00 am Holloway Hall Community Garden

Holloway Hall

HEALTH-WELLNESS
Breathwork Healing Session \u2022 Joy of Breathing \u2022 Birmingham
Mon, 19 Sep at 06:00 pm Breathwork Healing Session β€’ Joy of Breathing β€’ Birmingham

Soul Dimension

HEALTH-WELLNESS MEDITATION
If you Travel & Live Luxe in Birmingham, UK You Need to Own a Travel Biz!
Tue, 14 Nov at 07:45 pm If you Travel & Live Luxe in Birmingham, UK You Need to Own a Travel Biz!

Hilton Garden Inn Birmingham Brindleyplace

WORKSHOPS BUSINESS

What's Happening Next in Birmingham?

Discover Birmingham Events