Mysql Mariadb From Scratch - Become An App Developer In 2022
Last updated 8/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 663.99 MB | Duration: 1h 54m
The Ultimate MySQL MariaDB Beginner Course with EXAMPLES and PROJECT that will take you towards becoming an SQL Master
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 and so on
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 CourseHave 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 COURSEExcellent 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 PHPHow 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 MariaDBDifferent storage engines in MySQL.How to query multiple table with JOINS.How to combine multiple query with UNION. etcLIFE TIME ACCESS: By enrolling in this course you have an instant Life- Time access30 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
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 What is Database & Spreadsheet
Lecture 3 MySQL vs MariaDB
Lecture 4 Datatypes
Lecture 5 Requirement
Lecture 6 Setting Up our environment 1
Lecture 7 Setting Up our environment 2
Section 2: Databases And Tables
Lecture 8 Important Note
Lecture 9 Getting started
Lecture 10 Creating database
Lecture 11 Drop database
Lecture 12 Using a database
Lecture 13 Create Table (basic syntax)
Lecture 14 Execute & describe Table
Lecture 15 Create Table (datatypes)
Lecture 16 Create Table (constraints)
Lecture 17 Other method of create table
Lecture 18 Alter Table (add column)
Lecture 19 Alter Table (modify & drop)
Lecture 20 Rename & Drop Table
Section 3: Handling Data (insert, update & delete)
Lecture 21 Insert (Basic syntax)
Lecture 22 Insert 2
Lecture 23 Insert From Table
Lecture 24 Insert with auto_increment
Lecture 25 Update row
Lecture 26 Delete row
Section 4: Retrieving Data (In-dept)
Lecture 27 First thing first
Lecture 28 Select statement
Lecture 29 Ordering, Alias & Limits
Lecture 30 Filtering result with WHERE
Lecture 31 Filtering result with LIKE and IN
Lecture 32 Filtering result with NOT and OR
Lecture 33 Using Regular Expression
Section 5: Functions in MySQL and MariaDB
Lecture 34 String Functions
Lecture 35 Numeric Functions
Lecture 36 Aggregate Functions
Lecture 37 Date and Time Functions
Section 6: Transaction
Lecture 38 Transactions
Section 7: Combining Queries & Tables
Lecture 39 Intro
Lecture 40 Joins
Lecture 41 Unions
Section 8: Subquery
Lecture 42 subquery 1
Lecture 43 subquery 2
Section 9: Storage Engines
Lecture 44 storage engine
Lecture 45 storage engine 2
Section 10: Project (CRUD Application)
Lecture 46 Project Intro
Lecture 47 Overview of PHP
Lecture 48 Setting things up
Lecture 49 Creating database, user and table
Lecture 50 Connecting to database
Lecture 51 Inserting data into database
Lecture 52 Displaying database records
Lecture 53 Updating record into database
Lecture 54 Deleting record in the database
Section 11: Next Step
Lecture 55 Next Step
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.
Homepage
https://www.udemy.com/course/learn-mysql-mariadb-from-scratch-and-build-a-database-app/
Links are Interchangeable - No Password - Single Extraction
