Des Moines Area Community College

strawberriesfarctateSoftware and s/w Development

Nov 4, 2013 (3 years and 9 months ago)

66 views



Des Moines Area

Community College



COURSE COMPETENCY INFORMATION


Effective Date:

FL
2012
-
01




Acronym/Number:
WDV341


Historical Reference:



Course Title:





Intro PHP



Credit Breakout:

3

3

0

0

0




(Total Credits:

Lecture

Lab

Practicum

Work Experience)





PREREQUISITE: WDV101
or CIS204
or Instructor Permission



COURSE DESCRIPTION:

This course will introduce PHP as a server side
scripting language. It will introduce the MySQL
database and the SQL language for use with PHP. Students will embed PHP and SQL code into
html pages and publish them to a PHP enabled server. Students will create a web application
that will allow for user

login pages, as well as add, delete and updates of database content to web
pages.


COURSE COMPETENCIES:

During this course, the student will be expected to:


1.

Discuss server side scripting within a website application.



1.1

Define server side scripting
.




1.2

Explain the role of server side scripting languages
.



1.3

Identify server side scripting languages in the industry
.



1.4

Review the strengths and weaknesses of the various server side scripting
languages
.



1.5

Discuss how server side scripting is u
sed to provide dynamic content to a website
application using databases.


2.

Demonstrate PHP as a server side scripting language for website development
.



2.1

Define PHP
.



2.2

Explain the strengths and weaknesses of PHP
.



2.3

Identify the system requiremen
ts to run PHP scripting code
.



2.3

Explain the interaction of PHP and HTML within a website application
.



2.4

Explain the syntax structure of PHP
.



2.5

Write decision logic in PHP
.



2.6

Write for and while loops in PHP
.


3.

Discuss the MySQL database
.



3.1

Define an SQL relational database
.

WDV 341



2



3.2

Discuss the role of the database
.



3.3

Explain the primary parts of a database
.


4.

Discuss SQL
.




4.1

Define SQL
.



4.2

Identify the role of SQL
.



4.3

Explain the primary commands of SQL
.


5.

Demonstrate the use of
MySQL
.



5.1

Discuss the use of the PHPAdmin tool for use with MySQL
.



5.2

Create a database using PHPAdmin
.



5.3

Create tables in a database using PHPAdmin
.



5.4

Update tables in a database using PHPAdmin
.



5.5

Delete tables in a database using PHPAdmin
.


6
.

Demonstrate the use of SQL within PHP
.



6.1

Write SQL to add rows to a table
.



6.2

Write SQL to modify rows in a table
.



6.3

Write SQL to delete rows from a table
.



6.4

Write SQL to access data from the database
.



6.5

Write SQL to modify data within a
table of a database
.


7.

Use PHP, MySQL and SQL to implement the following functionality in a website
application.


7.1

Write a user signon script that will validate the username and password
.


7.2

Write a script that will access data from the database and

format it for delivery to
the client web page.


7.3

Write a script that will allow the user to modify data on the database
.


7.4

Write a script that will allow the user to delete data from the database
.


8.


Create a multi page commercially oriented webs
ite application.



8.1

Analyze the purpose and requirements of the business.


8.2

Identify appropriate functionality for the application.


8.3

Investigate the required tools and techniques to implement the functionality.


8.4

Use the concepts and
techniques from the course to write the application.


8
.5

Implement the website application on an Internet server or a commercial web
server.

WDV 341



3

LIST Discipline Faculty members that have reviewed the competencies:


FACULTY:

1
.

Jeff Gullion


2
.


3
.


4.


5
.


6.














Competencies Developed/Modified By:



Date:

10/15/2010




By:





Extension:





Campus
:
A


B C N U W



Web Entered:


(For Historical Reference follow link on page 1.)