View classes (on this page)

Learn to code in MySQL with our coding & programming short courses in Sydney!

No matter if you work in marketing, sales or finance, a solid understanding of data and the ability to query databases is a huge plus for your career. The first step to pulling your own data is an understanding of SQL, the language used to query most databases. For a decade MySQL has been adopted as the back-end solution for any dynamic or database-driven website. A simple XAMPP server can create a very secure and structured database using MySQL.

SQL is used to communicate with a database and is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database or retrieve data from a database. It doesn't matter if your company uses MySQL, Teradata, Microsoft SQL Server, Oracle or MS Access. SQL is a standardized language and can be used to get data out of almost all relational databases. This course is a quick and easy step by step guide to writing SQL queries to pull your own data. You learn all key functions of SQL and get a basic understanding of how relational databases work in this SQL Beginners Course in Sydney.

Learning outcomes

By the end of this MySQL course, you should be able to:

  • Understand how SQL is used to manipulate data into a database
  • Learn how to create and deal with databases
  • Learn CRUD operations and how to use them to make use out of your database
  • Grasp the concept of SQL clauses, functions, data types
  • How to write simple to complex SQL queries

What will be covered in this MySQL course?

Session 1: Introduction

  • Course Overview and overview of basic database structure
  • Understanding MySQL development environment
  • Software requirements for MySQL database development
  • Creating your first database
  • Basic understanding of the database, RDBMS concepts

Session 2: Database Design

  • How to Design Relational Database
  • Data Integrity by Database Constraints
  • Data Type Constraint
  • Primary Key Constraint and Unique Constraint
  • Foreign Key Relationships and Considerations

Session 3: Database constraints

  • Creating database and tables
  • Database and table structures
  • The Basic SELECT Statement
  • Using Column Alias in SELECT Statement
  • Using Literal Character Strings
  • Perform Arithmetic Operations
  • Use WHERE Clause to Conditionally Select Rows
  • Sorting Data

Session 4: Single Table SELECT Statement

  • Using LIMIT Clause to Constrain the Number of Rows Retrieved
  • Using Comparison Operators
  • Using LIKE Comparison Operator
  • Using Logical Operators
  • Eliminating Duplicate Rows

Session 5: Using Single-Row Functions

  • Using String Functions
  • Using MySQL Date and Time Functions
  • Using MySQL Control Flow Functions
  • Using MySQL Conversion Functions
  • Using MySQL Comparison Functions
  • Using Aggregate Functions in MySQL

Session 6: Querying Multiple Tables

  • Using Inner Joins to Combine Data from Two Tables
  • Using Outer Joins to Combine Data from Two Tables
  • Using Self Joins to Combine Data from the Same Table
  • Using UNION to Append Result Sets

Session 7: Summarizing Data

  • Using Aggregate Functions and Group by Clause in MySQL
  • More About GROUP BY Clause in MySQL
  • Using GROUP BY with HAVING Clause in MySQL
  • Summarizing Data from Multiple Tables in MySQL

Session 8: Data Manipulation

  • Update Statement in MySQL
  • How to update data in a specific order in MySQL
  • How to update top N rows of data in MySQL
  • Use outer join in update
  • How to do cross-table updates in MySQL
  • Using Bulk Insert Statement
  • Basic insert statement

Who is this MySQL course for?

This course can be taken by any student who has little or no knowledge of database development and implementation. If you want to learn solid skills that will improve your career prospects, then this is probably the course for you. Individuals that know their way around databases, can query their own data sets and analyze them are in high demand. If your current or your dream employer collects data of any kind then you should learn how to use this data.

  • Beginners who want to learn SQL.
  • Database developers and database administrators.
  • Mobile application developers.
  • Web developers.
  • Students who wish to learn a new skill to develop their career.

This course has no current classes. Please join our waitlist and we will notify you when we have places available. Join waitlist for MySQL Coding for Beginners

This course has no current classes. Please join our waitlist and we will notify you when we have places available. Join waitlist for MySQL Coding for Beginners

Great reasons to enrol in a short course with us

Small classes

A personal approach means quality learning, so you can enjoy plenty of interaction with your instructor and the chance to ask questions.

Short & sweet

Our short courses & workshops get straight to the point, providing the skills you need with minimal commitment of your precious time.

Facilities & equipment

Our range of venues suit every type of course, are easy to get to, and have the equipment and tech needed to support your learning.

Easy, secure enrolment

Enrol online 24/7 with a safe, convenient 3-step process, and you can change your mind up to 7 days before class starts.

Quality instructors

Our educators bring first-hand experience and knowledge, with up-to-the-minute practices from diverse industries.

For business, or pleasure

Our courses help you rapidly increase your skills and knowledge, for professional development or personal interest.

4.7 starsaverage rating on Google

1,400+courses to choose from

99%customer support rating

Related courses