280 likes | 554 Views
PHP & MySQL. Course Introduction. Mario Peshev. Technical Trainer. http://peshev.net. Software University. http:// softuni.bg. Table of Contents. Course Objectives Course Program Trainers Team Examination Learning Resources. PHP & MySQL. PHP & MySQL Course.
E N D
PHP & MySQL Course Introduction Mario Peshev Technical Trainer http://peshev.net Software University http://softuni.bg
Table of Contents • Course Objectives • Course Program • Trainers Team • Examination • Learning Resources
PHP & MySQL PHP & MySQL Course Course Objectives & Program
Course Objectives Get acquainted with web development basics Learn PHP and SQL Familiarize yourself with the XAMP stack Build your first web applications
PHP & MySQL – Course Topics XAMPP and LAMPP PHP Introduction PHP Flow Control Arrays in PHP Strings in PHP Working with User Input Object-Oriented Programming with PHP MySQL
PHP & MySQL – Course Topics (2) Using MySQL through PHP Web Technologies and PHP Working with Forms Exception Handling Composer Configuring PHP, Apache and MySQL Working with Files and Processes Best Practices for PHP Development
PHP & MySQL – Course Topics (3) Useful PHP Classes Sessions and Cookies Workshop – PHP and MySQL Lavarel Framework Workshop – Lavarel development
Trainers Team • Mario Peshev • WordPress Architect at DevriX • Open Source Advocate • Developing in PHP, Java and Python • WordPress Community Contributor • Speaker at hundreds of events • Web site & blog: www.peshev.net
PHP & MySQL Course: More Details Duration, Languages, Technologies
Training Duration – PHP & MySQL Lectures: ~ 20hours (onsite + YouTube videos) Practical exercises (in class): ~ 20hours Homework: ~ 40-80 hours Exam preparation: ~ 4 hours Exam: 6 hours Schedule: June – September 2014
Why PHP and MySQL? • The PHP platform is very popular • Free and open-source software • Runs everywhere, on millions of servers • Powering websites like Facebook and Wikipedia • The MySQL Database • The most popular Open Source RDBMS • Multiplatform and widely supported
Why English? • Why the slides are in English? • English is the native languageof the software engineers • Specific terminology should be in English • Translations are inaccurate and funny • Just learn English! • No excuses
PHP & MySQL Evaluation Criteria
Scoring System • Exam– 75% (80% for online students) • Homework + evaluation – 5% + 5% • Team work: 10% • Presence in class: 5% (onsite students only) • Bonuses: up to10% • Assistant bonuses • Forum bonuses • Others
The PHP & MySQL Practical Exam • Practical programming exam • Writing robust and secure PHP code • Utilizing the power of MySQL • Adhering the best web development code practices
Homework Assignments • Doing your homework is very important! • Programming can only be learned through a lot of practice! • You should write code every day! • Each lecture is followed by a few exercises • Try to solve them in class • The rest are your homework • Homework assignments are due in 2 weeks after each lecture • Submission will be accepted through our web site: softuni.bg
Resources What We Need Additionally?
Course Web Site & Forums https://softuni.bg/trainings/fasttracks/details/1033 https://softuni.bg/forum • The PHP & MySQL official web site: • Register for the "Software University Forum": • Discuss the course exercises with your colleagues • Find solutions for all course exercises • Share source code / discuss ideas / help each other
The PHP & MySQL Slides and Videos • All lecture slides, videos, homeworkassignments, projects and other resources are open content, available for free • Visit the course web site to access the course resources
Additional PHP Resources • http://php.net/ • http://www.phptherightway.com/ • http://www.phpdeveloper.org/
Software University Learning System (SULS) • Software University Learning System (SULS) • www.softuni.bg • Important resource for students • Homework submissions • Homework check-up • Exams and results • Reports about your progress
Required Software • Recommended software for the PHP & MySQL course: • Linux + Apache + MySQL • Windows + XAMPP • Eclipsefor PHP • Aptana Studio • Netbeans
Summary PHP & MySQL The course would cover the XAMP stack You will get well versed in writing web applications Getting used to PHP will make you a betterprogrammer regardless of the technology
PHP & MySQL – Course Introduction https://softuni.bg/trainings/fasttracks/details/1033
License • This course (slides, examples, demos, videos, homework, etc.)is licensed under the "Creative Commons Attribution-NonCommercial-ShareAlike4.0 International" license • Attribution: this work may contain portions from • "PHP Manual" by The PHP Group under CC-BY license • "PHP and MySQL Web Development" course by Telerik Academy under CC-BY-NC-SA license
Free Trainings @ Software University • Software University Foundation – softuni.org • Software University – High-Quality Education, Profession and Job for Software Developers • softuni.bg • Software University @ Facebook • facebook.com/SoftwareUniversity • Software University @ YouTube • youtube.com/SoftwareUniversity • Software University Forums – forum.softuni.bg