|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-mysql-for-beginners/
课程评论：没有评论
课程名称：初学者学习MySQL 课程概述：本课程旨在教授学员如何使用MySQL创建数据库驱动的网页应用程序。学员将学习如何在PHP网页应用开发中集成和管理MySQL数据库。课程开始时深入介绍PhpMyAdmin工具，以创建、删除和修改数据库，并探讨安全性及用户权限的相关考虑。随后，学员将学习如何在PHP中与现有数据库建立连接，并使用基本的SQL语句执行命令。 学习内容包括： - MySQL数据库管理 - PhpMyAdmin基础知识 - MySQL安全性和根超级用户 - 数据表的创建 - 创建用户 - 修改数据库权限 - 修改和删除数据表 - 修改和删除数据库 - SQL基础知识 - 在PhpMyAdmin中的SQL语句 - 数据库连接 - MySQL数据的导入与导出 - 更新MySQL数据库中的数据 关键概念： - 数据库简介 - PhpMyAdmin介绍 - PhpMyAdmin界面概述 - MySQL安全性和根超级用户 - MySQL创建数据库和表 - MySQL创建新用户 - MySQL数据库和表的特定权限 - MySQL修改和删除数据库 - SQL介绍 - PhpMyAdmin中的SQL语句 - 使用PHP连接MySQL数据库 - MySQL数据库的数据导入 - SQL选择语句 - SQL DISTINCT关键字 - SQL WHERE子句 - SQL AND运算符 - SQL OR运算符 - SQL ORDER BY - MySQL插入数据 - MySQL获取最后插入的ID - MySQL预处理语句 - MySQL删除记录 - PHP头函数 - PHP isset函数 - MySQL更新记录 授课教师：YouAccel是领先的在线培训提供商，提供包括IT与开发、商业、市场营销、设计和生产力等多个行业的课程。课程可以按个人进度学习，并提供初级、中级和高级多个水平。在线课程还兼容任何移动设备，以提供最佳的便利性。
Course: Learn MySQL - For BeginnersLearn to Create Database Driven Web Applications using MySQLStudents learn to integrate and administer MySQL databases as part of PHP web application development.The course begins with an in-depth look into PhpMyAdmin to create, delete and modify databases. We also explore security considerations and user privileges.Next, students learn to build connections to existing databases in PHP, and execute commands using several essential SQL statements.What you'll learn - Overview:MySQL Database AdministrationPhpMyAdmin FundamentalsMySQL Security and Root SuperuserCreate TablesCreating UsersModifying Database PrivilegesModifying & Deleting TablesModifying & Deleting DatabasesSQL FundamentalsSQL Statements in PhpMyAdminDatabase ConnectionsMySQL Import & Export DataUpdating Data in MySQL DBKey Concepts:Introduction to DatabasesIntro to PhpMyAdminPhpMyAdmin Interface OverviewMySQL Security and Root SuperuserMySQL Creating a Database and TableMySQL Creating a New UserMySQL Database and Table Specific PrivilegesMySQL Modifying and Deleting a DatabaseIntroduction to SQLSQL Statements in PhpMyAdminConnect to MySQL Database using PHPMySQL Database - Import DataSQL SelectSQL Distinct KeywordSQL Where ClauseSQL And OperatorSQL Or OperatorSQL Order ByMySQL Insert IntoMySQL Get Last IDMySQL Prepared StatementsMySQL Delete RecordsPHP Header FunctionPHP IssetMySQL Update RecordsYour Instructor:YouAccel is a leading provider in online training, offering courses across numerous industries from IT and Development to Business, Marketing, Design, and Productivity.The courses can be taken at one's own pace and are offered at several levels including beginner, intermediate and advanced. Online courses are also compatible with any mobile device for the ultimate in convenience.
