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

  • Vyond Professional Plan (SGD)

    Vyond Professional Plan (SGD)

    SGD $1,328.10

    Course Description

    Original Price: $1,398 SGD                                          Special Pricing by ACP: $1,328.10 SGD   Checkout via Smoovpay   Powerful. Captivating. Simple. Create dynamic media with Vyond. You Can Be a Video Producer.  With Vyond, anyone can make media that moves. Built for professionals of all skill levels in all industries, Vyond lets you create dynamic videos for any audience. The ideal plan for individual business needs. Export animated GIFs and videos - with your own branding, live chat support, and access to the Vyond Community.   PROFESSIONAL PLAN FEATURES ·        All Vyond Premium features ·        Priority service queue & live chat support ·        Font import ·        Common Craft templates  ·        Contemporary Character Creator TEAM FEATURES ·        Shared libraries ·        Video collaboration  ·        User management panel  ·        Video sharing features  ALL PLANS INCLUDE ·        Unlimited video creation ·        Unlimited download/export ·        Import audio & image files ·        Import MP4 video files   Check out original pricing @ https://www.vyond.com/plans/business/   “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 .

    Read more...

  • Articulate 360 Team (USD)

    Articulate 360 Team (USD)

    SGD $1,268.00

    Course Description

    Original Price: $1,399 USD                                               Sale: $1,268 USD   Checkout Now     Our representative will email you to setup your subscription after your order is processed 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...

  • Vyond Premium Plan (USD)

    Vyond Premium Plan (USD)

    SGD $616.55

    Course Description

    Original Price: $649 USD                                               Sale: $616.55 USD   Checkout Now     Our representative will email you to setup your subscription after your order is processed Powerful. Captivating. Simple. Create dynamic media with Vyond. You Can Be a Video Producer.  With Vyond, anyone can make media that moves. Built for professionals of all skill levels in all industries, Vyond lets you create dynamic videos for any audience. The ideal plan for individual business needs. Export animated GIFs and videos - with your own branding, live chat support, and access to the Vyond Community.   PREMIUM PLAN FEATURES * 1080p and 720p resolution download * No Vyond logo on videos * Export as animated GIF * Live chat support * Access to Vyond Community * Character Creator (Business Friendly and Whiteboard) * click MP4 creation ALL PLANS INCLUDE * Unlimited video creation * Unlimited download/export * Import audio & image files * Import MP4 video files   Check out original pricing @ https://www.vyond.com/plans/business/   “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...


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.