Introduction to Databases, Advanced PHP

Loading video...

Next Lecture

Previous Lecture

Discussion
Quick Notes
Download Lecture Slides
Table of Contents
Related Services

Please login to ask a question and view discussion.

Start Learning Now

Our free lessons will get you started (Flash® 10 required).
Get immediate access to our entire library.

Features Overview

Get on-demand access to our complete library
Search and jump to exactly what you need to learn
Track your progress
Download practice and lesson files
*Ask questions and get answers from our community & instructors

Introduction to Databases

A relational database is a type of database that stores data, and relations between the data, in organized structures called tables.
A relational database management system, or RDBMS, is a system that provides an interface for managing and using a relational database.
Tables organize data into rows and columns. The columns describe the type of data that each row should supply, and the rows, also known as records, are sets of values corresponding to the table's columns.
Each column defined for a table has at least two properties:
- Name – an identifier for the column
- Data type – the type of data stored in the column
SQL, or Structured Query Language, is a language used with RDBMS to:
- Define the structure of a database & its tables
- Insert, update, & delete data from a database
- Query, or request, specific pieces of data from a database
SQL also defines several standard data types for data that can be stored in a database table:
- Integers
- Floating-Point Numbers
- Strings
- Dates & Times
A primary key is a piece of data that can be used to uniquely identify table rows.
A table’s primary key refers to the column for which the value of that column in each row is guaranteed to be unique.

Introduction to Databases

Lecture Slides are screen-captured images of important points in the lecture. Students can download and print out these lecture slide images to do practice problems as well as take notes while watching the lecture.

I. Advanced PHP with MySQL
	Course Introduction	13:36
	Advanced Course Development Environment	18:46
	Introduction to File I/O	35:37
	Web Application Development	36:36
	HTTP & the POST Method	34:36
	Web Application Development	14:11
	Writing to Files	17:38
	Web Application Development	28:14
	HTTP POST: File Uploads	22:51
	Web Application Development	15:30
	Introduction to Object-Oriented Programming	32:44
	Web Application Development	17:47
	Object Methods	39:57
	Web Application Development	17:30
	Object Constructors	22:20
	Web Application Development	16:19
	More Magic Methods	53:37
	Web Application Development	31:12
	Classes vs. Objects	37:49
	Web Application Development	21:07
	Exceptions	22:43
	Web Application Development	22:00
	Cookies	39:47
	Web Application Development	39:11
	Introduction to Sessions	46:08
	Web Application Development	11:00
	Destroying Sessions	29:59
	Web Application Development	19:14
	Introduction to Databases	21:24
	Introduction to MySQL	28:11
	Creating Databases & Tables	23:01
	SQL Command: INSERT	27:11
	SQL Command: SELECT	24:57
	Using PHP from MySQL	32:43
	Web Application Development	30:30
	SELECT QUERIES from PHP	24:22
	Web Application Development	17:06
	Linking Tables	24:32
	Web Application Development	24:00
	SQL Command: DELETE	10:33
	Web Application Development	16:02
	SQL Command: UPDATE	32:14
	Web Application Development	12:33
	SQL: Joins	42:16
	Web Application Development	29:34
	User Authentication	26:13
	Web Application Development	14:36

Advanced PHP Training with MySQL


Course Introduction			13:36
	Intro		0:00
	Advanced PHP w/ MySQL		0:13
		Course Introduction	0:14
		Course Content	0:59
	Web Application: Educator Store		1:45
		Web Application: Educator Store	1:46
	Object-Oriented Programming		6:09
		Object-Oriented Programming Overview	6:10
	MySQL		6:50
		MySQL Overview	6:51
		Example: Command Prompt & MySQL	8:34
	What You Will Learn		9:34
		What You Will Learn	9:35
	Course Prerequisites		11:52
		Course Prerequisites	11:53
Advanced Course Development Environment			18:46
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	Development Environment Setup		1:36
		Firefox Web Browser, XAMPP, and PSPad Text Editor	1:37
	Course Directory Structure		4:36
		Course Directory Structure	4:37
	phpDocumentor		7:23
		phpDocumentor Overview	7:24
		Parsing Source Code	7:44
		docs Subdirectory	9:06
		Asvanced PHP Course Documentation Example	10:21
	Previous Educator PHP Students		14:14
		Lib Directory Changes	14:38
		Images Directory Changes	14:57
		VERSION Constant	15:40
		Comments Noting a Specific Version Number	17:04
	Homework Challenge		17:30
		Homework Challenge	17:31
