MySQL Programming Course Wales

Book Now Enquire Our Venue
Computer Training MySQL Course MySQL Course MySQL Course MySQL Course MySQL Course

Course Rating

Course Ratings

Out of 18 verified reviews


Recent Feedback


"The trainer's comprehensive coverage of MySQL's fundamentals, from creating databases to writing complex queries, was fantastic."

Susan


"The trainer explained SQL queries and database optimisation in a clear manner. The course materials were helpful, and I appreciated the emphasis on real-world applications."

Gregory


"The practical exercises and real-world scenarios provided valuable insights. I now feel more confident working with MySQL databases."

Arnold


"The trainer's explanations were beginner-friendly, and the course provided a solid foundation for working with MySQL."

Mirko


Price £199 (no VAT) Time 9:00am-2:00pm Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ


Course Overview


MySQL is a powerful, database design and development tool that has become the most significant part of the database market. This course has been designed to teach delegates to quickly learn MySQL. You will learn about developing relational databases through SQL and how to manipulate data and build queries that communicate with more than one table.


This practical introduction to SQL training course is for those who need to be competent extracting data from, and updating data in, relational database servers like Microsoft SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL using ANSI standard Structured Query Language (SQL). In order to master the syntax of the language, the course is highly practical in nature - attendees learn by doing. The focus throughout is on coding SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.


Course Dates 2024


June: 6th, 13th, 20th, 27th

July: 4th, 11th, 18th, 25th

August: 1st, 8th, 15th, 22nd, 29th

September: 5th, 12th, 19th, 26th

October: 3rd, 10th, 17th, 24th, 31st


Who is this course for?


We live in a data-driven world: people search through data to find insights to inform strategy, marketing and operations, and a plethora of other categories. Being able to code using SQL a great employable skill for the IT sector.


Beginners


Introducing SQL

  • Creating and editing SQL
  • About statements, batches and scripts
  • Executing and parsing SQL scripts
  • Using comments
  • About keywords, identifiers, operators, whitespace and case
  • SQL conventions and good practice
  • Working to minimise, trap and find errors


Retrieving data with SQL: first steps

  • Introducing queries: the select statement
  • The clauses of the select statement
  • About optional clauses and mandatory clauses
  • Using from to specify the source table(s)
  • Retrieving entire tables
  • Retrieving specific columns
  • How to build successful queries
  • Types of output: about the result set
  • Using column aliases to rename columns
  • Performing calculations
  • Using numeric and string operators to create derived output
  • Using order by to sort the output
  • Ways of working: some tips


Using where to filter results

  • Working with comparison operators (=, >= etc)
  • Numeric and string based filtering
  • Filtering based on calculations
  • Eliminating duplicate results with distinct
  • The execution order and its traps
  • Column aliases: where you can and cannot use them
  • Extending filters with and and or
  • Solving and/or difficulties with brackets
  • Excluding results with not: some tips
  • Range filtering using between and in
  • Null and its implications explained
  • Catering for null
  • Matching patterns with like


Intermediate


Joining: getting results from multiple tables

  • Qualifying column names
  • Joins explained
  • The different types of joins
  • Mastering the inner join: where syntax
  • Mastering the inner join: inner join syntax
  • Table aliases: why we need them
  • Joining two tables
  • Joining multiple tables


Getting confident with SQL joins

  • The importance of the database diagram
  • What if there is no database diagram?
  • Primary keys and foreign keys explained
  • Locating primary keys and foreign keys
  • Do we need primary keys and foreign keys?
  • Approaching joins the right way
  • Avoiding common join errors


Using standard SQL functions

  • How to use standard SQL functions to modify results
  • How to find the right function
  • Mathematical, string and conversion functions
  • Functions for modifying and calculating dates
  • Formatting numbers to two decimal places
  • Replacing null with a specific value
  • Using standard functions in where
  • Using case to specify output conditions


Advanced


Working with dates

  • Understanding how dates are stored
  • Introducing date functions
  • Converting text dates to date format
  • Extracting parts of a date (day, month, year)
  • Displaying dates in specific date formats
  • Filtering with dates


Grouping and summarising results

  • The difference between tabular and scalar results
  • Using aggregate functions (max(), sum(), avg(), count() etc)
  • The way aggregate functions work
  • Where to use and where not to use aggregate functions
  • Using group by to group results
  • Get group by right every time
  • The need for having: filtering the result table


Inserting, updating and deleting data

  • Inserting single rows
  • Inserting multiple rows
  • Inserting rows by column position
  • Inserting rows by column name
  • Dealing with auto-incrementing values
  • Dealing with nulls when inserting
  • Inserting data from one table into another
  • Updating data
  • Deleting data

Our Clients

Our Clients