Software Development Basics
Fundamental principles and concepts
Combining and Filtering Data with MariaDB
In this course, you'll explore and learn how you can combine and filter multiple areas of the relational database to build an efficient result for end users.
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo
Why choose Core Tech?
verifiedGet this course for free with the Coursera Plus subscription.
✓ Compare courses before making a decision
Check Latest Price →Price may vary. Check latest price on provider site.
Course Insight
Suitable for beginner learners. This course serves as an entry point into Software Development, building foundational knowledge before moving on to advanced frameworks or specialized paths.
Beginner FriendlySelf-Paced Learning
SKILLS TO
MASTER
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers:Relevant for professionals pursuing roles within Software Development.
Quick Facts
Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.
What You’ll Learn
- Course Overview : 1min.
- Aggregating Results with GROUP BY : 19mins.
- Manipulating String and Numeric Column Fields : 24mins.
- Using Common Table Expressions for Efficiency : 23mins.
- Combining Data from Two or More Tables Using Joins : 30mins.
- Limiting Results with Windowing Functions : 33mins.
- Combining Results Set of Multiple SELECT with UNION : 20mins.
- Summary : 4mins.
See side-by-side differences in what you’ll learn
Description
MariaDB is one of the most sophisticated relational databases in the RDBMS world. It is critical that, in the relational database, multiple columns, fields, and tables work together to provide meaningful results for end users.
In this course, Combining and Filtering Data with MariaDB, you’ll gain the ability to work with complex business logic using various SQL and relational database features of MariaDB.
First, you’ll learn how to aggregate results with Group By.
Next, you’ll learn how to manipulate string and numeric column fields, as well as about Common Table Expressions, Union queries, and Join to combine various results into a single resultset.
Finally, you’ll explore how to work with windowing functions to return meaningful results from your database.
When you’re finished with this course, you’ll have the skills and knowledge of various SQL features of MariaDB to solve complex business problems.
See how this course compares with alternatives
FAQs
Top Alternatives
Highly-rated courses worth your attention
⭐ 5(12+ learners)