SQL Intermediate 2-Day Course, IN Birmingham or Virtual

Actions Panel

SQL Intermediate 2-Day Course, IN 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

By PCWorkshops

Location

One Victoria Square

One Victoria Square Birmingham B1 1BD United Kingdom

Refund Policy

No Refunds

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

Organised by

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

From £200