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

  • Microsoft Word: Essential 2013, 2016 & Online

    Microsoft Word: Essential 2013, 2016 & Online

    SGD $99.00

    Course Description

    Microsoft® Word 2013 offers enhanced features to help you create professional-quality documents, collaborate with your peers and expanded access to your files. In this online training series, you will learn about the new interface, and the basics of how to create high-quality documents that you can be proud of. Additionally, learn about Microsoft® Word 2016 and its newly introduced features as well as Word Online, increasing your word processing capabilities!Learn about the new interface of Microsoft Word 2013, and the basics of how to create high-quality documents that you can be proud of.- Master Microsoft Word 2013 with this excellent online tutorial- Know about the basics and newly added functions in Microsoft Word 2016 - Learn how you can apply this techniques into actual documents - Be able to create dynamic and of high-quality documents using Microsoft WordThis course is SkillsFuture Credit Eligible.

    Read more...

  • A Guide on working with Google SketchUp

    A Guide on working with Google SketchUp

    SGD $99.00

    Course Description

    SketchUp (formerly Google Sketchup) is a 3D modeling computer program for a wide range of drawing applications such as architectural, interior design, civil and mechanical engineering, film, and video game design. Google SketchUp enables you to build and modify 3D models quickly and easily.  As easy as it is to use, you’ll have a jump start on using this application after listening and watching your way through this great tutorial series!Have a jump start and try your hands on creating realistic 3D models with Google SketchUp.- Learn how to create virtually anything using Google SketchUp- Know how to use Google SketchUp for 3D printing - Find out your creative side while developing with Google SketchUp- Learn how to create anything from scratch after taking this courseThis course is SkillsFuture Credit Eligible.

    Read more...

  • An Essential Online Course: Microsoft Excel Course PC & MAC

    An Essential Online Course: Microsoft Excel Course PC & MAC

    SGD $79.60

    Course Description

    Cut Excel down to size with our tailored online course. Achieve certificated proficiency in hours. Available in all major PC and Mac versions. We reviewed Excel's 500 functions, ruthlessly stripping out all non-essentials, to arrive at our highly refined syllabus. Our diagnostic tool then focuses your time on those parts of that syllabus that will be most valuable to you. Our regularly updated course consists of a carefully balanced combination of text, illustrations, videos and end-of-unit tests to measure your progress. Pick up the basics of Microsoft Excel and be fluent in all of its functions! - Learn from the basics to advanced functions of Microsoft Excel  - Know about the features and functions in Microsoft Excel  - Understand the features and functions offered in Microsoft Excel  - Be able to apply the skill set into your daily work to improve productivity Training for Excel PC (PC versions: 2013, 2007/10, 2003, 2016 | Mac versions: 2011, 2016) 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.