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

  • Cubase 8

    Cubase 8

    SGD $45.00

    Course Description

    Steinberg's Cubase Elements 8 is their entry level, professional digital audio workstation. It contains all the aspiring musician and mix engineer requires to get started with audio and midi recording compositions. This VTC course covers installation issues and preference setting before moving on to connecting the program to a relevant soundcard. As the course progresses, functions such as creating busses and the implementation of the inspector are looked at prior to focusing on building a project.Learn how to work with audio files with Cubase 8. - Know how Cubase 8 handles audio files- Learn how to edit your own audio files with Cubase 8- Discover the potential of Cubase 8 with your audio files- Master audio editing with all the right tools and techniques in Cubase 8

    Read more...

  • eLearning Brother Master Suite (SGD)

    eLearning Brother Master Suite (SGD)

    SGD $6,648.67

    Course Description

    Original Price: $6,998.60 SGD                                       Sale Price: $6,648.67 SGD   Checkout via Smoovpay   Become an eLearning Rockstar | Characters | Scenarios | Games & Quizzes | Stock Assets | Icons | xAPI Templates | Mobile Learning | To be a true eLearning Rockstar™, you need the entire tool set. Meet the eLB Master Suite—the ultimate collection of eLearning resources. The eLB Master Suite gives you an unparalleled asset library, fully developed, customizable eLearning courses, and games from the award-winning game authoring tool, The Training Arcade™. Whatever form of training you need to develop, the eLB Master Suite will help you shine. Includes the following: * Cutout People  * eLearning Templates  * Stock Assets  * PowerPoint Graphics * Icons 

    Read more...

  • FileMaker Pro 12: Advanced

    FileMaker Pro 12: Advanced

    SGD $63.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts, script triggers and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning.  Discover how data can be managed efficiently.  - Find out how you can manage your database - Learn ways to fully utilize your data's potential  - Know how queries can be implemented to run the data better  - Understand an effective solution to optimize your database's productivity  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.