Learn MySQL and Solve 42 Practical Problems
Learn MySQL and Solve 42 Practical Problems, available at $54.99, has an average rating of 4.35, with 42 lectures, based on 106 reviews, and has 680 subscribers.
You will learn about Understand basic statements of MySQL Write MySQL statements to interact with database know how to use MySQL database tool to connect to database know how to join tables to address business problems This course is ideal for individuals who are Anyone who want's to learn or enhance their SQL skills It is particularly useful for Anyone who want's to learn or enhance their SQL skills.
Enroll now: Learn MySQL and Solve 42 Practical Problems
Summary
Title: Learn MySQL and Solve 42 Practical Problems
Price: $54.99
Average Rating: 4.35
Number of Lectures: 42
Number of Published Lectures: 42
Number of Curriculum Items: 42
Number of Published Curriculum Objects: 42
Original Price: $129.99
Quality Status: approved
Status: Live
What You Will Learn
- Understand basic statements of MySQL
- Write MySQL statements to interact with database
- know how to use MySQL database tool to connect to database
- know how to join tables to address business problems
Who Should Attend
- Anyone who want's to learn or enhance their SQL skills
Target Audiences
- Anyone who want's to learn or enhance their SQL skills
WELCOME TO MY COURSE – “Learn MySQL and Solve 42 Practical Problems”
Why this course?
There are a lot of tutorials out there talking about basics of SQL language and statements, which is good. However, a lot of times, just learning the syntax won’t bring you any further. That’s what I feel when I was learning SQL. I would like to find Quizs and Problems to practice on the knowledge I learned. Yet, often times, it’s difficult to find good problems to work on.
This course will first introduces the basics of SQL statements through MySQL, one of the most popular databases out there. If you are beginner, I definitely recommend you to go through this section. If you are seasoned developer, you are welcome to have a review. I encourage you to practice while learning those basic statements.
After that, you can jump into the more interesting section – solving problems. There are 42 problems divided into 3 categories, basic, intermediate and advanced. It will start with the very basics of SQL statements to make sure you understand what building tools and then moving to more advanced problems.
Almost every time, in an interview for a developer related position, there will be SQL questions. During those SQL questions, you will often face problems involving joining tables, a tough topic for a lot of people who has just begun with SQL. There aren’t many good practice out there and that’s why I would like to share in this course.
How to use this course?
In order to retain the knowledge you have learned, you will have to solve those problems yourself. You may follow the lessons to go through each of the problem, but you have to come back and solve the problems yourself. Besides that, to fight memory loss on what you have learned, you need to constantly come back to those problems to convert short term memory into long term memory, especially before interview. Not every key words or statement is covered in this course. You can always find quick tutorials and documents on it. The more valuable information is the practical problems and the process of solving it. I can provide you the former part but it’s you who act as the second part.
Course Curriculum
Chapter 1: Introduction Section
Lecture 1: Download this source files first !!!!
Lecture 2: Overview
Lecture 3: Introduction
Lecture 4: MySQL Server Installation
Lecture 5: How To Maintain Memory
Chapter 2: MySQL Basics – Query Data
Lecture 1: Sample Database
Lecture 2: Select Statement to query data
Lecture 3: Distinct to eliminate duplicate records
Chapter 3: MySQL Basics – Filter Data
Lecture 1: Filter data records with where clause
Lecture 2: 2. Logic And and OR
Lecture 3: Greater Than, Less Than and Between operator
Lecture 4: IN and NOT operator
Lecture 5: LIKE operator to select records based on patterns
Lecture 6: LIMIT operator to limit the number of records displayed
Chapter 4: MySQL Basics – Sort Data and Join Table
Lecture 1: ORDER BY clause to sort data
Lecture 2: Using Alias to make queries more readable
Lecture 3: MySQL INNER JOIN to join two or multiple tables
Lecture 4: MySQL LEFT JOIN to include left set when joining tables
Lecture 5: MySQL self joining tables
Chapter 5: MySQL Basics – GROUP BY, Subquery and UNION
Lecture 1: GROUP BY to put same value records into groups
Lecture 2: HAVING clause to filter data after grouping
Lecture 3: Subquery in MySQL
Lecture 4: Combining result sets by UNION
Chapter 6: Manage Tables and Databases
Lecture 1: Create Table
Lecture 2: Insert records into tables
Lecture 3: Storage Engines
Lecture 4: Update record values
Lecture 5: Delete records
Lecture 6: Manage database
Lecture 7: Drop statement
Chapter 7: Basic Problems
Lecture 1: Sample Database for problems
Lecture 2: Problems 1 – 6
Lecture 3: Problems 7 – 12
Lecture 4: Problems 13 – 19
Chapter 8: Intermediate Problems
Lecture 1: Problems 20 – 23
Lecture 2: Problems 24 – 27
Lecture 3: Problems 28 – 29
Lecture 4: Problems 30
Chapter 9: Advanced Problems
Lecture 1: Problems 31 – 32
Lecture 2: Problems 33 – 34
Lecture 3: Problems 36 – 38
Lecture 4: Problems 39 – 42
Instructors
-
Le Deng
ldeng.net/courses, consultant, thousands of students
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 4 votes
- 3 stars: 9 votes
- 4 stars: 31 votes
- 5 stars: 60 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
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple