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
