Fumy Skillz

Fumy Skillz Sharing is good and with digital technology, sharing is easy. So learn and earn.

In SQL, the order of written code differs from the order of ex*****on. So in order to understand how the SQL query works...
15/11/2024

In SQL, the order of written code differs from the order of ex*****on. So in order to understand how the SQL query works you’ll need to understand proper SQL query structure and the order in which SQL queries must be written using following keywords.

In general, SQL queries are executed in the following order:

1. FROM: The first step is to identify the tables or views involved in the query. This is specified in the FROM clause of the query.

2. JOIN: If the query involves multiple tables and requires a join operation, the join conditions are evaluated to combine the data from different tables.

3. WHERE: The WHERE clause is applied to filter the rows based on specified conditions. Rows that do not meet the conditions are eliminated from further processing.

4. GROUP BY: If the query includes a GROUP BY clause, the rows are grouped based on the specified columns.

5. HAVING: If a HAVING clause is present, it is applied to filter the groups generated by the GROUP BY clause. Groups that do not meet the conditions are eliminated.

6. SELECT: The SELECT clause is applied to determine the columns to be included in the result set. Any calculations or functions specified in the SELECT clause are also evaluated at this stage.

7. DISTINCT: If the query includes the DISTINCT keyword, duplicate rows are removed from the result set.

8. ORDER BY: If an ORDER BY clause is present, the result set is sorted based on the specified columns.

9. LIMIT/OFFSET: If the query includes a LIMIT and/or OFFSET clause, the result set is limited to a specific number of rows and/or skipped by a certain number of rows.

Note: It’s important to note that not all queries will include every step mentioned above. The order of ex*****on may vary depending on the specific query and the presence of different clauses.

