MySQL Fundamentals


  • MySQL Fundamentals, Singapore elarning online course
  • MySQL Fundamentals, Singapore elarning online course
  • MySQL Fundamentals, Singapore elarning online course
  • MySQL Fundamentals, Singapore elarning online course
  • MySQL Fundamentals, Singapore elarning online course
  • MySQL Fundamentals, Singapore elarning online course

Course Description

If you're new to web development, MySQL is the most popular database technology out there. This free technology is used to create the majority of database dependent websites (which most are). This course will start at the very beginning, with lessons on what MySQL is and how it works, to installing MySQL, then moving on to all the basic skills you'll need to use MySQL in the real world. You will also learn the popular new MySQLi framework. MySQLi is the next generation of MySQL, and if you know this now you will be ahead of the competition for a long time to come.

Master MySQL and manage your own web database

- Know how to manage your database with MySQL
- Learn ways to utilize your data for productivity
- Know more about MySQL and its advantages
- Learn how to improve your database system


Course Objectives

1. Learn how MySQL works in the real world
2. Install MySQL
3. Learn about the new MySQLi framework
4. Understand working with databases
5. Complete two real life MySQL projects
6. Learn how MySQL and PHP work together
7. Work with a MySQL database with PHP to build applications that depend on a database connection.


Related Courses

  • eLearning Brother Master Suite (SGD)

    eLearning Brother Master Suite (SGD)

    SGD $6,648.67

    Course Description

    Original Price: $6,998.60 SGD                                       Sale Price: $6,648.67 SGD   Checkout via Smoovpay   Become an eLearning Rockstar | Characters | Scenarios | Games & Quizzes | Stock Assets | Icons | xAPI Templates | Mobile Learning | To be a true eLearning Rockstar™, you need the entire tool set. Meet the eLB Master Suite—the ultimate collection of eLearning resources. The eLB Master Suite gives you an unparalleled asset library, fully developed, customizable eLearning courses, and games from the award-winning game authoring tool, The Training Arcade™. Whatever form of training you need to develop, the eLB Master Suite will help you shine. Includes the following: * Cutout People  * eLearning Templates  * Stock Assets  * PowerPoint Graphics * Icons 

    Read more...

  • Lectora Online (SGD)

    Lectora Online (SGD)

    SGD $1,848.70

    Course Description

    Original Price: $1,946 SGD                Sale: $1,848.70 SGD   Checkout via Smoovpay   Collaborative Online Authoring For eLearning on Any Device, Anywhere   Lectora’s powerful authoring along with real-time collaboration, automated versioning and backup, built-in workflow and project management, and integrated content management. Lectora Online is your new favorite tool. It combines the power of Lectora’s desktop authoring solution with the freedom of cloud authoring. eLearning development just got a whole lot easier!   Check out original price @  https://www.trivantis.com/product/lectora-online/   “A Guide on Instructional Design Theories and Design Application” worth $500 USD will be bundled at no cost for purchase during Black Friday.

    Read more...

  • Articulate 360 Team (USD)

    Articulate 360 Team (USD)

    SGD $1,234.05

    Course Description

    Original Price: $1,299 USD                                               Sale: $1,234.05 USD   Checkout via Smoovpay   Get everything you need to create e-learning   Articulate 360 includes both Storyline and Rise, plus a slew of other authoring apps. Use Storyline 360 to develop custom, interactive courses that work on every device—without any manual tweaking. It's powerful enough for experts, but easy for beginners to create virtually any interaction imaginable. Choose Rise when you want to build fully responsive courses in minutes. All you need is a web browser to quickly create beautiful courses optimized for every screen size. “A Guide on Instructional Design Theories and Design Application” worth $500 USD will be bundled at no cost for purchase during Special Pricing by ACP.   Check out original pricing @ https://articulate.com/pricing      

    Read more...


Content

Fundamentals of MySQL - Introduction to MySQL

Preview Available

+

What Is MySQL? 

Installing MySQL 

Accessing the MySQL Monitor 

Using PHPmyAdmin 

The Basics of MySQL

Preview Available

+

Deleting Databases 

Creating Tables 

Listing and Describing Tables 

Inserting Records 

Selecting Records 

Renaming Tables 

Auto Increment IDs 

Updating Records 

Deleting Records 

Limiting Records 

Ordering Records 

Joins 

Like Clause 

Counting Records 

Creating Databases 

Introduction to MySQL and PHP

+

Introduction to MySQLi 

Introduction to PHP Data Objects 

MySQLi Basics

+

Getting Connected 

Basic Queries 

Looping Through Results 

Getting Result Counts 

Variables in Queries 

SQL Injections 

Escaping Values 

Getting Results 

Prepared Statements 

Project | Creating a Database Wrapper

+

Introduction 

Creating a Test Database 

Basic Functionalities 

Adding More Functionalities 

Project | Building a Contact Form

+

Introduction 

Creating the Table 

Inserting Your Records 

Outputting the Data 

MySQL for Beginners - Introduction

+

Introduction 

Getting Started with MySQLi

+

Connecting To A Database 

Connecting Using PHP 

Creating a Database Table 

Fetching Results

+

Pulling Single Records 

Pulling Multiple Records 

Different Result Types 

Getting Results

+

Counting Results 

Updating and Seeing Affected Rows 

Security

+

Escaping 

Prepared Statements for Inserting 

Selecting Prepared Statements 

Finishing Up

+

Freeing Results 

Closing the Database Connection 

SGD $79.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.