Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 59 Minute(s)
Language
English
Taught by
Edmund P Obiri & IT Training Center
Rating
Course Overview
Ultimate MySQL Beginner Course for Data Analyst and Software Developers with Python, NodeJS & PHP Database Projects
Master MySQL for Beginners: Build Your First Database Application in 2024
Are you curious about how tech giants like Facebook, Google, and Twitter manage and manipulate data? Ever wanted to create dynamic web applications that interact with databases? This comprehensive MySQL course is perfect for you. Whether you're a complete beginner or a programmer new to databases, this course will equip you with the essential skills needed to excel in database management.
Why Learn MySQL?
MySQL is the world’s most popular database, used by industry leaders such as FACEBOOK, APPLE, YOUTUBE, and EBAY. Learning SQL opens doors to various job opportunities, from database administration to freelance programming. This course is designed to be easily understood by absolute beginners and provides a robust foundation in MySQL and MariaDB.
Course Overview
This course offers a step-by-step guide to mastering MySQL from scratch. You’ll learn how to query and manipulate databases effectively and build a real-world database application. The concepts taught here are applicable to other relational database management systems like PostgreSQL, SQL Server, DB2, and Oracle.
What You’ll Learn:
Database Fundamentals: Understand the core concepts of databases and relational database management systems.
SQL Basics: Learn how to create, alter, and manage MySQL and MariaDB tables with practical examples.
CRUD Operations: Master the essential SQL commands for inserting, selecting, updating, and deleting data.
Connecting Databases: Use Python and PHP APIs to connect and query MySQL and MariaDB databases.
Building Applications: Develop a database application from scratch using Python, PHP and NodeJS.
Advanced SQL Techniques: Utilize regular expressions, perform mathematical calculations, and manage date and time formatting.
Transactions and Joins: Implement transactions and learn how to query multiple tables using JOINS.
Subqueries and Storage Engines: Dive into subqueries and explore different storage engines in MySQL.
Real-World Application:
By the end of this course, you will be able to build a fully functional Python, PHP and NodeJS application that interacts with a MySQL database. This practical experience will prepare you for real-world database management and application development.
Student Testimonials:
“Excellent course!! The instructor is very knowledgeable about Database development using MySQL and MariaDB and presents concepts in a detailed, methodical way.” – Brava Man
“This is a good course for MySQL beginners. The instructor explains all the topics clearly and uses useful examples to understand each topic.” – Rafael Godinez
“Gives you a great explanation of many different SQL commands and how they work. The example project at the end really tied everything together, and I learned some PHP as well.” – David Leacock
Why Enroll?
Lifetime Access: Gain instant lifetime access to the course materials.
30-Day Money-Back Guarantee: If you’re not satisfied, get a full refund within 30 days.
Expert Instruction: Learn from an experienced instructor with hands-on, step-by-step tutorials.
Thank you, and I hope to see you in the course!
Course Content
- 14 section(s)
- 54 lecture(s)
- Section 1 NEW: Introduction to MySQL
- Section 2 NEW: Basics of MySQL
- Section 3 Modifying Tables
- Section 4 NEW: Inserting and Managing Data
- Section 5 NEW: Updating and Deleting Data
- Section 6 NEW: Querying Data
- Section 7 NEW: Advanced Data Handling
- Section 8 NEW: Joins and Advanced Queries
- Section 9 NEW: Project 1 - Connecting to MySQL from Python (Task App)
- Section 10 NEW: Project 2 : Connecting to MySQL from PHP (User Management system)
- Section 11 NEW: Project 3 : Connecting to MySQL from NodeJS (Task App)
- Section 12 OLD: Transaction
- Section 13 OLD: PHP CRUD Application
- Section 14 Next Step
What You’ll Learn
- Learn to use SQL to perform data analysis and build database applications, You will learn how to manipulate MySQL/MariaDB database with real world examples., Have a solid foundation for RDBMS databases and SQL in general, How to work with MySQL Workbench, You will learn how to insert, select, update, delete data in MySQL database., Use Python, NodeJS and PHP API to connect and query MySQL, How to use Regular Expressions (REGEXP) in SQL., You will learn how to perform mathematical calculations with functions and Date Time formatting., Build a database application from scratch with Python, PHP and NodeJS, How to use built-in functions to find, format, extract and convert text, Write complex SQL queries across multiple tables and so on
Skills covered in this course
Reviews
-
MMaria Utsalo
Excellent. You're an amazing teacher. I learned so much for taking your mariaDB course. I've also purchased another one of your course Modern PHP MySQL Masterclass from scratch-chat box project. Learning your mariadb has made me to develop interest for PHP application development. Though, one area is missing from the mariadb, we created a few databases and tables in mariaDB but those database were never used to interact with the front end application, rather, we created another database (crud) in phpmyadmin that interacted with the frontend. Where, when and how do you create application that will interact with the mariadb databases?
-
유유병철 유
Too expensive for this basic course. Sometimes it's hard to understand his accent.
-
NNigel Reed
For beginners it was pretty clear what to do and how to do it, at the start. Towards the end a lot fo things were not covered and just assumed, like css and html to get the form working.
-
DDominic Abucejo
Great course for learning (even for reviewing) SQL concepts. The topics are short and straight to the point which is great for folks who are trying to learn things in a short amount of time.
