#learningsql risultati di ricerca
Top 5 real-world use cases of the CASE statement in #SQLServer 🚀 Be in touch, @RakeshMen #SQLTips #LearningSQL #DataManipulation #Querying
🌟 Day 32 of SQL Learning Journey 🌟 Today, I tackled two exciting LeetCode problems, pushing deeper into SQL concepts: 1)Game Play Analysis IV 🎮 2)Unique Subjects by Each Teacher 📘 #SQL #LearningSQL #LeetCode #ProblemSolving #DailyLearning
Was bored and decided to work on a SQL task that's been on my laptop . #learningsql I created three tables for a library. One for books records, another for members records and the last for borrowing records, which contained foreign keys from books and members records.
Learned about data types, SQL commands, and how to write queries for databases and tables.#LearningSQL #DatabaseBasics
🚨 Struggling with SQL questions? Use this simple mental model before you write a single line: 🧩 T.A.S.K. T = Tables A = Attributes (columns) S = Steps to filter/join/group K = Key logic (what are you calculating?) 🎯 Think before you SELECT. #LearningSQL #InterviewPrep
Writing a simple SELECT * FROM table feels good, But optimizing queries? That’s where the real thrill! If SQL was a person, it would be friend who always knows exactly where to find the best food (with a quick JOIN). Still a beginner, but loving every query ! #SQL #LearningSQL
Some nights it’s just me, my messy dataset, and ChatGPT whispering “we’re almost there.” This data analytics journey is teaching me more than just skills — it’s teaching me patience and power. #LearningSQL #DataAnalytics
Day 3 of my 30-day SQL challenge! Today I delved into JOINS and learned how to combine data from multiple tables. Excited to see how this will simplify complex queries! 💻📊 #SQLChallenge #LearningSQL #DataScience #TechJourney
🧠 Just wrote my first SQL Server Stored Procedure with OUTPUT parameters and started understanding CTEs (Common Table Expressions)! 💻 Slowly turning SQL from scary to satisfying 😎 #SQLServer #100DaysOfCode #LearningSQL #StoredProcedure #MicrosoftSQL
"Diving deep into SQL — mastering the WHERE clause and 7 powerful operators like LIKE, NOT LIKE, BETWEEN, IN, and more. Querying like a pro! #SQL #LearningSQL #oracleSQL
I move again today ; Day 6 of #100DaysOfSQL Today I learned the difference between WHERE and HAVING in SQL: - WHERE filters rows before grouping - HAVING filters groups after GROUP BY` #SQL #LearningSQL
Database, varchar, int, text, etc. These, and more, are the words I've added to my vocabulary. I just ran my first SQL series and the feeling is powerful. It felt just like unlocking a new language. PS: Peep the new program🤭 #LearningSQL #DataAnalytics #TechCrushHQ #TechJourney
🚀 Embarking on my #SQL learning journey! 🖥️ I'll be diving into databases one day at a time, sharing tips, tricks, and insights along the way! 📚💡 Follow along as I level up my data skills and break down complex concepts! 💪🔥 #LearningSQL #TechJourney #DataAnalytics
SQL Advanced Techniques This techniques are essential to optimize the performance of SQL They include : Subquery, Common Table expressions(CTE), views etc That concludes day 9 of #learningSQL 😊 See you tomorrow
Day 9 of #learningSQL 😊 Topic 1. The window value functions 2. SQL advanced techniques WINDOWS VALUE FUNTIONS The Value function is used to access and return a values from other rows
Day 8 of #learningSQL 😊 Topic(s) covered 1. WINDOWS RANKING FUNCTION The Ranking functions are used to assign ranks or values to rows of data. The window ranking function must make use of the ORDER BY clause
Use cases of the window Ranking functions - Top N analysis and Bottom N analysis - Generate unique ID - Identify duplicates - data segmentation That concludes day 8 of #learningSQL 😊 See you tomorrow
Day 8 of #learningSQL 😊 Topic(s) covered 1. WINDOWS RANKING FUNCTION The Ranking functions are used to assign ranks or values to rows of data. The window ranking function must make use of the ORDER BY clause
Day 7 of #learningSQL 😊 Topic(s) covered 1. WINDOWS function 2. Calculating Running and Rolling Totals 1. WINDOWS FUNCTION Also referred to as analytical functions. WINDOWS Function performs calculations (e.g aggregation) on a specific subset of data and return a value(s)
Day 7 of #learningSQL 😊 Topic(s) covered 1. WINDOWS function 2. Calculating Running and Rolling Totals 1. WINDOWS FUNCTION Also referred to as analytical functions. WINDOWS Function performs calculations (e.g aggregation) on a specific subset of data and return a value(s)
Day 6 of #learningSQL 😊 Today's Topic 1. CASE statement Case statements evaluates a list of conditions an d returns a value when the first condition is met
Day 6 of #learningSQL 😊 Today's Topic 1. CASE statement Case statements evaluates a list of conditions an d returns a value when the first condition is met
DAY 5 OF #learningSQL 😊 Topics covered 1. Date and Time functions 2. NULL functions 3. Data policies
3. use the default value "unknown" and avoid using NULL,empty string and blank spaces That concludes day 5 of #learningSQL 😊 See you tomorrow
DAY 5 OF #learningSQL 😊 Topics covered 1. Date and Time functions 2. NULL functions 3. Data policies
DAY 4 of #learningSQL 😊 Topics covered 1. LIKE operator 2. SQL functions 3. string functions
ROUND Function: to round up numbers ABS: To convert all numbers to an absolute number That concludes day 4 of #learningSQL 😊 See you tomorrow
DAY 4 of #learningSQL 😊 Topics covered 1. LIKE operator 2. SQL functions 3. string functions
Day 3 of #learningSQL 😊 Topics covered 1. Joining data 2. JOINS 3. SET OPERATORS Joining data SQL uses two operators to combine either rows or columns of two or more tables- JOIN OR SET OPERATORS
Day 3 of #learningSQL 😊 Topics covered 1. Joining data 2. JOINS 3. SET OPERATORS Joining data SQL uses two operators to combine either rows or columns of two or more tables- JOIN OR SET OPERATORS
Day 2 of #learningSQL 😊 Topics covered - Deeper look into DDL and DML - SQL Query clauses - Order and execution order DDL(Data Definition Language) This defines the structure of the data. Uses commands like CREATE,ALTER,DROP.
CODING ORDER SELECT DISTINCT TOP >> FROM >> WHERE >> GROUPBY >> HAVING>> ORDER BY EXECUTION ORDER FROM>> WHERE>> GROUPBY>> HAVING >> SELECT DISTINCT>> ORDER BY>> TOP That concludes day 2 of #learningSQL 😊😊 See you tomorrow
Day 2 of #learningSQL 😊 Topics covered - Deeper look into DDL and DML - SQL Query clauses - Order and execution order DDL(Data Definition Language) This defines the structure of the data. Uses commands like CREATE,ALTER,DROP.
Day 1 of #learningsql First day was fun, Baraa ensured he explained the concepts in a simplistic manner. *Topics covered*:l - Introduction - database management and server - Types of SQL command and query clauses *SQL(Structured Query Language)* Also pronounced as "sequel"
Database structure: Server >Database(s)>Schemas>Tables That concludes day 1 #learningSQL See you tomorrow 😊
Day 1 of #learningsql First day was fun, Baraa ensured he explained the concepts in a simplistic manner. *Topics covered*:l - Introduction - database management and server - Types of SQL command and query clauses *SQL(Structured Query Language)* Also pronounced as "sequel"
Starting my SQL journey!!!! For the next few weeks I will be learning SQL in public. My primary learning material be will "SQL full course for beginners- from zero to hero(30 hours)" by Data with Baraa. I'm excited about this one 😊 Let's see how it goes!!! #learningSQL
Just updated my MySQL playlist on YouTube. This new episode covers ORDER BY, sorting, LIMIT, and using DISTINCT to clean results. Simple concepts, but essential for real data analysis. Watch the update on my channel The Data Boy: youtu.be/QjIn_gf6vgg?si… #SQL #MySQL #learningsql
youtube.com
YouTube
Sorting and Limiting Data (ORDER BY + LIMIT) | MySQL for Beginners
Top 5 real-world use cases of the CASE statement in #SQLServer 🚀 Be in touch, @RakeshMen #SQLTips #LearningSQL #DataManipulation #Querying
✅ First-time buyers & inactive users This query helps businesses target customers for upselling! 🚀 What’s your favorite advanced SQL trick? Let’s discuss! 👇 #DataAnalytics #SQL #LearningSQL #100DaysOfData
🌟 Day 32 of SQL Learning Journey 🌟 Today, I tackled two exciting LeetCode problems, pushing deeper into SQL concepts: 1)Game Play Analysis IV 🎮 2)Unique Subjects by Each Teacher 📘 #SQL #LearningSQL #LeetCode #ProblemSolving #DailyLearning
Was bored and decided to work on a SQL task that's been on my laptop . #learningsql I created three tables for a library. One for books records, another for members records and the last for borrowing records, which contained foreign keys from books and members records.
Learned about data types, SQL commands, and how to write queries for databases and tables.#LearningSQL #DatabaseBasics
Some nights it’s just me, my messy dataset, and ChatGPT whispering “we’re almost there.” This data analytics journey is teaching me more than just skills — it’s teaching me patience and power. #LearningSQL #DataAnalytics
So, stay curious, stay patient, and trust the process. You got this💪 This is how my day is going💻 Working on a mini project in SQL👌 #My_data_journey #LearningSQL #ProgressAllTheWay✈️
🚨 Struggling with SQL questions? Use this simple mental model before you write a single line: 🧩 T.A.S.K. T = Tables A = Attributes (columns) S = Steps to filter/join/group K = Key logic (what are you calculating?) 🎯 Think before you SELECT. #LearningSQL #InterviewPrep
Day 3 of my 30-day SQL challenge! Today I delved into JOINS and learned how to combine data from multiple tables. Excited to see how this will simplify complex queries! 💻📊 #SQLChallenge #LearningSQL #DataScience #TechJourney
Writing a simple SELECT * FROM table feels good, But optimizing queries? That’s where the real thrill! If SQL was a person, it would be friend who always knows exactly where to find the best food (with a quick JOIN). Still a beginner, but loving every query ! #SQL #LearningSQL
"Diving deep into SQL — mastering the WHERE clause and 7 powerful operators like LIKE, NOT LIKE, BETWEEN, IN, and more. Querying like a pro! #SQL #LearningSQL #oracleSQL
Database, varchar, int, text, etc. These, and more, are the words I've added to my vocabulary. I just ran my first SQL series and the feeling is powerful. It felt just like unlocking a new language. PS: Peep the new program🤭 #LearningSQL #DataAnalytics #TechCrushHQ #TechJourney
Something went wrong.
Something went wrong.
United States Trends
- 1. Bama 56.8K posts
- 2. #NXTDeadline 22.6K posts
- 3. Georgia 67.2K posts
- 4. Miami 240K posts
- 5. Mendoza 12.2K posts
- 6. Ty Simpson 7,892 posts
- 7. #UFC323 28.7K posts
- 8. Caden Curry 1,140 posts
- 9. #GoDawgs 16.9K posts
- 10. #SECChampionship 5,836 posts
- 11. Indiana 47.7K posts
- 12. DeBoer 5,035 posts
- 13. Kendal Grey 4,222 posts
- 14. Ryan Williams 2,987 posts
- 15. Gus Johnson N/A
- 16. #Big10Championship N/A
- 17. Frank Martin 3,176 posts
- 18. Kirby 16.3K posts
- 19. Ziam 3,234 posts
- 20. Julian Sayin 2,070 posts