Web Applications for Everybody 특화 과정
Build dynamic database-backed web sites.. Use PHP, MySQL, jQuery, and Handlebars to build web and database applications.
제공자:
배울 내용
Installing your development environment
Developing a database application with PHP and MySQL
Using JavaScript to interact with a PHP web app
Modeling many-to-many relationships
귀하가 습득할 기술
이 전문 분야 정보
응용 학습 프로젝트
The courses in this specialization feature assignments requiring development of increasingly challenging web sites, to demonstrate basic concepts as they are introduced. The projects will demonstrate the students skills in HTML, CSS, PHP, SQL, and JavaScript.
관련 경험이 어느 정도 필요합니다.
관련 경험이 어느 정도 필요합니다.
이 전문 분야에는 4개의 강좌가 있습니다.
이 전문 분야에는 4개의 강좌가 있습니다.
Building Web Applications in PHP
In this course, you'll explore the basic structure of a web application, and how a web browser interacts with a web server. You'll be introduced to the request/response cycle, including GET/POST/Redirect. You'll also gain an introductory understanding of Hypertext Markup Language (HTML), as well as the basic syntax and data structures of the PHP language, variables, logic, iteration, arrays, error handling, and superglobal variables, among other elements. An introduction to Cascading Style Sheets (CSS) will allow you to style markup for webpages. Lastly, you'll gain the skills and knowledge to install and use an integrated PHP/MySQL environment like XAMPP or MAMP.
Introduction to Structured Query Language (SQL)
In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.
Building Database Applications in PHP
In this course, we'll look at the object oriented patterns available in PHP. You'll learn how to connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL commands in the the PHP language. We'll also look at how PHP uses cookies and manages session data. You'll learn how PHP avoids double posting data, how flash messages are implemented, and how to use a session to log in users in web applications. We'll then build the first 'complete' application that has multiple screens to Create, Read, Update and Delete (CRUD) our data. This brings all the previous concepts together and will form the basis for all later web applications. It is assumed that learners have already taken the Building Web Applications course in this specialization.
JavaScript, jQuery, and JSON
In this course, we'll look at the JavaScript language, and how it supports the Object-Oriented pattern, with a focus on the unique aspect of how JavaScript approaches OO. We'll explore a brief introduction to the jQuery library, which is widely used to do in-browser manipulation of the Document Object Model (DOM) and event handling. You'll also learn more about JavaScript Object Notation (JSON), which is commonly used as a syntax to exchange data between code running on the server (i.e. in PHP) and code running in the browser (JavaScript/jQuery).
제공자:

미시건 대학교
The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.
자주 묻는 질문
전문 분야를 완료하면 대학 학점을 받을 수 있나요?
Can I just enroll in a single course?
하나의 강좌에만 등록할 수 있나요?
Can I take the course for free?
해당 강좌를 무료로 수강할 수 있나요?
이 강좌는 100% 온라인으로 진행되나요? 직접 참석해야 하는 수업이 있나요?
전문 분야를 완료하는 데 얼마나 걸리나요?
Do I need to take the courses in a specific order?
Will I earn university credit for completing the Specialization?
전문 분야를 완료하면 대학 학점을 받을 수 있나요?
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.