MySQL

MySQL is a Relational Database Management System and an open source programming language that can be used to create database applications for the web. MySQL is often used to store data for web sites working in conjunction with PHP.

You will learn to Create Databases, Tables, Add, Retrieve data and Manage Relationships, using phpMyAdmin client and be introduced to the PHP programming language.

» Be the first to write a review.

» View full course outline

Key course information

Dates
24/06/12 - 01/07/12

Day(s)
Sun

Duration
2 weeks

Time
10:00 - 17:00

Fees
Full fee: £144
Senior fee: £144
Concession: £72

Venue
KS - Keeley Street

» View location

Course code
CSQ03

Availability
Available
(status updated every 15 mins)

Enrol now

Call enrolments: 020 7831 7831

Still got questions?

computing@citylit.ac.uk or call 020 7492 2515

Course outline

What is the course about?

What topics will we cover?

- Modelling Data
- What are Tables?
- Primary Keys
- Why Relational
- Data Types
- Create Tables in phpMyAdmin
- Adding Rows and Columns
- Using SQL Query Window in phpMyAdmin
- Adding Data
- Updating Data
- Searching Data
- Removing Data
- Working with PHP
- Trouble Shooting
- Summary.

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

- Create Databases using phpMyAdmin
- Create and add Tables to databases.
- Manipulate data from MySQL database using Data Manipulation queries
- Relate different tables from the same database
- Handle errors and corrupt data
- Introduced to PHP scripts that queries MySQL database table.

What level is the course and do I need any particular skills?

- Knowledge of HTML. It is highly recommended that you know HTML Forms
- Completed Level 1 PHP course.
- Knowledge of any web platform scripting language, but not necessary.

How will I be taught, and will there be any work outside the class?

Each student has their own computer.
Presentation will be made using computers, whiteboard, overhead screen and printed notes
Step by step instruction, with demonstration where appropriate, will help you grasp the concept.

Are there any other costs? Is there anything I need to bring?

No.

Do I need to have an interview before I can enrol?

No.

What feedback will I get?

You will receive regular feedback from your tutor throughout the course, as and when appropriate. At the end of the course you and your tutor are asked to assess the progress you have made.

How will I be able to give my views on the course?

Please complete the evaluation form at the end of your course. These are monitored and help us to continually improve our courses.

How do I find out if I can get some support for my learning?

You may be interested in: education and careers advice; financial and childcare support; disability support; support for Deaf and hearing-impaired students; dyslexia support; English and maths support; counselling, and library services (supported learning centre). To find out what may be available to you, and how to apply, see page 213 of the 11/12 course guide, or visit www.citylit.ac.uk/students

When I've finished, what course can I do next?

General information and advice on courses at City Lit is available from the Information and Advice Shop, open Monday to Friday 12:00 – 19:00 during term time, and Monday to Friday 12:00 – 17:00 out of term time. See the course guide for term dates and further details.

Who can I contact for further information?

Tel: 020 7492 2515

computing@citylit.ac.uk

Advice times:

Tuesday 17.30 - 18.30; Wednesday 12.30 - 13.30

You do not need to book an appointment, just come along on the days and at the times listed.

To enrol on a course, call 020 7831 7831.

Contact us

Computing