Top
Email
Bottom
MySQL 5.5
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Download our latest
Android and iPhone apps ...
Click on whichever one of our Apps you are interested in

MySQL 5.5 course at a glance

Pages
280No of slides in the Manual
Exercises
10Total No of Exercises
Sections
15No of main topics, see index below
Public
NoPublic course in the UK and Ireland
On-Site
YesWe can come to your venue
Level
11 - Beginners
2 - Intermediate
3 - Advanced
Days
2Week days but we can put on weekend courses
Duration:
Minimum skill level required:
On-Site course:
Public course:
Sections:
No of exercises:
No of pages in the manual:
Pre-Requisite course(s):
Suggested further course(s):
Price guide:
2 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
15
10
280
PHP 5.5
Essential CSS 3 Essential JavaScript PHP 7.4
Contact us for the latest pricing

Using MySQL 5.5 with PHP Training Course
Exercise highlights

Selecting and limiting records in MySQL
Joining Tables in MySQL
Creating indexes in MySQL
Exporting and importing using a MySQL database

Index of Using MySQL 5.5 with PHP Training Course

Section
Section Name
Pages

One
Introduction to MySQL
2

 
- What is SQL used for ?
3

 
- Why use MySQL with PHP ?
4

 
- Definition of a Database
5

 
- Using MySQL with PHP
6

Two
Simple MySQL Queries in PHP
8

 
- Introduction
9

 
- Show Tables
10

 
- Show Columns
14

 
- Describe
17

 
- Selecting Data from a Table
18

 
- Counting records in a Table
21

 
- Selecting Data from a Table
23

 
- Selecting Columns from a Table
24

 
- Selecting Literals from a Table
25

 
- Selecting Literals from Dual
26

 
- Exercise One
27

 
- Column Manipulation with MySQL Functions
29

 
- Concatenating Columns in MySQL
33

 
- Performing Calculations in MySQL
34

 
- Using Variables in MySQL
35

 
- Using mysqli_fetch_array()
37

 
- Using Aliases in MySQL
38

 
- Ordering Data in MySQL
41

 
- Ordering more than One Column
43

 
- Manipulating Dates using date_add()
44

 
- Displaying Dates using date_format()
46

 
- Exercise Two
48

Three
MySQL Errors
56

 
- Determining Errors in the SQL
57

 
- Using mysqli_errno() and mysqli_error()
58

Four
Limiting Data Selected with a Where Clause
59

 
- Limiting Data in MySQL
60

 
- Different types of MySQL Where Clauses
62

 
- Using Table Aliases
73

 
- Combining Where Clauses
75

 
- Different types of MySQL Where Clauses
76

 
- Handling Nulls in Where Clauses
77

 
- Using Functions in Where Clauses
78

 
- Using PHP Variables in Where Clauses
80

 
- Exercise Three
81

Five
Aggregating Values in MySQL
85

 
- Introduction
86

 
- Using Group By
88

 
- Using Having with Group By
90

 
- Using With Rollup to Total Grouping
91

 
- Using Distinct()
92

 
- Exercise Four
93

Six
Regular Expressions in MySQL
96

 
- Introduction
97

 
- Testing for 'Contains' within a String
98

 
- Starts or Ends using Line Anchors
99

 
- Starts and Ends using Line Anchors (or)
100

 
- Using the Dot (Any Character)
101

 
- Using {Intervals}
102

 
- Using Character Lists []
104

 
- Using Character Lists to exclude matches
107

 
- POSIX
108

 
- Using the Question Mark (Optional)
110

 
- Using the Plus sign (Mandatory)
112

 
- Using the Star sign (Optional)
113

 
- Exercise Five
114

Seven
Joining Tables in an SQL Statement
116

 
- Introduction
117

 
- Linking Tables in an SQL Statement
118

 
- Theta style of SQL
123

 
- ANSI style of SQL
124

 
- Problems with Data matching
125

 
- Problems with Joining Tables in SQL
126

 
- Ansi SQL Standards (Natural Joins)
127

 
- Ansi SQL Standards (Cross Joins)
128

 
- Ansi SQL Standards (Joins/Using)
129

 
- Ansi SQL Standards (On)
130

 
- Ansi SQL Standards (Multiple On)
131

 
- Ansi SQL Standards (Left Outer Joins)
132

 
- Ansi SQL Standards (Right Outer Joins)
133

 
- Merging Tables in MySQL
134

 
- Using Union to Merge Tables in MySQL
135

 
- Using Union All to Merge Tables in MySQL
136

 
- Using Intersect to Merge Tables in MySQL
137

 
- Using Minus to Merge Tables in MySQL
138

 
- Knowledge Check
139

 
- Knowledge Check - Union
140

 
- Union Syntax in MySQL
141

 
- Knowledge Check - Union All
142

 
- Union All Syntax in MySQL
143

 
- Knowledge Check - Intersect
144

 
- Intersect Syntax in MySQL
145

 
- Knowledge Check - Minus
146

 
- Minus Syntax in MySQL
147

 
- Using the Merge Syntax in MySQL
148

 
- Exercise Six
149

