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

  • Math & Statistics: Training Tutorials for SPSS and Graphic Calculators

    Math & Statistics: Training Tutorials for SPSS and Graphic Calculators

    SGD $99.00

    Course Description

    SPSS Statistics is a software package used for statistical analysis. Long produced by SPSS Inc., it was acquired by IBM in 2009. The current versions (2015) are officially named IBM SPSS Statistics. Master Math & Statistics with this bundled course that includes training tutorials on BA II PLUS PROFESSIONAL, SPSS, TI-30XS MultiView calculator, IBM SPSS Statistics, TI-Nspire handheld, TI-Nspire CX handheld and TI-84 Plus C Silver Edition. Atomic Learning has teamed up with Texas Instruments to create tutorials that answer common questions students and teachers may have when learning how to use TI-Nspire™ and TI-Nspire™ CAS math and science learning technology. Be able to understand and utilize your analysis with SPSS. - Improve your business using SPSS analytic functions- Using SPSS, examine and solve a research problem, from hypothesis testing to the power analysis- Using BA II PLUS PROFESSIONAL to take advantage of all the same time-saving financial functions- Learn about TI-Nspire handheld, TI-Nspire CX handheld and TI-84 Plus C Silver Edition graphing calculator

    Read more...

  • Microsoft Word 2013

    Microsoft Word 2013

    SGD $49.00

    Course Description

    In this VTC course, students will learn how to work with basic to advanced functions of Microsoft Word 2013. This efficient word processing program allows you to edit text, graphics, tables, page layouts, styles, and more. Intermediate to advanced users will learn how to complete a mail merge, use screenshots or clippings, implement hyperlinks, set up collaboration, create a table of contents, and utilize macros. Microsoft Word even provides connected services so users can utilize social media networks within files. Word is part of the cloud, SkyDrive, which allows everyone to utilize remote access anywhere, anytime. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Data Structures and Algorithms in C++

    Data Structures and Algorithms in C++

    SGD $40.00

    Course Description

    This is an introductory course about algorithms and data structures. C++ is the programming language used in the course. The basics of this language will be reviewed before more difficult concepts are explored. VTC author and expert Dima Kassab will examine many topics, including: data design and implementation, primitive data structures (such as arrays and records), classes, templates, sorted and unsorted array-based lists, linked lists, doubly linked lists, stacks, queues, and binary search trees. Pick up a new programming language into the mix of new skills!- Pick up a new programming language - Increase your employability with an extra language under your belt - Learn how the different languages work to develop web site and applications - Be able to optimize your database using the structure and search features

    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.