MySQL Coding Course for Beginners

What you'll learn

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 storage and information production (query databases) is a huge plus for your career. The first step to pulling your own information is an understanding of SQL, the standard language used to query a Relational database. Once an SQL query has been tested it can be run against any brand of database that is compliant.

SQL is used to communicate with a database.  SQL is not only a Query language it also allows for editing/updating and table creation.  The Rules of Relational Database mean that a properly structured data table can be accessed knowing that you won't lose or miss anything.

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 query 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 course, you should be able to:

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

 * CRUD = Create, Read, Update & Delete

Course content

What will be covered in this MySQL Course for Beginners?

Session 1: Introduction

• Course Overview and overview of basic relational database (RDBMS) structure
• Understanding MySQL development environment
• Software requirements for MySQL database development
• Using your first database

Session 2: Database Design

• Design Considerations for a well-formed table is an RDBMS
• Data Integrity by Database Constraints
• Data Type Constraint
• Primary Key Constraint and Unique Constraint
• Foreign Key Relationships and Considerations

Session 3: Database constraints

• Examine database and tables
• Using 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 Date and Time Functions
• Using Control Flow Functions
• Using Conversion Functions
• Using Comparison Functions
• Using Aggregate Functions

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
• More About GROUP BY Clause
• Using GROUP BY with HAVING
• Summarizing Data from Multiple Tables

Session 8: Data Manipulation

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

Intended audience

Who is this MySQL Course for?

• 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.

Course materials

What to bring to class

You will need MySQL Community Edition installed to your laptop or computer, which is free to download.