Introduction to File I/O			35:37
	Intro		0:00
	Lesson Overview		0:10
		Lesson Overview	0:11
	File I/O		1:34
		File I/O Overview	1:35
		Performing file I/O: 3 Steps	1:52
	File Permissions		2:28
		Read Permission & Write Permission	2:29
	fopen()		4:47
		fopen()	4:48
		Two Required Parameters	5:01
		Successful fopen(): File Handle and Resource	5:21
		FALSE and E_WARNING Error	6:00
		Example	6:39
	File Paths		7:10
		File Paths	7:11
	File Access Modes		9:18
		File Access Modes	9:19
	Coding Example: fopen()		10:31
		Using Relative and Absolute Path & Non-Existent File	10:32
	File Pointers		15:55
		File Pointers	15:56
		Example File	16:11
		Opening a File with fopen() Using 'r' as the Access Mode	16:22
	fgets()		17:55
		fgets() Overview	17:56
		Coding Example: fgets() - Reading a Line at a Time	18:26
	feof()		20:10
		feof() Overview	20:09
		Coding Example: feof()	20:50
	fclose()		23:43
		fclose() Overview	23:44
		Coding Example: fclose()	25:02
	Coding Example: Current Stock		26:10
		Coding Example: Current Stock	26:11
	trim ()		31:39
		trim () Overview and Example	31:40
	Homework Challenge		33:35
		Homework Challenge	33:36
Web Application Development			36:36
	Intro		0:00
	Lesson Overview		0:16
		Lesson Overview	0:17
	Version 1.0 Changelog		0:31
		catalog.php	0:32
		Function Library: fileLIB.php	5:00
	Version 1.1 Changelog		27:12
		createItemDataArray() and createDeptDataArray()	27:13
		outputSimpleItemLink() and outputSimpleDeptLink()	32:06
HTTP & the POST Method			34:36
	Intro		0:00
	Lesson Overview		0:10
		Lesson Overview	0:11
	HTTP Model		1:28
		HTTP Model	1:29
		Client-Server Model 2 Steps Process	2:00
	HTTP Messages		2:23
		HTTP Messages	2:24
	HTTP Requests		3:09
		HTTP Requests	3:10
		Example: HTTP Request Header	3:17
		Coding Example: HTTP Requests	4:29
	HTTP Responses		7:15
		HTTP Responses	7:16
		Example: HTTP Response (Header & Body)	8:00
	header()		11:47
		header() Overview	11:48
		Coding Example: header	14:02
		Coding Example: header() Error	14:52
	GET Method		18:55
		GET Method	18:56
		Coding Example: GET Method	20:13
	POST Method		21:09
		POST Method	21:10
		Coding Example: Sample Form Using the POST Method	23:50
	Accessing POST Data in PHP		26:38
		Accessing POST Data in PHP	26:39
		Coding Example: Accessing POST Data via $_POST	28:15
	GET vs. POST		29:54
		GET vs. POST	29:55
	Example: Accessing POST Data via $_POST		31:20
		Example: Accessing POST Data via $_POST	31:21
	Homework Challenge		33:00
		Homework Challenge	33:01
Web Application Development			14:11
	Intro		0:00
	Version 2.0 Changelog		0:09
		Updating the Site's Current Form to Use the POST Method	0:10
		Creating Admin Website	2:55
		Dynamically Generated Department List	12:40
Writing to Files			17:38
	Intro		0:00
	Lesson Overview		0:09
		Lesson Overview	0:10
	Review of File I/O		0:40
		Review of File I/O	0:41
	fwrite()		1:38
		fwrite()	1:39
		fputs()	2:20
		'r+'	2:31
		Coding Example: fwrite()	2:59
	fopen() Access Modes		8:41
		'a' and 'a+'	8:42
		'w' and 'w+'	11:34
	Homework Challenge		14:47
		Homework Challenge	14:48
Web Application Development			28:14
	Intro		0:00
	Lesson Overview		0:08
		Lesson Overview	0:09
	Updated Open File Functions		0:19
		openItemsDataFile ( ), openDeptsDataFile ( ), and openLastAddedFile ( )	0:20
	insertItem()		6:25
		insertItem() Overview	6:26
		Functions: createItemDataString ( ) and updateLastItemAdded ( )	7:07
	addItemToDepartment ()		16:03
		addItemToDepartment () Overview	16:04
		Functions: createDeptDataString ( ) and updateDepartment ( )	17:55
HTTP POST: File Uploads			22:51
	Intro		0:00
	Lesson Overview		0:10
		Lesson Overview	0:11
	POST Data Encoding		1:13
		POST Data Encoding	1:14
		When Data is Included in the Body of the HTTP POST Request and is of the Content Type	1:31
		When Uploading Files Using HTTP POST	3:17
	Uploading Files		6:22
		Uploading Files	6:23
		If Encoding Type is Not Set to Multipart/Formdata	9:27
	$_FILES Superglobal		10:59
		$_FILES Superglobal	11:00
	Structure of $_FILES		12:15
		Structure of $_FILES: Name, Type, tmp_name, Error, and Size	12:16
		Coding Example: $_FILES Superglobal	13:34
	Moving an Uploaded File		15:39
		Introduction to Moving an Uploaded File	15:40
		move_uploaded_file ( ): Definition and Example	16:40
	Homework Challenge		21:19
		Homework Challenge	21:20