Eight
Advanced MySQL Query Techniques
154

 
- Using Limit in MySQL
155

 
- Using If() in MySQL
157

 
- Using Ifnull() in MySQL
158

 
- Using Nullif in MySQL
159

 
- Using Case Function in SQL
160

 
- Using Sub-queries
164

 
- Using Set to create variables
167

 
- Populating a Variable from a Query
168

 
- Exercise Seven
170

Nine
MySQL Datatypes
173

 
- Introduction
174

 
- Numeric Datatypes (Integer)
175

 
- Numeric Datatypes (Decimal)
176

 
- String Text Datatypes
177

 
- String Blob Datatypes
178

 
- String List Datatypes
179

 
- Date Datatypes
180

Ten
Creating Database Objects in MySQL
181

 
- Creating Tables in MySQL
182

 
- Mandatory Columns in MySQL Tables
183

 
- Creation Syntax for Tables in MySQL
184

 
- Column Creation in MySQL
187

 
- Drop Table Syntax
189

 
- Temporary Tables in MySQL
190

 
- Creating Indexes in MySQL
192

 
- Primary Key Creation in MySQL
195

 
- Unique Key Creation in MySQL
198

 
- Foreign Key Creation in MySQL
201

 
- Creating Views in MySQL
203

 
- Renaming Views in MySQL
206

 
- Dropping Views in MySQL
207

 
- Exercise Eight
208

Eleven
Altering in MySQL
210

 
- Altering Tables
211

Twelve
Inserting and Altering Data in MySQL
214

 
- Rules when Populating Tables in MySQL
215

 
- Syntax for Populating Tables
216

 
- Inserting using the Set syntax
222

 
- Multiple Inserts
223

 
- On Duplicate Key Update
224

 
- Using Replace for Inserting Records
225

 
- General Comments
228

 
- Updating Data in MySQL Tables
229

 
- Deleting Data from MySQL Tables
232

 
- Inserting Large Objects in MySQL
233

Thirteen
Prepared Statements
235

 
- Introduction
236

 
- Preparing the Statement
237

 
- Removing Prepared Statements
238

 
- Using Parameters
239

 
- Using mysqli_prepare()
241

 
- Using mysqli_stmt_bind_param()
242

Fourteen
Committing Records
243

 
- DDL and DML
244

 
- mysqli_commit() and mysqli_rollback()
246

 
- What happens if disconnected ?
248

 
- Exercise Nine
249

Fifteen
Importing and Exporting in MySQL
254

 
- Outfile
255

 
- Problems with Outfile
259

 
- Using Dumpfile
261

 
- Selecting into Variables
262

 
- Importing Data using Infile
263

 
- Ignoring Lines using Infile
265

 
- Using the Set command with Infile
266

 
- Using the Lines option with Infile
269

 
- Loading comma separated files
270

 
- Loading XML file into MySQL
272

 
- Loading XML file into MySQL using Ignore
274

 
- Loading XML file into MySQL naming Columns
275

 
- Loading XML file into MySQL using Set
276

 
- Exercise Ten
314


Index of Using MySQL 5.5 with PHP Training Course

Section
Section Name
One
Introduction to MySQL
Two
Simple MySQL Queries in PHP
Three
MySQL Errors
Four
Limiting Data Selected with a Where Clause
Five
Aggregating Values in MySQL
Six
Regular Expressions in MySQL
Seven
Joining Tables in an SQL Statement
Eight
Advanced MySQL Query Techniques
Nine
MySQL Datatypes
Ten
Creating Database Objects in MySQL
Eleven
Altering in MySQL
Twelve
Inserting and Altering Data in MySQL
Thirteen
Prepared Statements
Fourteen
Committing Records
Fifteen
Importing and Exporting in MySQL

Synopsis for Using MySQL 5.5 with PHP Training Course

This is the course to take if you need to further your PHP knowledge by learning how to access a MySQL database within it.

The course expects the delegate to be already conversant with PHP techniques and teaches the Delegate how to use this knowledge to communicate with the MySQL database.

Request for detailsClick for the contact form for the MySQL 5.5 training course
Public Courses
Oracle Essential SQL 21c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 21c
Days
3
Pages
384
Exercises
13
Sections
25
Public
Yes
On-Site
Yes
Public Courses
Using SQL with Oracle SQL Developer 19.2
Days
4
Pages
884
Exercises
18
Sections
37
Public
Yes
On-Site
Yes
Public Courses
Essential JavaScript
Days
4
Pages
660
Exercises
16
Sections
31
Public
Yes
On-Site
Yes
Public Courses
Essential CSS 3
Days
4
Pages
800
Exercises
15
Sections
30
Public
Yes
On-Site
Yes
Public Courses
Essential SQLite 3
Days
3
Pages
550
Exercises
12
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential MySQL 8
Days
4
Pages
533
Exercises
16
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential Python 3
Days
5
Pages
955
Exercises
17
Sections
41
Public
Yes
On-Site
Yes
Public Courses
Oracle Application Express 20
Days
0
Pages
0
Exercises
0
Sections
0
Public
Yes
On-Site
Yes
Public Courses
PHP 8 and MySQL 8
Days
5
Pages
870
Exercises
23
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 17 Programming with Eclipse 2021-12
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 17 Swing with Eclipse 2021-12
Days
5
Pages
756
Exercises
19
Sections
35
Public
Yes
On-Site
Yes
Click on the course name to see full details, left and right to view other courses