Explore tweets tagged as #100DaysOfSQL
Day 92 of #100daysofsql.NTILE & PERCENT RANK in SQL.NTILE.The NTILE function divides the rows into a result set into a specified number of groups and assigns each row a unique rank based on its group belongs.
1
1
2
#Day29 of #100daysofSQL To use a subquery in an INSERT statement, it must be included in the values clause.
0
1
1
#Day30 of #100daysofSQL A subquery is used in a DELETE statement with a logical operator to remove data from a table.
0
1
1
Day 88 of #100daysofsql. SELECT *. FROM memories. WHERE date = '2024-12-28' AND event_type = 'cultural'. 😅 😅. #sql
0
1
2
#Day16 of #100daysofSQL I explored LEFT JOIN. Which is a type of join that returns all matched and unmatched rows from the left table. It can also be written as Left Outer Join.
0
1
0
#Day27 of #100daysofSQL I explored the EXISTS` and `NOT EXISTS` functions, which are used to check the existence or non-existence of rows in queries. In subqueries, they filter and retrieve data based on the presence of related records in the other tables.
0
1
0
Day 20 - Went back to calculations today (both in SQL and Sheets). Got a deeper into pivot table use cases too. Also learnt types of data validation checks which include data type, data range and more. #SQL #datafam #DataAnalytics #100daysofsql
1
4
15
Practicing SQL transformations with the AdventureWorks2022 database!.I used CASE statements to:.• Classify product prices.• Categorize stock levels.• Flag weekend orders.• Recommend discount tiers.Solid way to level up my SQL skills!.#100DaysOfSQL #DataAnalytics #SQLServer
2
4
49
#100daysofcode.#100daysofsql.#sql.#oracle. I had to put this journey to a hold due to projects and school activities. It's time to finish what I started!
techiessss assembleeeeee. What are you learning / building? .Tell me what you did today or what you’re planning to do. RT to mark attendance….
0
1
0
0
0
0
Practiced SQL joins using the AdventureWorks2022 dataset:.INNER JOIN.LEFT JOIN.RIGHT JOIN.FULL JOIN.Each query helped me understand how to combine and extract data from multiple related tables. Progress, one join at a time!. #100DaysOfSQL #DataAnalytics #AdventureWorks #datafam
0
1
5
#Day31 of #100daysofSQL The CONCAT () function adds two strings together. The list of string values that need to be merged together is entered into the CONCAT () function as parameters.
0
1
0
#Day25 of #100daysofSQL Another window function LAG retrieves data from the previous row in the dataset while LEAD works the same way as LAG, but it gets the value from the next row instead of the previous row.
0
1
0
#Day28 of #100daysofSQL An UPDATE statement allows the modification of existing data in a table. The subquery used in an UPDATE statement is included in the WHERE clause. Subqueries are not limited to the WHERE clause of an UPDATE statement, they can be used in the SET clause too
0
1
0
#100daysofSQL.I’m currently on day 7 btw 🌚. Alright, here’s a quick recap. I started with databases, exploring it with its data types and tables. Then I learnt how to query data, select data, filter records, use aggregate functions and sort & group data.
1
0
0
Usage of 2 Important SQL Functions .💥DISTINCT.💥LIMIT . #SQLTips #DataMastery #LearnSQL #TechSkills #CodeSmart #100DaysOfSQL #SQLforBeginners
0
0
0
#Day14 of my #100daysofSQL and I explored further the use of aggregate function with a CASE statement. #dataanalysis #postgresql
0
1
0
If you sign up for this SQL newsletter today, 22nd Dec will be the last day. You will close the year with better SQL skills and you won’t be starting from scratch come 2025! . Onboarding is on Friday. #100DaysOfSQL
1
7
11
Today we kicked off #100DaysOfSQL with onboarding and the setting up the free version of bigquery. Recorded a mini tutorial as well. You can still sign up for the newsletter.
0
3
10
Day 79 of #100daysofsql.Filtering, Grouping and Aggregating data by time periods in sql.When working with time-based data in SQL, you can filter, group, and aggregate information using SQL.
1
1
0