Web Application Development			15:30
	Intro		0:00
	Lesson Overview		0:09
		Lesson Overview	0:10
	Uploading Item Image File		1:22
		Uploading Item Image File	1:23
	Uploading Item Image File (cont.)		2:43
		Altering insertItem ( )	2:44
		Helpfer Functions: getFileExtension ( ) and moveUploadedFile ( )	4:30
		isValidItem ( )	13:03
Introduction to Object-Oriented Programming			32:44
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	Object-Oriented Programming		0:56
		Introduction to Object-Oriented Programming	0:57
	Associative Arrays		5:27
		Associative Arrays	5:28
	Classes		7:27
		Classes Overview	7:28
	Defining Classes		8:24
		Defining Classes	8:25
		Declaring Class Properties	9:25
		Coding Example: Classes	10:11
	Objects		12:18
		Objects Overview	12:19
	Classes vs. Objects		12:49
		Classes vs. Objects	12:50
	Instantiating Classes		14:58
		Instantiating Classes	14:59
		Coding Example: Instantiate an Item Object	16:30
	Object Properties		19:21
		Access and Set an Object's Property	19:22
		Coding Example: Set & Access the Properties of an Item Object	24:23
	Homework Challenge		30:22
		Homework Challenge	30:23
Web Application Development			17:47
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	Version 5.0 Overview		0:50
		Version 5.0 Overview and Examples	0:51
	Outputting Object Properties		12:38
		Outputting Object Properties	12:39
	Array Object Properties		14:18
		Access and Set Array Value	14:19
Object Methods			39:57
	Intro		0:00
	Lesson Overview		0:12
		Lesson Overview	0:13
	Object Methods		0:52
		Definition of Object Methods	0:53
	Calling Object Methods		3:25
		Calling Object Methods	3:26
		Coding Example: Simple Object Methods	4:44
		Object Methods and Return Values	7:02
	$this Variable		10:06
		$this Variable: Definition and Example	10:07
	$this Variable (cont.)		15:51
		$this Variable (cont.)	15:52
	Getters & Setters		21:21
		Getters & Setters Methods	21:22
	Object Methods In Strings		25:46
		Object Methods In Strings	25:47
		Coding Example: Outputting Method Return Values in Strings	27:41
	Using $this to Call Other Methods		28:49
		Using $this to Call Other Methods	28:50
	Homework Challenge		34:18
		Homework Challenge: 1-3	34:19
	Homework Challenge (cont.)		36:20
		Homework Challenge: 4-6	36:21
	Homework Challenge (cont.)		37:52
		Homework Challenge: 7-10	37:53
Web Application Development			17:30
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	Version 6.0 Overview		0:40
		Version 6.0 Changes & Examples	0:41
	Item Methods		0:53
		Item Class Definition: getImageFilename()	0:54
		Coding Example: getImageFilename()	1:58
	Department Methods		7:33
		addItem(), removeItem(), and isItemInDept() Method	7:34
		addItemtToDepartment() & buildDeptObject() Functions	11:46
		A Default Value Needed to Be Set for $items	16:26
Object Constructors			22:20
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	Object Constructors		0:32
		Introduction to Object Constructors	0:33
		Coding Example: Object Constructors	1:43
	Defining Constructors		3:26
		Defining Constructors	3:27
		Coding Example: Constructors with No Arguments	4:24
	Constructor Arguments		8:09
		Constructor Arguments	8:10
		Coding Example: Constructor Arguments	9:49
	Important Notes		16:13
		Important Notes	16:14
	Homework Challenge		17:35
		Homework Challenge: 1 - 4	17:36
	Homework Challenge (cont.)		19:13
		Homework Challenge: 5 - 9	19:14
	Homework Challenge (cont.)		21:40
		Homework Challenge: 10 and 11	21:41
Web Application Development			16:19
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	Version 7.0 Overview		0:39
		Version 7.0 Overview	0:40
	Item Constructor		2:19
		Item Constructor	2:20
	Department Constructor		7:47
		Department Constructor	7:48
	Customer Constructor		12:23
		Customer Constructor	12:24