Understanding SQL JOINs is one of the most powerful skills a data professional can have.(Even if you’re not a data exper...
12/11/2024

Understanding SQL JOINs is one of the most powerful skills a data professional can have.
(Even if you’re not a data expert, knowing this can be a game-changer!)
Let’s break it down

1️⃣ INNER JOIN: Finds records that match in both tables.
Think of it as finding common ground—where A and B overlap.

2️⃣ FULL JOIN: Grabs everything from both tables.
Even if data only exists in one table, it’s all included!

3️⃣ LEFT JOIN: Starts with all records from the left (A), and only pulls from B where there’s a match.
Perfect for when you want all of A’s data, but only some of B’s.

4️⃣ RIGHT JOIN: The reverse of LEFT JOIN.
Starts with all records from the right (B) and includes data from A if there’s a match.

5️⃣ OUTER JOIN: (often a mystery for some!)
Returns all records where there isn’t a match between A and B—highlighting what’s unique.

This diagram breaks down the different types of joins visually. 📊
Why this matters:
Each JOIN serves a purpose depending on what insights you need.
Mastering them means you can get the precise data you’re looking for—every time.
What’s your go-to JOIN for data analysis?
P.S. Share this with someone just getting into SQL.

Which data analytics skills do you think are most essential in today’s market?Data analytics is more than just crunching...
03/11/2024

Which data analytics skills do you think are most essential in today’s market?

Data analytics is more than just crunching numbers. From technical skills like SQL and spreadsheet mastery to statistical programming with Python or R, the path to becoming a data expert is diverse.

Skills in data visualization (Tableau, PowerBI) and database management (MySQL, PostgreSQL) ensure that insights are not only accurate but also impactful. And let’s not overlook machine learning techniques—linear regression, decision trees, and clustering algorithms are becoming indispensable.

But here’s the kicker: soft skills like communication, collaboration, and critical thinking are just as crucial. The ability to interpret data and share insights effectively can make or break data-driven decisions.

Which one of these skills has made the biggest impact in your analytics journey?

hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag

There’s no escaping the various SQL commands you’ll encounter as you immerse yourself in the captivating world of databa...
31/10/2024

There’s no escaping the various SQL commands you’ll encounter as you immerse yourself in the captivating world of database management. Luckily, am here to help navigate the types of SQL commands.

1. Data Definition Language: Define data tables using DDL commands such as CREATE and ALTER.

2. Data Manipulation Language: Manipulate database data by adding, updating and deleting information. SELECT, INSERT, UPDATE and DELETE are DML commands.

3. Data Control Language: Give access privileges and remove users’ permissions. GRANT and REVOKE fall into DCL commands.

4. Transaction Control Language: Commands like COMMIT, ROLLBACK and SAVEPOINT deal with database transactions.

The Role of Relational Database
29/10/2024

The Role of Relational Database

What is SQL?
28/10/2024

What is SQL?

In a world brimming with endless information at our fingertips, it’s easy to feel overwhelmed. Fortunately, that’s where...
28/10/2024

In a world brimming with endless information at our fingertips, it’s easy to feel overwhelmed. Fortunately, that’s where databases come in, serving as your infrastructure’s backbone. At the heart of it, information is neatly gathered and accessed through a powerful yet underrated language — SQL.

Are you ready to make data-driven decisions and keep a firm grasp on critical information by becoming fluent in SQL? Let's dive into the world of SQL daily as we role out some lectures on it and look at how it empowers data professionals in today’s fast-paced work environment.

Did you know? The gas you use for cooking in your kitchen is naturally odorless. Yes! Pure gas do not smell. Why does yo...
17/10/2024

Did you know?

The gas you use for cooking in your kitchen is naturally odorless. Yes! Pure gas do not smell.

Why does your home gas smells? — The odour you perceive when you switch on your nob is not gas but a smell that is actually added to the gas for safety measure so that you will know if there is a leak.

Hello Data Fams!I am Excited to share my latest Power BI project! The project entails a comprehensive documentation of ...
21/08/2024

Hello Data Fams!

I am Excited to share my latest Power BI project! The project entails a comprehensive documentation of sales analysis. 🎉 I've delved into Inner Peace Computer Sales Data, uncovering insights on: 📍 Sales by location 🏬 Impact of outlet size 🛒 Item performance 🏢 Outlet establishment trends.

In this project, I've recognized the pivotal role of Power BI as a very vital data visualization tool. It effortlessly transforms data into clear visuals and was easy to navigate, offering diverse ways to present data such as charts and graphs, it adeptly manages various data sources. Basically, it's a must-have for anyone wanting to make sense of their data easily.
The tool I used is Excel 2021, Power Query add-in and Microsoft Power BI

hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag

The Mind of a Data Analyst: A Perfect Blend of Hard and Soft Skills In the world of data analytics, success isn’t just a...
20/08/2024

The Mind of a Data Analyst: A Perfect Blend of Hard and Soft Skills

In the world of data analytics, success isn’t just about mastering technical tools—it’s about balancing those with critical people skills. The image beautifully captures this duality:

Hard Skills (Left Brain):

• Tableau & Power BI: For data visualization that tells a compelling story.
• SQL & Python: The backbone of data manipulation and querying.
• Statistics: The foundation of data interpretation.
• Excel: The go-to tool for data analysis and modeling.

People Skills (Right Brain):

• Critical Thinking: The ability to analyze data and make informed decisions.
• Communication: Translating complex data into clear, actionable insights.
• Curiosity: The drive to dig deeper and ask the right questions.
• Problem-solving: Turning data challenges into solutions.
• Storytelling: Crafting narratives that resonate and drive action.

A data analyst must be as comfortable in a spreadsheet as they are in a meeting room. It’s this blend of analytical rigor and human insight that turns raw data into strategic advantage.

hashtag hashtag
hashtag hashtag
hashtag hashtag

Hello Aspiring DataFamLet's begin our journey with the meaning of MySQL
22/04/2024

Hello Aspiring DataFam
Let's begin our journey with the meaning of MySQL

21/04/2024

SQL is one of the most important tools for data analyst. It is known as Structured Query Language (SQL).

SQL is a programming language used to communicate with database. SQL can be used to access, update and manipulate data stored in a relational database management system.

Having knowledge about Microsoft Excel isn’t enough to be able to call yourself a data analyst.

I will be covering some topics and keywords about MySQL which includes;

1. What is SQL?
2. What is a Database?
3. The types of SQL languages/commands.
4. Keywords used in MySQL.
5. Main components of SQL’s syntax and its uses
6. Coding styles, data types, and many more.

As an aspiring data analyst, you shouldn't miss these lectures for anything.
Follow me on this journey as we dive through the relational database and start a better foundation with MySQL.

26/01/2024

*Roadmap to become a data analyst*

1. Foundation Skills:
•Strengthen Mathematics: Focus on statistics relevant to data analysis.
•Excel Basics: Master fundamental Excel functions and formulas.

2. SQL Proficiency:
•Learn SQL Basics: Understand SELECT statements, JOINs, and filtering.
•Practice Database Queries: Work with databases to retrieve and manipulate data.

3. Excel Advanced Techniques:
•Data Cleaning in Excel: Learn to handle missing data and outliers.
•PivotTables and PivotCharts: Master these powerful tools for data summarization.

4. Data Visualization with Excel:
•Create Visualizations: Learn to build charts and graphs in Excel.
•Dashboard Creation: Understand how to design effective dashboards.

5. Power BI Introduction:
•Install and Explore Power BI: Familiarize yourself with the interface.
•Import Data: Learn to import and transform data using Power BI.

6. Power BI Data Modeling:
•Relationships: Understand and establish relationships between tables.
•DAX (Data Analysis Expressions): Learn the basics of DAX for calculations.

7. Advanced Power BI Features:
•Advanced Visualizations: Explore complex visualizations in Power BI.
•Custom Measures and Columns: Utilize DAX for customized data calculations.

8. Integration of Excel, SQL, and Power BI:
•Importing Data from SQL to Power BI: Practice connecting and importing data.
•Excel and Power BI Integration: Learn how to use Excel data in Power BI.

9. Business Intelligence Best Practices:
•Data Storytelling: Develop skills in presenting insights effectively.
•Performance Optimization: Optimize reports and dashboards for efficiency.

10. Build a Portfolio:
•Showcase Excel Projects: Highlight your data analysis skills using Excel.
•Power BI Projects: Feature Power BI dashboards and reports in your portfolio.

11. Continuous Learning and Certification:
•Stay Updated: Keep track of new features in Excel, SQL, and Power BI.
•Consider Certifications: Obtain relevant certifications to validate your skills.

Cop

Learn more skills.
08/01/2024

Learn more skills.

Address

Lagos Mainland
Lagos

Telephone

+2348083904678

Website

Alerts

Be the first to know and let us send you an email when Fumy Skillz posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category