Section: Week 9: Database Management (mySQL)[18th November 2020-] | Web Engineering (Spring 21)

Section outline

Topics

Handling Database with mySQL and PHP

Learning Outcome

Be able to access and create mySQL database

CRUD operations

Use mySQL with PHP

Lab Session 8: Working with mySQL and PHP

https://www.w3schools.com/php/php_mysql_intro.asp
- Select activity PDF: MySQL and PHP
  
  PDF: MySQL and PHP File
  
  Students must
  
  Mark as done
- Select activity Class Video LectureLecture-17(Basic MySQL )
  
  Students must
  
  Mark as done
  
  Class Video Lecture
  Lecture-17(Basic MySQL )
- Select activity Forum discussion on MySQL
  
  Forum discussion on MySQL
  
  Students must
  
  Mark as done
- Select activity Interactive quiz on MySQL
  
  Interactive quiz on MySQL Interactive Content
  
  Students must
  
  Mark as done
- Select activity Students Feedback
  
  Students Feedback URL
  
  Students must
  
  Mark as done
- Select activity Reference video:click
  
  Students must
  
  Mark as done
  
  Reference video:

Introduction

Announcements

Student Interest Discovery

Announcements

Telegram Group Link

Google Meet Link

Google Classroom Link

Online Editior

Appointment in Google Calendar

Week 1: SWE Background and the Web(13th September 2020- 21st september 2020)

Necessity of SWE and Computer Networking

Are web developers software engineers?

PDF: Introduction about Web

Assignment on Introduction about Web

Forum discussion on Introduction about web apps.

Interactive contents on Introduction about web.

Reference website

Students feedback(Week-1)

Week 2 : Review and Front-End technology(22th September 2020- 27th September 2020)

PDF: Basic HTML

PDF: Requirement Engineering

Additional resource on HTML practice

Assignment on HTML

Forum discussion on HTML

Interactive quiz on HTML

Reference website

Studnets feedback(Week-2)

Week 3: Discussion on HTML and CSS (28th september 2020-03rd October2020)

PDF: Basic HTML part 2

PDF: Basic CSS

Class content

Additional resource

Assignment on HTML and CSS

Forum discussion on HTML and CSS

Interactive quiz on HTML and CSS

Students feedback(Week-3)

Week 4: Adaptive Lesson and Layout(5th October 2020-13th october 2020)

Additional resource

Assignment on layout designing

Forum discussion on CSS

Week 5: Interactive Web with JavaScript and Forms(14th October 2020-)

Assignment on JavaScript DOM, Events

Forum discussion on JavaScript DOM and Events

Week 6: Discussion Review(25th October 2020-9th November 2020)

Week 7 : Midterm Exam(10th November ,2020)

Mid-Exam

Week 8: Server Side Programming and PHP (15th November2020-17th November 2020)

PDF: Basic PHP

PDF: Basic PDF 2

Forum discussion on PHP

Interactive quiz on PHP

Students Feedback(Week-8)

Week 9: Database Management (mySQL)[18th November 2020-]

PDF: MySQL and PHP

Forum discussion on MySQL

Interactive quiz on MySQL

Students Feedback

Week 10: Project Management and MVC(24 November2020- )

PDF: Project Management

PDF: MVC design Pattern

Assignment on Project Management

Interactive quiz on MVC and Project management

Additional resources

Students Feedback(Week-10)

Week 11: Review Discussion and Adaptive Lesson on PHP(December 2020)

Assignment on PHP and MySQL

Presentation Submission link

Week 12: Discussion on Other Technologies and Presentation(16th August 2020-26th August2020)

PDF: Ajax,Json

Forum discussion on JSON

Interactive quiz on JSON,XML

Week 13(24 December,2020)

Final Assessment

Section outline