More Magic Methods			53:37
	Intro		0:00
	Lesson Overview		0:13
		Lesson Overview	0:14
	Magic Methods		1:12
		Magic Methods	1:13
	Destructors		2:45
		Destructors Overview	2:46
		Coding Example: Calling Destructors	4:30
		Coding Example: Object Destructor	9:19
	_to String ()		16:12
		_to String () Overview	16:13
		Coding Example: _to String () Magic Method	18:10
	Access Modifiers		21:23
		Introduction to Access Modifiers	21:24
		Access Modifiers: Public	21:39
		Access Modifiers: Private	22:18
		Access Modifiers: Protected	22:41
		Object Properties and Methods	23:06
		Coding Example: Public Access Modifiers	26:48
		Coding Example: Private Access Modifiers	28:30
	_get()		31:37
		_get() Overview	31:38
		Coding Example: _get () Magic Method	33:30
	_set ()		36:23
		_set () & the Magic Method	36:24
	Using Getters & Setters		44:37
		Coding Example: Using Getters & Setters	44:38
	Homework Challenge		50:33
		Homework Challenge: 1 - 6	50:34
	Homework Challenge (cont.)		51:41
		Homework Challenge: 7 - 12	51:42
Web Application Development			31:12
	Intro		0:00
	Version 8.0 Review		0:12
		Version 8.0 Review	0:13
	private Object Properties		1:15
		private Object Properties	1:16
		Coding Example	2:54
	_toString() Methods		6:51
		_toString() Methods	6:52
		Coding Example	8:09
	DataFile Class		13:27
		DataFile Class & I/O Operations	13:28
		Using DataFile Class: Instantiate a DataFile, DataFile open () Method, and DataFile close () Method	18:09
	Homework Challenge		29:35
		Homework Challenge	29:36
Classes vs. Objects			37:49
	Intro		0:00
	Lesson Overview		0:09
		Lesson Overview	0:10
	Class vs. Object Review		0:58
		Class vs. Object Review	0:59
	Static Properties		2:42
		Static Properties	2:43
	Scope Resolution Operator (::)		5:26
		Scope Resolution Operator (::) & Static Property	5:27
		Coding Example: Accessing a Static Property Using the Scope Resolution Operator	7:57
		Coding Example: Accessing a Static Property in a Class Definition	10:33
		Coding Example: Using a Static Property as an Instance Counter	14:18
	Static Methods		18:51
		Static Methods Overview	18:52
		Coding Example: Static Methods	21:39
	Classes vs. Objects		26:28
		Classes vs. Objects: Diagrams	26:29
	Class Constants		30:24
		Class Constants Definition	30:25
		Coding Example: Using Class Constants	31:55
	Homework Challenge		34:01
		Homework Challenge: 1 - 5	34:02
	Homework Challenge (cont.)		35:25
		Homework Challenge: 6 - 10	35:26
Web Application Development			21:07
	Intro		0:00
	Version 9.0 Overview		0:12
		Version 9.0 Changes & Examples	0:13
	Output Class		1:08
		Output Class & Static Methods	1:09
		outputHtmlSelector ( ) Method	2:43
		outputItemSelector ( ) Method	4:53
		outputDeptSelector ( ) Method	6:42
	buildObject() Methods		11:54
		buildObject() Methods & Examples	11:55
Exceptions			22:43
	Intro		0:00
	Lesson Overview		0:12
		Lesson Overview	0:13
	try Blocks		0:44
		try Blocks Definition	0:45
	catch Blocks		2:03
		catch Blocks: Definition and Syntax	2:04
		Coding Example: try/catch Blocks	3:48
		When an Exception Object is Caught & Error Handling	5:59
	Exception Class		7:02
		Exception Class	7:03
		Coding Example: Using try/catch to Catch an Exception Thrown from a Method	8:04
	Re-Throwing Exceptions		16:39
		Re-Throwing Exceptions	16:40
		Coding Example: Re-throwing an Exception	17:21
	Homework Challenge		20:40
		Homework Challenge: 1 - 5	20:41
	Homework Challenge (cont.)		22:17
		Homework Challenge: 6	22:18
Web Application Development			22:00
	Intro		0:00
	Version 10.0 Overview		0:11
		Updating addItem.php, addItemToDept.php, and error.php	0:12
		Updating DataFile Class: open ( ) Method & try/catch blocks	7:45
	Version 10.1 Overview		13:37
		Version 10.1 Changes & Examples	13:38
		Updating DataFile Class: close ( ) Method & logWarning ( )	20:17
