Program Overview
The Web Programming using PHP/MySQL Part 2 course builds on Part 1, integrating MySQL into web applications built using PHP. It covers database connection, data manipulation, querying, login systems, user registration, and object-oriented PHP and MySQL queries. Graduates are equipped for careers as full-stack developers, web developers, and more.
Program Outline
Outline:
The Web Programming using PHP/MySQL Part 2 short course builds on the foundation laid in Web Programming using PHP/MySQL Part 1. The course focuses on integrating MySQL, a relational database management system based on SQL, into web applications built using a PHP backend. This combination enables developers to store, retrieve, create, update, and delete data using web forms. The course covers various aspects of database integration with PHP, including:
- Connecting to MySQL database from a PHP website
- Creating, reading, updating, and deleting records
- Querying databases to retrieve specific data
- Implementing login systems for website access
- User registration with email verification
- User permission management based on credentials
- Introduction to object-oriented PHP and MySQL queries This course requires completion of Web Programming using PHP/MySQL Part 1 or equivalent knowledge in PHP/MySQL and completion of the Building Websites with HTML5 and CSS3 introductory course or equivalent knowledge in (X)HTML authoring.
Teaching:
- The course is delivered by an industry professional with expertise in PHP and MySQL.
- It utilizes a hands-on approach with practical exercises to reinforce theoretical concepts.
- Participants learn in small groups, fostering interactive learning and personalized attention.
- Successful completion leads to a City, University of London certificate.
Careers:
Graduates of this course are equipped with advanced skills in PHP and MySQL, making them highly sought-after for various web development positions. Potential career paths include:
- Full-stack developer
- Web developer
- Back-end developer
- Database administrator
- Ecommerce developer
Other:
- The course duration is 10 weeks, held over 10 weekly evenings.
- Course dates and fees are subject to confirmation.
- The course takes place at a City University of London campus, but the location is currently unconfirmed.
Additional Notes:
- Participants can also explore City's programming courses to further their knowledge.
- City Short Courses follow the academic year, with terms occurring in Autumn (October), Spring (January), and Summer (April).
University at Buffalo
Overview:
University at Buffalo (UB) is a public research university located in Buffalo, New York. It is consistently recognized as one of the world's most exceptional and affordable universities, making it a top choice for students and faculty globally. UB is New York State's flagship university and is known for its commitment to research, innovation, and community engagement.
Student Life and Campus Experience:
UB offers a vibrant campus life with over 400 student clubs and organizations. Students can enjoy Division I basketball games, kayaking on the on-campus lake, and a variety of other activities. The university encourages students to share their "True Blue" pride and wear blue on Fridays.
Key Reasons to Study There:
Exceptional Academics:
UB offers over 500 degree programs with world-renowned faculty.Research Opportunities:
As a top 40 public research university, UB provides students with opportunities to collaborate with leading researchers and tackle complex challenges.Diverse and Inclusive Environment:
UB fosters a welcoming and inclusive environment for students from all backgrounds.Affordable Education:
UB is consistently ranked as one of the most affordable universities in the world.Vibrant Campus Life:
UB offers a wide range of activities and opportunities for students to engage in both on and off campus.Academic Programs:
UB has 13 schools and colleges, including:
- Architecture and Planning
- Arts and Sciences
- Dental Medicine
- Education
- Engineering and Applied Sciences
- Jacobs School of Medicine and Biomedical Sciences
- Law
- Management
- Nursing
- Pharmacy and Pharmaceutical Sciences
- Public Health and Health Professions
- Roswell Park Graduate Division
- Social Work
Other:
UB is committed to sustainability and has been recognized for its climate action efforts. The university has a 12:1 student/faculty ratio, providing students with personalized attention and support.
Entry Requirements:
For EU home students:
- Two A Levels with grades BB in a related subject, or
- A BTEC National Diploma (triple award) with a merit grade in a related subject, or
- A BTEC Extended Diploma with a distinction grade in a related subject, or
- A Foundation Degree in a related subject, or
- A Higher National Diploma (HND) in a related subject, or
- An Access to Higher Education Diploma with merits in at least 30 credits in a relevant subject, or
- International Baccalaureate Diploma with a minimum of 24 points
For international overseas students outside the EU:
- Two A Levels with grades BB in a related subject, or
- A BTEC National Diploma (triple award) with a merit grade in a related subject, or
- A BTEC Extended Diploma with a distinction grade in a related subject, or
- A Foundation Degree in a related subject, or
- A Higher National Diploma (HND) in a related subject, or
- An Access to Higher Education Diploma with merits in at least 30 credits in a relevant subject, or
- International Baccalaureate Diploma with a minimum of 24 points
Additional requirements:
- English language proficiency: Applicants whose first language is not English must demonstrate proficiency in English by achieving a minimum score of 6.0 in IELTS, or equivalent.
- Personal statement: Applicants should submit a personal statement outlining their reasons for wanting to study this course and their relevant skills and experience.
- References: Applicants should submit two references from academic or professional referees.
Language Proficiency Requirements:
For EU home students:
- For Applicants whose first language is not English: A minimum score of 6.0 in IELTS, or equivalent.
For international overseas students outside the EU:
- For Applicants whose first language is not English: A minimum score of 6.0 in IELTS, or equivalent.