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

This course is SkillsFuture Credit Eligible.


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

  • Be Your Own Conductor with Logic Pro X

    Be Your Own Conductor with Logic Pro X

    SGD $89.00

    Course Description

    Published author Sam McGuire helps you master the power of Logic Pro X. He starts by exploring the basic functionality and then focuses on raw power this widely used Digital Audio Workstation. This VTC course focuses on the skills required to use the included instruments and effects, editing powerfully with tools such as flex time and quick swipe comping, and master the newest features in this latest version of Logic Pro. Practice new techniques using the provided work files.Create your own original works with Avid Pro Tools!- Learn the tools and techniques of Logic Pro X- Know how to enhance your videos with Logic Pro X- Discover the secrets of producing a quality audio- Learn the ropes of creating your own master piece with this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Getting Started with Office 365 for Business

    Getting Started with Office 365 for Business

    SGD $45.00

    Course Description

    Office 365 for business provides a cloud-based service that gives users access to email, calendars, files and programs on a variety of platforms. In this course students will learn how to manage an Office 365 organization. Students will work with basic online applications such as Word, Excel, PowerPoint and OneNote and learn how to collaborate with others on files created in those programs. Students will learn how to utilize the extensive options within Outlook, OneDrive, Lync and create public sites or team sites. Organization administrators will understand how to work with the many settings and tools in the online Office 365 Admin Center, Exchange Admin Center, Lync Admin Center & SharePoint Admin Center.Get a head start on your tasks with Office 365!- Learn about the different products in Office 365- Know more about each of their purpose and functions- Improve your productivity by adopting Office 365 - Be fluent in Office 365 and accomplish your tasks effectively 

    Read more...

  • Google Docs & More: Maximize your online collaboration with Google

    Google Docs & More: Maximize your online collaboration with Google

    SGD $99.00

    Course Description

    Use Google Docs to create documents for collaboration with others online. Google™ Docs has numerous tools for editing and formatting your documents. In this online training series, we’ll learn to format text, add images, links, and comments. We’ll also explore tools for replacing words, checking spelling, and adding a table of contents. Make it easy to share your documents online and collaborate with others. We’ll explore some sharing options through email, invite individuals to collaborate, and manage our list of editors. You’ll also learn to assign ownership of a document, and set downloading options.Make it easy to share your documents online and collaborate with others!- Learn and understand the basics of Google Docs and their features- Be updated on the new kind of Web mail - Learn techniques of Goggle's spreadsheet functions - Know how Google™ Forms can bring productivity and results This course is SkillsFuture Credit Eligible.

    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.