Cookies			39:47
	Intro		0:00
	Lesson Overview		0:09
		Lesson Overview	0:10
	What is a Cookie?		1:15
		Definition of Cookie	1:16
	HTTP - A Stateless Protocol		2:17
		HTTP - A Stateless Protocol	2:18
		Purpose of Cookies	4:10
	Set - Cookie Header		6:21
		Introduction to Set - Cookie Header	6:22
		Coding Example: Set - Cookie Header	7:38
	Cookie Header		9:45
		Introduction to Cookie Header	9:46
		Example: Cookie Header	10:27
	setcookie()		12:33
		Introduction to setcookie()	12:34
		Example: Using setcookie	13:54
	Cookies Attributes		15:48
		Cookies Attributes Overview	15:49
		Common Cookies Attributes: Domain	16:24
		Common Cookies Attributes: Path	17:04
		Common Cookies Attributes: Expires	19:34
		Coding Example: Setting Cookie Attributes	20:58
	$_COOKIE Superglobal		27:03
		$_COOKIE Superglobal	27:04
		Coding Example: Accessing Cookies from PHP Using $_COOKIE	29:45
	Security Implications		34:44
		Security Implications	34:45
	Homework Challenge		36:10
		Homework Challenge: 1 - 4	36:11
	Homework Challenge (cont.)		37:47
		Homework Challenge: 5 - 7	37:48
Web Application Development			39:11
	Intro		0:00
	Lesson Overview		0:17
		Lesson Overview	0:18
	instanceof Operator		1:34
		instanceof Operator	1:35
	Objects with Object Properties		2:53
		Objects with Object Properties	2:54
	Version 11.0 Overview		6:41
		Version 11.0 Changes: Cart and CartItem Classes	6:42
		Version 11.0 Coding Example	10:40
	Version 11.1 Overview		31:03
		Version 11.1 Changes & Examples	31:04
Introduction to Sessions			46:08
	Intro		0:00
	Lesson Overview		0:08
		Lesson Overview	0:09
	What is a Session?		0:53
		What is a Session?	0:54
	Client-Side Sessions		3:51
		Client-Side Sessions	3:52
	Server-Side Sessions		5:04
		Server-Side Sessions	5:05
	Session IDs		6:26
		Session IDs	6:27
		The SID is Used by the Server to:	7:08
		A Client Passes an SID to the Server with Each HTTP Request Via:	8:15
	Sessions in PHP		12:19
		Sessions in PHP	12:20
	session_start()		14:40
		session_start() Overview	14:41
		Coding Example: Using session_start () to Continue a Session	18:03
	$_SESSION Superglobal		22:06
		$_SESSION Superglobal Overview	22:07
		Coding Example: Setting a Session Variable via $_SESSION	25:22
	Accessing Session Data		28:08
		Accessing Session Data	28:09
	Deleting Session Data		31:43
		Deleting Session Data	31:44
		Coding Example: Deleting Session Data	32:16
	Configuring PHP Sessions		36:14
		session.cookie_lifetime, session.cookie_domain, and session.cookie_path	36:15
		Coding Example: Configuring PHP Sessions	37:28
	Configuring PHP Sessions (cont.)		40:56
		session.use_cookies, session.use_trans_sid, and session.use_only_cookies	40:57
		Coding Example: Configuring PHP Sessions	42:25
	Homework Challenge		42:55
		Homework Challenge: 1 - 5	42:56
	Homework Challenge (cont.)		44:10
		Homework Challenge: 6 - 10	44:11
	Homework Challenge (cont.)		45:27
		Homework Challenge: 11 - 13	45:28
Web Application Development			11:00
	Intro		0:00
	Version 12.0 Overview		0:12
		Version 12.0 Changes Part I: Updating 'viewCart.php' & 'checkout.php'	0:13
		Version 12.0 Changes Part II	5:03
Destroying Sessions			29:59
	Intro		0:00
	Lesson Overview		0:12
		Lesson Overview	0:13
	Destroying Sessions		1:02
		Destroying Sessions	1:03
	session_destroy()		2:10
		session_destroy() Overview	2:11
		Coding Example: Setting a Session Variable and Destroying a Session	3:18
	Deleting Session Cookies		8:38
		Deleting Session Cookies	8:39
		Coding example: Deleting Session Cookies	9:17
	Review of Steps		21:07
		Review of Steps	21:08
	Garbage Collection		21:50
		Garbage Collection Overview	21:51
		Coding Example: Garbage Collection	24:30
	Homework Challenge		26:28
		Homework Challenge: 1 - 4	26:29
	Homework Challenge (cont.)		28:16
		Homework Challenge: 5 - 9	28:17
Web Application Development			19:14
	Intro		0:00
	Lesson Overview		0:13
		Lesson Overview	0:14
	_autoload()		0:46
		Introduction to _autoload ()	0:47
	Version 13.0 Overview		4:06
		_autoload () and SessionManager Class	4:07
		Updating 'viewCart.php' & 'checkout.php'	11:16
