Learning MySQL5 – An Easy Way To Master MySQL
Learning MySQL5 – An Easy Way To Master MySQL, available at $19.99, has an average rating of 4, with 90 lectures, based on 164 reviews, and has 7752 subscribers.
You will learn about This course is ideal for individuals who are It is particularly useful for .
Enroll now: Learning MySQL5 – An Easy Way To Master MySQL
Summary
Title: Learning MySQL5 – An Easy Way To Master MySQL
Price: $19.99
Average Rating: 4
Number of Lectures: 90
Number of Published Lectures: 89
Number of Curriculum Items: 90
Number of Published Curriculum Objects: 89
Original Price: $39.99
Quality Status: approved
Status: Live
What You Will Learn
Who Should Attend
Target Audiences
A Verifiable Certificate of Completion is presented to all students who undertake this course.
MySQL is the world's most popular relational database solution used in businesses and independent projects, with thousands of new developers and users coming on board every day. Because it continues to evolve and integrate into the biggest technologies on the web, there has never been a better time to learn, and this hands-on MySQL 5 tutorial course makes it easy. With a step-by-step approach tailored for beginners, course author Jason Gilmore introduces the fundamental concepts underlying relational databases and helps you learn how to build your own functional database and manage it using standard techniques and tools. You'll get 91 lessons taking you from MySQL installation and configuration through learning and using different data types, retrieving and filtering data, working with functions, performing backup and security tasks and more. No prior experience is needed. Matching work files are included so that you can follow the course point by point through the development process.
What You Will Learn
– The basic building blocks of relational databases and how they apply, including strings, numerical data types, primary and foreign keys, functions and queries.
– How to install and set up a usable MySQL server on Windows.
– How to access, modify and manage your data within a MySQL database.
– How to use relational databases to solve problems in business and software or web development.
Who Should Take This Course
– Anyone who wants to learn to create functional, flexible databases for archival, organization or software development purposes.
– Users moving from software-centered solutions such as Microsoft Access or FileMaker looking for a greater degree of control.
– Anyone who wants to increase their employment or promotion prospects by learning a current, relevant technology standard.
What People Are Saying
"I thought MySQL was over my head…the books I'd bought didn't help but these videos have already made a huge difference in what I can do."
– Darrel Nixa
"Jason is awesome as a teacher, and I can't say enough how helpful having the files were in following along."
– Rachel Black
"The section on optimization is where it really came together for me…there's some serious power here if you've got a lot of data to work with."
– Tom Leippi
Course Curriculum
Chapter 1: Introducing The Relational Database
Lecture 1: Working Files – Download These First
Lecture 2: 0101 What Is A Relational Database
Lecture 3: 0102 The Database Hierarchy
Lecture 4: 0103 Table Relations
Lecture 5: 0104 The Structured Query Language
Lecture 6: 0106 Conclusion
Chapter 2: Installing And Configuring MySQL
Lecture 1: 0201 Introduction To MySQL
Lecture 2: 0202 MySQL Features
Lecture 3: 0203 Installing MySQL – Introduction
Lecture 4: 0204 Downloading MySQL
Lecture 5: 0205 Installing MySQL – Part 1
Lecture 6: 0206 Installing MySQL – Part 2
Lecture 7: 0207 Configuring MySQL
Lecture 8: 0209 Setting The System Path – Part 2
Lecture 9: 0210 Installing MySQL On The Mac
Lecture 10: 0211 The Sakila Database
Lecture 11: 0212 Installing The Sakila Database
Chapter 3: Connecting To MySQL And Creating Your First Database
Lecture 1: 0301 Introduction To MySQL Connections
Lecture 2: 0302 Role Of The Root User
Lecture 3: 0303 Logging In For The First Time
Lecture 4: 0304 Change The Root Password
Lecture 5: 0305 Creating Your First Database
Lecture 6: 0306 Creating Your First User Account
Lecture 7: 0307 Creating Your First Table
Chapter 4: Introducing MySQL's Data Types
Lecture 1: 0401 Intro To Data Types
Lecture 2: 0402 String Data Types – Part 1
Lecture 3: 0403 String Data Types – Part 2
Lecture 4: 0404 Data Attributes
Lecture 5: 0405 Customers Table Revised
Lecture 6: 0406 Numerical Data Types – Part 1
Lecture 7: 0407 Numerical Data Types – Part 2
Lecture 8: 0408 Numerical Data Attributes
Lecture 9: 0409 Date And Time Types
Lecture 10: 0410 Multiple Timestamp Columns In Table
Chapter 5: Primary And Foreign Keys
Lecture 1: 0501 Primary Keys – Part 1
Lecture 2: 0502 Primary Keys – Part 2
Lecture 3: 0503 Creating A Primary Key
Lecture 4: 0504 Foreign Key Introduction
Lecture 5: 0505 Create Foreign Key
Chapter 6: Introducing phpMyAdmin, MySQL Workbench, SQLyog
Lecture 1: 0601 Graphical MySQL
Lecture 2: 0602 phpMyAdmin Intro
Lecture 3: 0603 MySQL Workbench Intro
Lecture 4: 0604 MySQL Workbench SQL Development Intro
Lecture 5: 0605 MySQL Workbench Data Modeling Intro
Lecture 6: 0606 MySQL Workbench Server Administration Intro
Lecture 7: 0607 SQLyog Introduction
Lecture 8: 0608 SQLyog Creating A Database
Lecture 9: 0609 SQLyog Navigating And Modifying Data
Lecture 10: 0610 SQLyog Scheduling Backups
Chapter 7: Creating, Retrieving, Updating And Deleting Data
Lecture 1: 0701 Performing CRUD Operations
Lecture 2: 0702 Creating Data
Lecture 3: 0703 Retrieving Data
Lecture 4: 0704 Ordering Results
Lecture 5: 0705 Filtering Results
Lecture 6: 0706 Grouping Results
Lecture 7: 0707 Removing Duplicate Rows
Lecture 8: 0708 The LIKE Clause
Lecture 9: 0709 The LIMIT Clause
Lecture 10: 0710 Updating Data
Lecture 11: 0711 Deleting Data
Chapter 8: Using String, Numeric, Temporal And Stored Functions
Lecture 1: 0801 Introduction To Functions
Lecture 2: 0802 String Functions
Lecture 3: 0803 Numeric Functions
Lecture 4: 0804 Temporal Functions – Introduction
Lecture 5: 0805 Temporal Functions – Example
Lecture 6: 0806 Stored Functions – Part 1
Lecture 7: 0807 Stored Functions – Part 2
Lecture 8: 0808 Stored Functions – Part 3
Chapter 9: Introducing Subqueries
Lecture 1: 0901 Subqueries Intro
Lecture 2: 0902 Subqueries
Chapter 10: Introducing SQL Joins
Lecture 1: 1001 SQL Joins
Lecture 2: 1002 The Inner Join
Lecture 3: 1003 The Left Join
Chapter 11: Optimizing MySQL
Lecture 1: 1101 Optimizing MySQL
Lecture 2: 1102 Column Indexing
Lecture 3: 1103 Column Indexing Explained
Lecture 4: 1104 Optimizing The MySQL Configuration
Lecture 5: 1105 Query Caching
Lecture 6: 1106 Query Caching Explained
Lecture 7: 1107 Optimizing MySQL Conclusions
Chapter 12: Importing, Exporting And Backing Up MySQL Databases
Lecture 1: 1201 Introduction To MySQL Data Tasks
Lecture 2: 1202 Exporting Data With MySQL Workbench
Lecture 3: 1203 Importing Data With Phpmyadmin
Lecture 4: 1204 Automatically Backing Up Your MySQL Database
Lecture 5: 1205 Automating Your Backups With mysqldump And cron
Chapter 13: Managing MySQL User Privileges
Lecture 1: 1301 Managing MySQL Privileges
Lecture 2: 1302 MySQL Privilege Management Walkthrough
Instructors
-
Infinite Skills
High Quality Training
Rating Distribution
- 1 stars: 6 votes
- 2 stars: 2 votes
- 3 stars: 28 votes
- 4 stars: 55 votes
- 5 stars: 73 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024