₦100,000.00
Olawale Olalekan
GOOGLE CERTIFIED PROFESSIONALFullstack Developer
Introduction To MySQL
MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups. MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation).In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB.
Course Features
Introduction To MySQL ₦100,000.00
- Lectures Week Days/Weekends
- Quizzes 1
- Class Duration 4 Weeks
- Skill level Beginner/Inter/Expert
- Language English
- Students Capacity 20
- Lesson Materials Yes
- Lesson 5
- Assessments Yes
Course Description
MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook, Flickr, MediaWiki, Twitter, and YouTube.
Requirements
Wamp (Windows, Apache, MySQL, PHP/Perl/Python) Server, a solution stack for the Microsoft Windows operating system, created by Romain Bourdon and consisting of the Apache web server, OpenSSL for SSL support, MySQL database and PHP programming language.
LAMP (Linux, Apache, MySQL, PHP/Perl/Python) server is a very common example of a web service stack, named as an acronym of the names of its original four open-source components: the Linux operating system, the Apache HTTP Server, the MySQL relational d
XAMPP server is Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It is an easy, lightweight Apache distribution that creates it extremely easy for developers to make an area web server for testing and deployment purposes.
Learning Outcomes/Target Audience
- This course is intended for anyone interested in learning MySQL in Web Development to master his or her own body. This course is aimed at beginners, so no previous experience with hand balancing skills is necessary.
Curriculum
-
First Lesson
-
Lesson 1.Getting Started with MySQL.180 minutes
-
-
Second Lesson
-
Lesson 1. CSS Introduction.180 minutes
-
-
Third Lesson
-
Lesson 1. Creating Database and Tables.180 minutes
-
-
Fourth Lesson
-
Lesson 1. Database Design with MySQL.180 minutes
-
-
Fifth Lesson
-
Lesson 1. The Structured Query Language for Creating and Altering Tables.180 minutes
-
-
Final
-
Part 1. Assignment/Assessment120 minutes
-
Part 2. Online Test120 minutes
-
Tutor/Instructor
Olawale Olalekan
GOOGLE CERTIFIED PROFESSIONALI'm Leol, a Computer Science and Engineering graduate of Ladoke Akintola University of Technology, Ogbomoso, Nigeria. My web development skills are the fastest growing part of my technical skill sets. I'm an a Fullstack with both front-end and back-end development skills. My work has been primarily focused on: Web Application Development with a combination of: PHP + MySQL, HTML / HTML 5 + CSS 3, ASP.Net + Microsoft SQL, JavaScript + JQuery. Website deployment using open-source content management systems such as WordPress, Joomla, etc. Leol has experience in Languages like PHP, JavaScript, MATLAB, C, C++, C#, PASCAL, HTML, CSS. I'm well grounded, well versed and well seasoned in Web Development, Mobile Apps, Content Management System, Search Engine Optimization, Digital Marketing, Project Management, Graphic Design, Web Hosting, Windows Hosting with Plesk, Linux Hosting with cPanel, Office Workspace Email, Official email & Outlook Config. I've built different Web Solutions ranging from E-commerce Platform, Courier and Tracking Platform, Hospital Management Platform, Real Estate and Property Platform, School Management Platform, Co-operative & Thrift Platform, HR Platform, Bulkmailer, BulkSMS and CBT Solution for corporate organizations, schools, NGOs and religious bodies and others. I've also worked on: Payment gateway intergration, Bulk E-mail integration, SMS integration, custom APIs, complex forms, custom e-mail digests. Leol is a Google certified Professional.
Leol Legend is a legendary Software Developer. He is a born teacher that I have known since university days, more than a decade. I am impressed with the 9ja Coding Class, looking forward to learning more from you the next class.
The explanation was very thorough and the tutor was always on hand to give extra guidance whenever it was needed. Legendary in digital transformation...
This is a good learning resource for those who want to learn web design without writing any code. It is clear and easy to understand.