Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Programming Languages MySQL

MySQL MariaDB From Scratch - Become an App Developer in 2021

The Ultimate MySQL MariaDB Beginner Course with EXAMPLES and PROJECT that will take you towards becoming an SQL Master
Rating: 4.7 out of 54.7 (58 ratings)
1,520 students
Created by Edmund P Obiri, M.Tech
Last updated 11/2019
English
30-Day Money-Back Guarantee

What you'll learn

  • You will learn how to manipulate MySQL MariaDB database with real world examples.
  • Have a solid foundation for RDBMS databases and SQL in general
  • You will learn how to insert, select, update, delete data in MySQL database.
  • Use PHP API to connect and query MySQL MariaDB.
  • 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 PHP and Bootstrap
  • How to use built-in functions to find, format, extract and convert text
  • You will learn how to implement transaction in MySQL or MariaDB
  • You will learn how to build any database application from scratch
  • Use SQL to perform data analysis
  • Write complex SQL queries across multiple tables

Course content

11 sections • 55 lectures • 1h 54m total length

  • Preview01:40
  • Preview03:11
  • Preview01:31
  • Datatypes
    01:14
  • Requirement
    01:07
  • Setting Up our environment 1
    01:48
  • Setting Up our environment 2
    02:14
  • Section #1 Quiz
    1 question
  • Section #1 Quiz
    1 question
  • Section #1 Quiz
    1 question

  • Preview01:26
  • Getting started
    01:15
  • Creating database
    01:18
  • Drop database
    00:53
  • Using a database
    00:44
  • Create Table (basic syntax)
    01:18
  • Execute & describe Table
    00:51
  • Create Table (datatypes)
    01:01
  • Create Table (constraints)
    01:15
  • Other method of create table
    02:11
  • Alter Table (add column)
    01:26
  • Alter Table (modify & drop)
    01:44
  • Rename & Drop Table
    01:30

  • Insert (Basic syntax)
    02:21
  • Insert 2
    00:58
  • Insert From Table
    01:33
  • Insert with auto_increment
    02:07
  • Update row
    00:52
  • Delete row
    00:54

  • First thing first
    02:15
  • Select statement
    01:46
  • Ordering, Alias & Limits
    01:19
  • Filtering result with WHERE
    01:11
  • Filtering result with LIKE and IN
    01:48
  • Filtering result with NOT and OR
    02:01
  • Using Regular Expression
    04:40

  • String Functions
    04:15
  • Numeric Functions
    03:04
  • Aggregate Functions
    03:22
  • Date and Time Functions
    04:24

  • Transactions
    04:03

  • Preview01:05
  • Joins
    02:33
  • Unions
    01:56

  • subquery 1
    03:21
  • subquery 2
    01:16

  • Preview02:01
  • storage engine 2
    03:03

  • Preview01:18
  • Preview03:15
  • Setting things up
    01:43
  • Creating database, user and table
    02:59
  • Connecting to database
    07:06
  • Inserting data into database
    05:29
  • Displaying database records
    00:51
  • Updating record into database
    01:17
  • Deleting record in the database
    01:00

Requirements

  • No prior experience on coding is required.
  • Desire to learn NEW skills.
  • No purchase of any software. Every thing is absolutely free.

Description

The Ultimate MySQL MariaDB Beginner Course

Have you ever taught of how Facebook, Google, Twitter, Wikipedia and many others, manages and manipulates data or (post) behind the scene?  Ever wanted to create a dynamic web application and software that could interact with or store information on the database? Then this MySQL MariaDB course is for you. Database is an in-demand skill for any one who want to become IT expert. Learning  SQL opens a new dimension in jobs, where you can work as a database administrator in IT companies or you can become a freelancer. Whether you’re a complete beginner or a programmer new to databases don't worry I designed this MySQL MariaDB programming course to be easily understood by absolute beginners.

This course is comprehensive and straight-forward to get you up to speed on how to query and manipulate databases. You will Learn MySQL MariaDB from scratch and build a Database Application. The concept i will be teaching you in this course is basically the same for both MySQL and MariaDB as well as other relational database management systems such as PostgreSQL, SQL Server, DB2, Oracle etc. As the most popular database in the world, MySQL is used by FACEBOOK, APPLE, YOUTUBE, EBAY, WORDPRESS etc. While MariaDB  is used by GOOGLE, WIKIPEDIA, REUTER, OLX, TUMBLR, NIMBUZZ etc.

