Choose
MySQL Fundamentals Course Online in Malaysia
Completely project-based MySQL Course.
619 Google Reviews
5-star reviews by all students who joined our course.
MySQL Fundamentals Course
Best MySQL Course in Malaysia
Overview
The MySQL Fundamentals training is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.
Course Benefits
This course will teach you everything you need to know to start using the popular MySQL database in your Web, Cloud and embedded applications. In learning about MySQL you will also gain an understanding of relational databases. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.
Course Module’s Outline
Introduction to MySQL
- Course Goals
- Course Lesson Map
- Classroom Environment
- MySQL Overview
- MySQL Community Resources
- How an instance of MySQL Cloud Service differs from having an on-premises instance
- MySQL Courses and Certification
MySQL Server and Client
- MySQL Client/Server Model
- MySQL Connectors
- Installation of the MySQL server
- Starting and stopping the MySQL server
- Using the mysql client
- MySQL Workbench
Querying Table Data
- The SELECT Statement
- Query Data From An Application
- Troubleshooting Problems
Data Types
- Data Types as Part of Database Design
- Numeric Data Types
- Temporal Data Type
- String Data Types
- Character Set and Collation Support
- Data Type Considerations
- The Meaning Of NULL
Functions
- Functions in MySQL Expressions
- Using Functions
- String Functions
- Date And Time Functions
- Numeric Functions
- Aggregate Functions
- Spaces in Function Names
- RANK Window Functions
Joins and Unions
- Querying Multiple Tables
- Joining Tables with SELECT
- Inner Joins
- Outer Joins
- Table Name Aliases
- Combining Multiple Queries with UNION
Subqueries
- Nesting Queries
- Writing Simple Subqueries
- Writing Complex Subqueries
Creating Databases and Tables
- Creating a Database
- Creating a Table
- Showing How a Table Was Created
- Column Options
- Table Options
- Copying an Existing Table Structure
- Confirming the Creation of a New Table
- Copying an Existing Table Structure
- Creating a Temporary Table
- Indexes, Keys, and Constraints
Modifying Databases and Tables
- Deleting Databases and Tables
- Adding, Removing and Modifying Table Columns
- Adding, Removing and Modifying Indexes and Constraints
Modifying Table Data
- Manipulating Data
- Inserting Records
- Replacing Existing Records
- Updating Existing Records
- Deleting Records
- Exporting and Importing A Script
- Multistatement Transactions
- Modifying Data From An Application
Securing Your Database
- Manipulating Data
- Inserting Records
- Replacing Existing Records
- Updating Existing Records
- Deleting Records
- Exporting and Importing A Script
- Multistatement Transactions
- Modifying Data From An Application
Backing Up Your Database
- Importance Of Backups
- Creating a Backup
- Options for Backup
- Restoring a Backup
JSON
- JSON Use Cases
- Retrieving Data From JSON Columns
- Creating a JSON Column
- Inserting Data Into a JSON Column
- Updating a JSON Column
Conclusion
- Course Goals
- MySQL Curriculum Path
- MySQL Resources
- Evaluation
- Final Q&A
What You Will Learn
Enjoy the building process!
Highly experienced
with interview preparation
Certified trainers
24/7 support
Lifetime access to
recorded sessions
One on one assistance
Flexible schedule
Why NEXPERTS ACADEMY
The world has become so fast paced that people don’t want to stand by reading a page of info
Trusted By Students
Years Industry Experience
Percent Placement Record
Partners and Clients
We work with some of the prestigious brands of the globe.
Check out what our students say
“Nexperts Academy is well-known for networking and security courses. Their delivery is awesome, and they keep up to the industry standard.”
Mr. Shan,
Senior Lecturer, INTI International College, Subang, Malaysia.
“I recently completed the full stack training program, and I must say it exceeded my expectations in every way. The training was comprehensive, well-structured, and provided a holistic understanding of both front-end and back-end development.”
Johanna Watts
FAQs
What is the pre-requisites to take this course?
Beginners are welcome to join. Basic programming knowledge is recommended.
Can I become a programmer right away after completing this course?
Absolutely Not. It takes time, practice and experience to become one. However, with this course and all the hands-on training, we will give you real time experience used in industries, sufficient for you to start preparing for job interviews.
Do you provide support for this course?
Yes, our trainers are there to support you during training and post training.
Will I receive a certificate upon finishing this course?
Yes, you will get a personalized digital certificate downloadable as a PDF. You will need to complete over 85% of the curriculum lessons..
Can I request a refund if I am not happy with the training?
Yes, subject to our refund policies.
Which is the best Full Stack Web Development Bootcamp training company in Malaysia?
Nexperts Academy is the best in Malaysia. Our google rating is an evident of our strength in this field.
Contact Us
Let’s Connect
Together we will learn and grow!
©2023 Copyright. Nexperts Academy. SDN BHD