Introduction to Databases			21:24
	Intro		0:00
	Lesson Overview		0:16
		Lesson Overview	0:17
	Flat Files		1:09
		Flat Files: Definition and Example	1:10
		Problems Associated with Using Flat Files as a Database	2:15
	Relational Databases		3:29
		Relational Databases	3:30
		Relational Database Management System (RDBMS)	3:50
	Tables		7:43
		Tables	7:44
	Columns		9:24
		Columns	9:25
	What is SQL?		10:45
		Introduction to Structured Query Language	10:46
		Standard Data Types of SQL	12:23
	Primary Keys		13:19
		Primary Keys	13:20
	Primary Key Examples		16:36
		Primary Key Examples	16:37
Introduction to MySQL			28:11
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	What is MySQL?		1:33
		MySQL	1:34
	MySQL Monitor		5:16
		MySQL Monitor Overview	5:17
		XAMPP & MySQL	5:58
		In the MySQL Command: hostname, username and -p	7:05
	Connecting to a MySQl Server		9:52
		Connecting to a MySQl Server	9:53
	Using MySQl Monitor		13:48
		Using MySQl Monitor	13:49
	GRANT Command		15:10
		GRANT SQL Command	15:11
		Privileges & Objects	18:18
		Username, Hostname, and Password	19:37
		Specifying Objects	20:05
	Creating a PHP User Account		21:41
		Creating a PHP User Account Overview	21:42
		Meaning of all & .	23:35
		Example: Creating a PHP User Account	23:48
	Required Homework		26:27
		Required Homework: 1 - 5	26:28
	Required Homework (cont.)		27:28
		Required Homework: 6	27:29
Creating Databases & Tables			23:01
	Intro		0:00
	Lesson Overview		0:08
		Lesson Overview	0:09
	Creating a Database		1:40
		Introduction to Creating a Database	1:41
		Example: Creating a Database	3:33
	CREATE TABLE Command		6:43
		CREATE TABLE Command	6:44
	Data Types		7:39
		Numeric Data Types: INT, INT UNSIGNED, and DECIMAL	7:40
		String Data Types: CHAR (M), VARCHAR (M), and TEXT	9:23
	Colum Attributes		11:00
		PRIMARY KEY Attribute	11:01
		AUTO INCREMENT Attribute	11:35
	Items Table		13:07
		Items Table	13:08
	Useful Commands		17:04
		SHOW TABLES Command & DESCRIBE Utility Statement	17:05
		Example: Creating an Items Table	17:58
	Required Homework		20:51
		Required Homework: 1 - 6	20:52
	Required Homework (cont.)		21:55
		Required Homework: 7 - 9	21:56
SQL Command: INSERT			27:11
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	INSERT Command		1:20
		SQL INSERT Command	1:21
	Specifying Values		3:16
		Columns with Numeric Data Types	3:17
		Columns with String Data Types	3:34
		Columns with AUTO INCREMENT	4:07
	Inserting Items		5:21
		Inserting Items	5:22
		Example: Inserting Items	7:03
	SQL Text Files		14:04
		SQL Monitor Client	14:05
		MySQL Monitor & the < Operator	15:15
		Example	17:35
	Required Homework		22:32
		Required Homework: 1 - 6	22:33
	Required Homework (cont.)		24:19
		Required Homework: 7 - 10	24:20
SQL Command: SELECT			24:57
	Intro		0:00
	Lesson Overview		0:10
		Lesson Overview	0:11
	SELECT Command		0:42
		SELECT Command: Definition and Syntax	0:43
		Results of a SELECT Query	1:53
		To Specify the Retrieval of All Columns from a Table	3:06
		Example: SELECT Command	4:18
	WHERE Clause		7:11
		WHERE Clause	7:12
		A SELECT Query with WHERE Clause has the Following Syntax	8:10
		A Where Condition can Contain both Logical and Comparison Operators	9:44
	Literal Values		13:24
		Literal Values	13:25
		Example: Literal Values	14:18
	ORDER BY Clause		15:31
		ORDER BY Clause & SELECT Query	15:32
		Ascending and Descending Order	17:30
		An ORDER BY Clause can Specify Multiple Columns to Order the Rows by	18:01
		Example: SELECT Query with WHERE and ORDER BY Clause	20:32
	Homework Challenge		21:59
		Homework Challenge	22:00
	Homework Challenge (cont.)		23:54
		Homework Challenge	23:55
