Welcome to the
CSET 3300
web site. Here, you will find links to everything you
need to support your studies as you proceed through this
course CSET 3300.
Topics covered in this course
include (but are not limited to) the following:
- An overview of databases
- Relational database design
- Entity Relationship data
model
- Database query languages SQL
- MySQL database server
- The PHP server-side
scripting language
- Matters of creating and
querying databases
- Performing simple and
advanced operations with PHP scripting
- Find out what MySQL offers
and what it doesn't
- Get up to speed on normal
forms and other MySQL basics
- Build MySQL tables with
Structured Query Language
- Extract database information
with MySQL selects and functions
- Work with PHP variables,
control structures, and function
- Create simple applications:
a guestbook and a survey
- Develop more sophisticated
applications: a catalog, a content manager, a threaded discussion, a
problem tracking system, and a shopping cart.
- Discover helpful appendixes
on HTML forms, MySQL utilities, PHP functions, and more
- Advanced topics: Data mining
After successful completion
of this course, students will be able to:
•
Develop an understanding of relational database concepts and design principles.
•
Develop an understanding of basic and advanced SQL statements.
• Apply
the PHP server-side scripting language and MySQL database management system to
the creation of dynamic web site applications.
•
Understand and implement realistic MySQL/PHP web applications.
To be successful in this course, you
should have some background in the creation and use of HTML forms. HTML forms
will be used to access the PHP pages.