Explore tweets tagged as #Joules100daysofSQL
Day 87 of #Joules100daysofSQL. Leaving filtering data, I revised the art of joins in SQL such as inner join, left join and right join.
Day 86 of #Joules100daysofSQL. I revised the use of aggregate functions such as AVG, SUM, ROUND, MIN, MAX. I also learned how to sort and group data using ORDER BY and GROUP BY as well as how to filter aggregated data using HAVING.
0
0
0
Day 90 of #Joules100daysofSQL. I practiced sub queries in SQL. Sub queries are used to perform a query within another query.
Day 88 & 89 of #Joules100daysofSQL. I missed yesterday due to flat battery on my PC and mobile phone. However, I was meant to have learned about FULL, CROSS and SELF joins. CROSS joins matches a row in the first table to every row in the other table.
0
0
3
Day 92 of #Joules100daysofSQL. I moved on to revising data manipulation system in SQL. I went over the case system which bears similarities to the IF statement in Python or Excel.
Day 91 of #Joules100daysofSQL. Hello, everyone. I'm still revising subqueries and I took a look at the various mode in which subqueries can appear in. It can be found in the WHERE, FROM and SELECT clause.
0
0
1
Day 97 of #Joules100daysofSQL. I explored more windows function such as NTILE. I also went over the use of aggregate functions in SQL and use of frames in windows function.
Day 96 of #Joules100daysofSQL. I went deeper into windows function. I revised the use of ROW_NUMBER, RANK, RANGE BETWEEN, LAG and many more. Lag is used to return the previous value. e.g last year's champion in a tournament.
0
1
5
Day 83 of #Joules100daysofSQL. Finalizing this course on data communication concepts, I learned about writing clear and concise reports. I also learned about tips when presenting the insights to the audience.
Day 82 of #Joules100daysofSQL. I'm still here, learning data communication concepts. I learned about reproducibility in data workflow. As the image shows, it's important to always explain the steps you took and use a script instead of manually imputing the data.
0
0
1
Day 82 of #Joules100daysofSQL. I'm still here, learning data communication concepts. I learned about reproducibility in data workflow. As the image shows, it's important to always explain the steps you took and use a script instead of manually imputing the data.
Day 81 of #Joules100daysofSQL. Hello, all. Still on data communication concepts, I learned about different types of reports. We have informational, analytical, final and summary reports.
0
0
1
Day 84 of #Joules100daysofSQL. I decided to review all my code files and ensure i jog my memory. In today's revision, I went over the use of COUNT, DISTINCT, WHERE, LIMIT and also the use of BETWEEN in the WHERE clause.
Good news, guyssss. 🥳. I've just completed the Data Analysis course for SQL on @DataCamp. It's now time to build more projects in SQL. Shoutout to I4G and @DataFestAfrica for the scholarship. 🙏
0
0
2
Day 91 of #Joules100daysofSQL. Hello, everyone. I'm still revising subqueries and I took a look at the various mode in which subqueries can appear in. It can be found in the WHERE, FROM and SELECT clause.
Day 90 of #Joules100daysofSQL. I practiced sub queries in SQL. Sub queries are used to perform a query within another query.
0
0
3
Day 98 of #Joules100daysofSQL. I learned once again how to create pivot tables in SQL using the CROSSTAB function. I also revised the use of ROLLUP and CUBE which is an extension of the GROUP BY clause and is used for calculating subtotals.
Day 97 of #Joules100daysofSQL. I explored more windows function such as NTILE. I also went over the use of aggregate functions in SQL and use of frames in windows function.
1
3
8
Day 86 of #Joules100daysofSQL. I revised the use of aggregate functions such as AVG, SUM, ROUND, MIN, MAX. I also learned how to sort and group data using ORDER BY and GROUP BY as well as how to filter aggregated data using HAVING.
Day 85 of #Joules100daysofSQL. Continuing from where I stopped yesterday. I explored various variants in filtering data using the WHERE clause. I learned how to filter text value using LIKE or NOT LIKE. I also learned how to filter NULL values.
0
0
2
Day 93 of #Joules100daysofSQL. Still on data manipulation in SQL, I revised the use of subqueries in manipulating the data. Subqueries can be utilized in the FROM, WHERE and SELECT subqueries. This enables various analysis to be done on the query.
Day 92 of #Joules100daysofSQL. I moved on to revising data manipulation system in SQL. I went over the case system which bears similarities to the IF statement in Python or Excel.
0
0
2
Day 85 of #Joules100daysofSQL. Continuing from where I stopped yesterday. I explored various variants in filtering data using the WHERE clause. I learned how to filter text value using LIKE or NOT LIKE. I also learned how to filter NULL values.
Day 84 of #Joules100daysofSQL. I decided to review all my code files and ensure i jog my memory. In today's revision, I went over the use of COUNT, DISTINCT, WHERE, LIMIT and also the use of BETWEEN in the WHERE clause.
0
0
2
Day 96 of #Joules100daysofSQL. I went deeper into windows function. I revised the use of ROW_NUMBER, RANK, RANGE BETWEEN, LAG and many more. Lag is used to return the previous value. e.g last year's champion in a tournament.
Day 95 of #Joules100daysofSQL. I revised windows function and also common table expressions. CTEs are used to create temporary result set that can be referenced in a query. Whereas, windows function performs a calculation across a set of rows related to the current row.
0
0
8
Day 99 of #Joules100daysofSQL. A drop left to complete the ocean. I revised the use of arrays in SQL which can be used in the WHERE clause to select a particular information in a column. I also revised how to obtain information from a database which is a vital skill.
Day 98 of #Joules100daysofSQL. I learned once again how to create pivot tables in SQL using the CROSSTAB function. I also revised the use of ROLLUP and CUBE which is an extension of the GROUP BY clause and is used for calculating subtotals.
1
0
9
Day 81 of #Joules100daysofSQL. Hello, all. Still on data communication concepts, I learned about different types of reports. We have informational, analytical, final and summary reports.
Day 80 of #Joules100daysofSQL. In today's lesson, I learned about the importance of proper communication. Choosing the right kind of report is crucial for delivering you insights. The reports can either be in an oral or a written format.
0
1
2
Day 88 & 89 of #Joules100daysofSQL. I missed yesterday due to flat battery on my PC and mobile phone. However, I was meant to have learned about FULL, CROSS and SELF joins. CROSS joins matches a row in the first table to every row in the other table.
Day 87 of #Joules100daysofSQL. Leaving filtering data, I revised the art of joins in SQL such as inner join, left join and right join.
1
0
5
Day 94 of #Joules100daysofSQL. I moved on to more complex subqueries. I revised the use of multiple subqueries to manipulate data. I also revised the use of correlated subqueries which depends on the outer query for it's values.
Day 93 of #Joules100daysofSQL. Still on data manipulation in SQL, I revised the use of subqueries in manipulating the data. Subqueries can be utilized in the FROM, WHERE and SELECT subqueries. This enables various analysis to be done on the query.
0
0
7
Day 95 of #Joules100daysofSQL. I revised windows function and also common table expressions. CTEs are used to create temporary result set that can be referenced in a query. Whereas, windows function performs a calculation across a set of rows related to the current row.
Day 94 of #Joules100daysofSQL. I moved on to more complex subqueries. I revised the use of multiple subqueries to manipulate data. I also revised the use of correlated subqueries which depends on the outer query for it's values.
0
0
5
Day 100 of #Joules100daysofSQL. The last drop has made an ocean. I revised the use of date functions such as date_trunc, extract, now to manipulate date values. The challenge might be over, but I'll still keep on learning. I'll also be taking my certification exams next month.
Day 99 of #Joules100daysofSQL. A drop left to complete the ocean. I revised the use of arrays in SQL which can be used in the WHERE clause to select a particular information in a column. I also revised how to obtain information from a database which is a vital skill.
6
6
17
Day 80 of #Joules100daysofSQL. In today's lesson, I learned about the importance of proper communication. Choosing the right kind of report is crucial for delivering you insights. The reports can either be in an oral or a written format.
Day 79 of #Joules100daysofSQL. I'm still on data communication concepts. I learned about choosing the right visualization depending on the audience, either a technical or non-technical audience.
3
1
6