ASD 104A – Web Application Development with PHP and MySQL Part 1

Applied Bachelor’s Degree in Software Development

Course ID

ASD 104A

Course Credits

4

About ASD 104A – Web Application Development with PHP and MySQL Part 1

This course introduces students to the creation and maintenance of data- driven Web sites using PHP and MySQL. The students will acquire foundational understanding of databases, how they are structured, and how transactions are performed on database. SQL language concepts concerning creating, reading, updating, and deleting data will be presented. Additional topics introduced include data types, tables, keys, relationships, functions, indexes, views, stored procedures, and optimization and replication. Upon completion of the course students will be able to understand how to create, modify, and maintain SQL databases.

Topics Covered In Course

ASD 104A

  • Design Web Database 
  • Creation and Modification of Database 
  • Query in SQL  
  • Stored procedures, views, and multi-table queries with JOINs 
  • SQL Administration 

Prerequisites

Students must have experience using a keyboard and mouse in a GUI-based OS such as Microsoft Windows or Macintosh and understand how to download and install programs found on the Internet. 

Student must be familiar with principles of procedural programming, software development and debugging techniques, control structures, data types, functions, arrays, and file processing.  Prior basic HTML coding experience is highly preferred. 

Meet The Faculty

Our expert, certified faculty members come with years of industry experience and are passionate about helping students build and advance their tech careers.

Talk to an Advisor

Request an appointment with one of our IT expert Admissions Advisors for personalized guidance on building your education plan. You’ll be able to book an appointment instantly for a time that fits your schedule. 

Enrollment Deadline - Priority Registration Ends October 14th, 2022!

  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden