Skip to main content

Overview

CRN Code:

21891

Start date:

09/10/2019

End date:

06/11/2019

Attendance:

Every Wednesday for 5 weeks, 6:00pm-9:00pm

Campus:

Chadstone

Price:

$460

Become confident using SQL (Structured Query Language), a language used by commercial database management systems such as Oracle, Microsoft SQL and MySQL. Learn to set up a database structure for a typical small business how to retrieve and modify data as well as creating and altering database objects, like tables and views. Course includes manual and CD allowing students to set up their own MySQL database management system, students are also able to connect to the MySQL server to access and control the database.


Requirements

    • USB memory stick (2GB minimum)
    • Pen and notebook
    • There are no prerequisites for this course

Outcomes

    • Install and set up MySQL Database Management System plus Apache Web Server and PHP programming language
    • Use client tools to access MySQL database server; MySQL command-line console and phpMyAdmin graphical user interface
    • Learn SQL Syntax, create Database, run set up scripts to create tables for class exercises
    • Retrieve data - SELECT statements, grouping data, joining tables, subqueries
    • Manipulate data – data manipulation language (DML) Statements – INSERT, UPDATE, DELETE, controlling transactions
    • Create, alter and delete Database Object - data definition language (DDL)

Enquire Now

Contact details

All information is correct at the time of printing but subject to change.

Copyright © 2019 Holmesglen CRICOS Provider Code: 00012G RTO-0416 ABN: 40 096 756 729