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

  • Articulate Storyline 3 (SGD)

    Articulate Storyline 3 (SGD)

    SGD $1,859.15

    Course Description

    Original Price: $1,957 SGD                                               Special Pricing by ACP: $1,859.15 SGD   Checkout via Smoovpay   Create interactive courses for any device​ Articulate Storyline is the industry's favourite software for creating interactive courses. It's simple enough for beginners, yet powerful enough for experts. And it lets you create virtually any interaction you can imagine, in minutes. With the new perpetual version of Storyline, you'll be able to deliver mobile and accessible courses with enhanced interactivity faster.   “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/p/storyline-3#buy

    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...

  • Articulate 360 Personal (USD)

    Articulate 360 Personal (USD)

    SGD $949.05

    Course Description

    Original Price: $999 USD       Sale: $949.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/freelancers    

    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.