Using PHP from MySQL			32:43
	Intro		0:00
	Lesson Overview		0:10
		Lesson Overview	0:11
	PHP/MySQL Architecture		0:56
		PHP/MySQL Architecture	0:57
	MySQLi Extension		3:05
		MySQLi Extension	3:06
	Steps to Using MySQL from PHP		5:53
		Four Steps to Using MySQL from PHP	5:54
		Step # 3	7:18
	Connecting to a Database		8:12
		To Connect to a MySQL Database	8:13
		To Test for Connection Errors	10:20
	Running an SQL Statement		11:54
		Running an SQL Statement	11:55
		Example	13:30
	Processing the Results		15:58
		For non-SELECT Queries	15:59
		MySQLi Object Property: affected_rows	16:19
		For INSERT Statements on Tables with an AUTO_INCREMENT Column	18:07
	Closing the Connection		19:45
		Closing the Connection	19:46
	Coding Example		21:24
		Coding Example: Using MySQL from PHP	21:25
	Homework Challenge		29:00
		Homework Challenge: 1 - 4	29:01
	Homework Challenge (cont.)		31:10
		Homework Challenge: 5 - 9	31:11
Web Application Development			30:30
	Intro		0:00
	Lesson Overview		0:14
		Lesson Overview	0:15
	sprintf()		1:28
		sprintf() Overview	1:29
		Example	1:56
	INSERT Statements with sprintf()		5:15
		INSERT Statements with sprintf()	5:16
	Version 14.0 Overview		10:00
		Version 14.0 Changes & Examples Part 1	10:01
		Version 14.0 Changes & Examples Part 2	21:58
SELECT QUERIES from PHP			24:22
	Intro		0:00
	Lesson Overview		0:14
		Lesson Overview	0:15
	SELECT Queries		1:21
		SELECT Queries	1:22
	MySQLi_Result Class		3:17
		MySQLi_Result Class: num_rows	3:18
		MySQLi_Result Class: fetch_assoc ( ) and fetch_object ( )	3:59
	fetch_assoc()		5:17
		fetch_assoc() Overview	5:18
		Coding Example: Using fetch_assoc()	9:00
	stdClass Objects		12:46
		stdClass Objects	12:47
	fetch_object()		14:19
		fetch_object() Overview	14:20
		Coding Example: Using fetch_object()	16:45
	Freeing Result Set Memory		18:42
		Freeing Result Set Memory	18:43
		Coding Example: Using free ( )	20:01
	Homework Challenge		22:07
		Homework Challenge: 1 - 5	22:08
Web Application Development			17:06
	Intro		0:00
	Version 15.0 Overview		0:13
		Version 15.0 Changes & Examples Part 1	0:14
		Version 15.0 Changes & Examples Part 2	8:43
Linking Tables			24:32
	Intro		0:00
	Lesson Overview		0:16
		Lesson Overview	0:17
	A Departments Table		1:08
		Departments Table	1:09
		How Could We Model This in a Table: Option 1	1:26
		How Could We Model This in a Table: Option 2	3:12
	Database Normalization		4:37
		Database Normalization	4:38
	Foreign Keys		8:47
		Foreign Keys	8:48
	Linking Table		11:26
		Linking Table	11:27
	Multiple Column Primary Keys		15:30
		Multiple Column Primary Keys	15:31
		Example	18:51
	Required Homework		22:34
		Required Homework: 1 - 3	22:35
	Required Homework (cont.)		24:10
		Required Homework: 4	24:11
Web Application Development			24:00
	Intro		0:00
	Version 16.0 Overview		0:11
		Version 16.0 Changes	0:12
		Version 16.0 Coding Examples	4:12
	Version 16.0 (cont.)		18:30
		Version 16.0 Changes & Examples Part 2	18:31
SQL Command: DELETE			10:33
	Intro		0:00
	Lesson Overview		0:12
		Lesson Overview	0:13
	DELETE Statement		0:30
		DELETE Statement & Its WHERE Clause	0:31
		Delete All Rows From a Table	2:57
	Using DELETE from PHP		4:04
		Using DELETE from PHP Overview	4:05
		Coding Example: Using DELETE from PHP	6:37
	Homework Challenge		8:53
		Homework Challenge: 1 - 4	8:54
Web Application Development			16:02
	Intro		0:00
	Version 17.0 Overview		0:11
		Version 17.0 Changes	0:12
		Version 17.0 Coding Example	2:51
	Transactions		12:50
		Database Transaction	12:51
		Steps in Using Transactions	14:00
SQL Command: UPDATE			32:14
	Intro		0:00
	Lesson Overview		0:10
		Lesson Overview	0:11
	UPDATE Statement		0:54
		UPDATE Statement & Its WHERE Clause	0:55
		Example: UPDATE Statement	3:32
	Using UPDATE from PHP		5:21
		Using UPDATE from PHP Overview	5:22
		Coding Example: Using UPDATE from PHP	6:53
	htmlspecialchars()		9:04
		htmlspecialchars()	9:05
		Encoding Special Characters	9:23
		Coding Example: htmlspecialchars()	13:41
	addslashes()		20:40
		addslashes()	20:41
		Coding Example: addslashes()	22:52
	Homework Challenge		27:55
		Homework Challenge: 1 - 2	27:56
	Homework Challenge (cont.)		30:14
		Homework Challenge: 3 - 5	30:15
	Homework Challenge (cont.)		30:41
		Homework Challenge: 6 - 9	30:42