No wonder SQL is one of the languages theoretically taught in computer science classes but a lot of what is been said is not applicable in day to day programming, this is one of the reason this course is well structured to teach you the foundation of databases and how you can apply it in real-life.; with over 50 Video lectures leaving no stone on turned. Hence at the end of this course, you will be able to build a PHP application that interact(SQL) with database?

BELOW ARE WHAT STUDENTS ARE SAYING ABOUT THIS COURSE AND THE REASONS YOU SHOULD TAKE THIS COURSE

Excellent course!! The instructor is very knowledgeable about Database development using MySQL and Maria-db and is able to present the concepts in a detailed and methodical way. Topics are introduced, then explained in detail, this is then followed with hands-on, step-by-step tutorial style demonstrations that further reinforce and allow for a greater understanding of the technology and how a schema can be implemented and accessed -

Brava man

This is a good course for MySQL beginners, the instructor explains all the topics clearly and uses useful examples in order to understand each topic  - Rafael Godinez 

Gives you a great explanation of many different SQL commands and how they work. I learned a lot. For a 90 minute course you learn a lot. The example project at the end really tied everything together and I learned some PHP as well - David Leacock

This course is a great course and i would recommend to every computer science student in my class. I'm now proficient in SQL. Thank you instructor for your clear explanation -

Sampson Stella 

SOME OF THE MAJOR TOPICS WE WILL COVER IN THIS COURSE INCLUDE:

  • You will learn how to create, alter MySQL MariaDB tables with real world examples.

  • You will learn how to insert, select, update, delete data.

  • Use PHP API to connect and query MySQL and MariaDB.

  • You will learn how to build any database application from scratch using PHP

  • How to use Regular Expressions (REGEXP) in SQL.

  • You will learn how to perform mathematical calculations with numeric functions and Date Time formatting.

  • How to use built-in functions to find, format, extract and convert text.

  • You will learn how to implement transaction in MySQL and MariaDB.

  • You will have a solid foundation for RDBMS databases and SQL in general.

  • Subquery in MySQL and MariaDB

  • Different storage engines in MySQL.

  • How to query multiple table with JOINS.

  • How to combine multiple query with UNION. etc

LIFE TIME ACCESS:   By enrolling in this course you have an instant Life- Time access

30 DAY MONEY BACK GUARANTEE:  This course comes with a 30 day money back guarantee! If you are not satisfied in any way, you will be refunded of your money.  

THANK YOU AND I HOPE TO SEE YOU IN THE COURSE

Who this course is for:

  • This course is meant for TOTAL beginners in databases.
  • Anyone who wants to become an expert in IT.
  • Graduate and undergraduate students.
  • Desktop & mobile application developers.
  • Any one seeking for a job opportunity.

Instructor

Edmund P Obiri, M.Tech
Senior Developer
Edmund P Obiri, M.Tech
  • 4.4 Instructor Rating
  • 135 Reviews
  • 5,134 Students
  • 7 Courses

Hello, my name is Edmund P Obiri with M.Tech in Computer Science and Engineering. This cross-discipline study gives me the advantage of becoming a skilled professional with a thorough understanding of the concepts and techniques in areas that are likely to influence and affect your career, such as programming or artificial intelligence.   

I'm a Senior developer for a long time now with expertise on Python, JavaScript, PHP,  SQL,  Arduino and others. i'm so passionate about providing clear instruction and extensive teaching experience. My method of teaching has made my students achieve their goals in life.  I have been developing web applications and software since 2010 and have worked for individuals & organisations in Canada, USA, Asia and other part of the world.

I truly believe that online learning platforms like Udemy is here to stay as they opened an amazing opportunities for almost everyone to learn from others and in addition share their knowledge and experience.

I believe that Learning how to write code is not about college degree but determination and every one can code.

Just have the desire to learn new things and take my courses. It changed my life and it will change your life also. I look forward in sharing my knowledge and experience with you. Thank You

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.