Course: Learn MySQL – For BeginnersLearn to Create Database Driven Web Applications using MySQL
Students 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 DB
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 Records
Your 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.