Web Application Development			12:33
	Intro		0:00
	Version 18.0 Overview		0:12
		Version 18.0 Changes	0:13
		Version 18.0 Coding Example	1:24
SQL: Joins			42:16
	Intro		0:00
	Lesson Overview		0:11
		Lesson Overview	0:12
	DATETIME Data Type		1:52
		DATETIME Data Type	1:53
	Modeling Orders		5:12
		Modeling Orders	5:13
	Customers Table		10:46
		Customers Table	10:47
	Example		16:18
		Example: Order Table in MySQL	16:19
	Joins		22:26
		Joins Overview	22:27
		Inner Join	23:09
		Example: Joins	24:11
	Join Conditions		28:14
		Join Conditions	28:15
		Example	28:32
		Join Queries	30:00
		Example: Join Conditions in MySQL	30:36
	Implicit Joins		34:42
		Implicit Joins	34:43
		Example: Implicit Joins	35:57
	Aliases		37:28
		Introduction to Aliases	37:29
		Example: Aliases	38:55
	Required Homework		40:32
		Problem 1	40:33
		Problem 2	41:01
		Problem 3	41:17
Web Application Development			29:34
	Intro		0:00
	Lesson Overview		0:12
		Lesson Overview	0:13
	Inserting Orders		0:44
		Inserting Orders	0:45
	Version 19.0 Overview		3:45
		Version 19.0 Changes & Example Part 1	3:46
		Version 19.0 Changes & Example Part 2	13:18
	Version 19.1 Overview		21:10
		Version 19.1 Changes	21:11
		Version 19.1 Coding Example	22:18
User Authentication			26:13
	Intro		0:00
	Lesson Overview		0:10
		Lesson Overview	0:11
	User Authentication		1:31
		User Authentication	1:32
	Authentication with Sessions		2:34
		Authentication with Sessions	2:35
		Four Steps in Authentication via Sessions	2:50
	Using Sessions to Restrict Access		3:58
		Using Sessions to Restrict Access	3:59
		Coding Example: Restricted Access Area	4:47
	Authentication Methods		5:54
		Authentication Methods Overview	5:55
		Coding Example: Authentication Methods	7:31
	Logging Out		9:57
		Logging Out	9:58
		Coding Example: Log Out	10:47
	Users Table		13:50
		Users Table	13:51
		Example: Creating a Users Table	15:08
	Password Hashing		17:30
		Password Hashing	17:31
		PHP and MySQL Built-in Hash Functions: sha1 ( ) and md5 ( )	18:43
		Coding Example: Password Hashing	19:27
	Required Homework		24:41
		Required Homework: 1 - 4	24:42
Web Application Development			14:36
	Intro		0:00
	Version 20.0 Overview		0:13
		Version 20.0 Changes & Examples Part 1	0:14
		Version 20.0 Changes & Examples Part 2	5:05
		Version 20.0 Changes & Examples Part 3	7:29
	Version 20.0 (cont.)		8:31
		Version 20.0 Changes & Examples Part 4	8:32

Related Services

Name	Description	Link
Domain Name Registration
Go Daddy	Go Daddy is the world’s #1 domain name registrar. In addition to domain registration and hosting, Go Daddy also provides e-business related software and services.	Visit Go Daddy
Website Hosting
Name	Description	Link
Blue Host	Bluehost was recently awarded Best New Hosting Company and Best Customer Support by the some of the leading hosting review companies. $6.95/month hosting.	Visit Blue Host
Host Gator	HostGator is a world leading provider of shared, reseller and dedicated web hosting. Starting at $3.96/month hosting.	Visit Host Gator
Bigcommerce	Bigcommerce is an easy to use eCommerce software with over 30,000 online stores. If you are interested in building your own eCommerce website, Educator.com highly recommend giving Bigcommerce a try!	Visit Bigcommerce
Secure Online Backup
Name	Description	Link
Carbonite	Back up your work online with Carbonite! The choice is yours: $1500 hard drive recovery OR $59.00/year for unlimited backup? With nearly 200 billion files backed up and counting, Carbonite is the leading provider of online backup.	Visit Carbonite

Educator

the best free way to manage your classroom

Free Class Website!

Free Unlimited Hosting!

Free Educator.com Domain!

Introduction to Databases

Share this knowledge with your friends!

Start Learning Now

Features Overview

Introduction to Databases

Introduction to Databases

Advanced PHP Training with MySQL

Related Services