#31daysofsql resultados de búsqueda
The asterics(*) implies that all records should be selected from the DATA table. It returns all the records. #31DaysofSQL #programming
Day2 of #31DaysofSQL I almost didn't do anything today but I learnt how to use JOIN in SQL and also did some practice
#31DaysofSQL #SQLMay Day 2 Even though I wanted to learn JOINs, I ended up spending more time practising INSERT, CASE WHEN, Subqueries and Nested queries Window functions flogged me and I don't think one could truly master subqueries tbh, we keep trying We go again tomorrow
Dear Data Analyst! Take 2 minutes to watch this underated clip on "Where Data Analytics takes you". While learning Joins with Coursera today, I stumbled on this really incredible clip that fueled my existing passion about Data Analytics #31DaysofSQL #DataAnalytics @iam_Uchenna
Little drops of SQL everyday, makes me a Master. Good morning Datafam. What are we learning today? #31daysofSQL
So today,I left R for a minute to participate in the #31daysofSQL challenge,I went to data camp and tied my loose ends. Not bad for the first day😁
-MySQL and PostgreSQL are popular open source databases that are known for their scalability and flexibility. -SQL Server is a popular proprietary database that is known for its ease of use and integration with other Microsoft products. #31DaysofSQL #SQLMay
A beautiful day to query databases, and manipulate data with SQL. LETS GET IT💪 #31daysofSQL #SQLMay #DataScience #DataAnalytics #Adventureworks
Today, I practiced Set operations and Joins on @Datacamp. As a budding Data Analyst, I always want to have these functions at my fingertips so I can apply them as I work on projects. For a quick recap, find a simple concept breakdown of Joins & Set Operations. #31DaysofSQL
Every select statement must have same number of column and same data type. The UNION Operator Selects only Distinct Values by default. To allow duplicate values use UNION ALL. #SQLMay #31DaysofSQL
#SQLmay #31DaysofSQL Day 2 Have learnt the SQLbasics on simpilearn. Today i did some practice on SQLbolt for 1. Multi-table queries with JOINs 2. Outer JOINs 3. Queries with expressions
such as CONCAT,TRIM,SUBSTRING etc. The CONCAT () function adds two or more string together , it could also add two or more column together Syntax : SELECT Column_1, Column_2, CONACT ( Column_1, '/', Column_2) FROM Table_Name. #SQLServer #31DaysofSQL
Wake up you sleepyhead, you've got some work to do #SQLMay #31DaysofSQL
2023/05/02 SQL Day #MaySQL #31DaysofSQL ReLearnt JOINS and practiced some syntaxes. Hectic day, buh mastered ALIASING and JOINs. Slowly but not snaily😤 My most common errors: forgetting comma(,) at the end of SELECT Statement.
Day 12 on #sqlmay challenge I finished introduction to SQL course on simplilearn 🥳 #31daysofsql
Today, I gained a clear understanding of the window function in SQL and its functionality, which I utilized to address a business question in my ongoing project. This month promises to be highly productive as I continue to engage with and expand my knowledge of SQL. #31DaysofSQL
I got an installation guide for SQL, and also a video guide for #SQL 🥲 Since I covered a lot of SQL stuffs in the Google cert. course, my #31DaysofSQL will be more of practicing the codes, syntax, clauses, e.t.c
2023/05/07 My tiredness is tired 🥲 I just tried out a practice solution and it was ✅ #MaySQL #31DaysofSQL @iam_Uchenna 😤
Will this twitter space end today so that I can go and face my SQL? #31DaysofSQL
#31daysofSQL #SQLmay Day 4 Practice questions on sql bolt on queries with aggregates, and queries with expressions.
✅ What is the highest and lowest price of our inventory? SQL aggregate functions empower us to analyze data efficiently and gain a deeper understanding of our business. Let's dive into the world of data analysis together! 💪💻 #31DaysofSQL #SQLMay #datafam
Solution: SELECT date_part('month', date) AS month, SUM(amount) FROM sales GROUP BY month ORDER BY month Date/Time functions can be used with aggregate functions such as MIN, MAX, COUNT. #LearnDataAnalyticswithTina #SQL #31daysofSQL
counting from one. What happens when you have varying delimiters such as ;, -, all in one string of characters? We use the CASE WHEN statement. #LearnDataAnalyticswithTina #SQL #31daysofSQL
6/ 🔍 Statistics assesses data reliability and quality. It identifies variability, outliers, and ensures data validity, leading to more robust analyses. #DataAnalytics #Statistics #31DaysofSQL #SQLMay #datafam ##
5/ 📈 Statistics plays a crucial role in data visualization. It helps us create meaningful charts and graphs that effectively communicate complex information. #DataAnalytics #Statistics #31DaysofSQL #datafam #SQLMay
4/ 📊 Statistics enables hypothesis testing and predictions. Through techniques like regression analysis, we can determine relationships and make data-driven predictions. #DataAnalytics #Statistics #31DaysofSQL #datafam #SQLMay
3/ 📏 Statistics reduces bias and provides reliable evidence. By using statistical techniques, we can make accurate inferences from data, leading to more objective insights. #DataAnalytics #Statistics #31DaysofSQL #datafam #SQLMay
7/7 Data Analysis vs. Data Analytics: 📊📈 In summary, Data Analysis examines data, while Data Analytics extracts insights. Both are crucial for data-driven success. 💡🔍 #DataDrivenDecisions #31DaysofSQL #SQLMay #datafam
I just understood how to create foreign keys relationship in SQL Server and I'm excited, cos I've been struggling with this for some time now😊😊😁😁 #SQL #31DAYSOFSQL
Data Exploration and cleaning of the Global terrorism dataset taking me a whole day and I just want it to end... #Dataanalysis #SQL #31DAYSOFSQL
Treat SQL queries like mind-bending puzzles. Use your logical thinking to solve complex problems by breaking them down into manageable steps, utilizing functions and conditions as your puzzle-solving tools. #31DaysofSQL #SQLMay #datafam
Little drops of SQL everyday, makes me a Master. Good morning Datafam. What are we learning today? #31daysofSQL
Just starting to learn SQL? Remember, practice makes perfect! Get comfortable with basic queries and gradually work your way up to more advanced topics like subqueries and window functions. Don't be afraid to ask questions and seek out resources. #31DaysofSQL #SQLMay #datafam
Remember, every journey starts with a single step. Embrace challenges, stay persistent, and enjoy the thrill of unraveling valuable insights hidden within data! 🚀💡 #31DaysofSQL #datafam #SQLMay
The asterics(*) implies that all records should be selected from the DATA table. It returns all the records. #31DaysofSQL #programming
Day2 of #31DaysofSQL I almost didn't do anything today but I learnt how to use JOIN in SQL and also did some practice
Day 6 of SQL May Challenge ✨ After Analysis my data in SQL i quickly used Microsoft Excel to visualize and as you can see, my dashboard is hot 🥵 #SQLMay #31DaysofSQL
Day 1 of May SQL Challenge I just completed an intermediate SQL course on @DataCamp and I'm excited to share some of the key concepts I learned! While the course covered a wide range of topics, I didn't have a chance to dive into windows functions and subqueries. #31DaysofSQL
Day 4 of SQL may challenge I am currently working on a project that has got 71 Tables and Millions of records My hands are sweating 😅 😩 My Laptop has died and resurrected again #31DaysofSQL #SQLMay
Day 3 of SQL May challenge! I took the Data Analyst in SQL course by @DataCamp and ‘Understanding Data Visualization’ is the first course in the track. I gathered a good knowledge about Box plots, Line plots, Linear regression and logistic regression. #31DaysofSQL #SQLMay
Day 2 of SQL May challenge I Just completed the @DataCamp course on 'Joining Data in SQL' and I'm excited to apply my new skills to real-world data problems. #31DaysofSQL #SQLMay
A beautiful day to query databases, and manipulate data with SQL. LETS GET IT💪 #31daysofSQL #SQLMay #DataScience #DataAnalytics #Adventureworks
😏Hear me Out #datafam Window functions simplify complex queries, I agree . They are easy to learn , they lied . Here is the breakdown of the query: #SQLMay #31daysofSQL #DataAnalytics
Little drops of SQL everyday, makes me a Master. Good morning Datafam. What are we learning today? #31daysofSQL
#31DaysofSQL #SQLMay Day 2 Even though I wanted to learn JOINs, I ended up spending more time practising INSERT, CASE WHEN, Subqueries and Nested queries Window functions flogged me and I don't think one could truly master subqueries tbh, we keep trying We go again tomorrow
Today, I practiced Set operations and Joins on @Datacamp. As a budding Data Analyst, I always want to have these functions at my fingertips so I can apply them as I work on projects. For a quick recap, find a simple concept breakdown of Joins & Set Operations. #31DaysofSQL
Day 3 of #MaySQL Learned and practiced CASE Statement: The CASE expression goes through conditions and returns value when the first condition is met( like an if-then-else statement). #31DaysofSQL
Day 1 of May SQL Challenge So today I learnt how the HAVING CLAUSE works and I also practiced with it. #31DaysofSQL
So today I practiced PARTION BY, SUM, CONVERT,CAST. Even though I got an error message😩 when I tried out some codes. Who knows my error?? #31DaysofSQL
Day 2 of SQLMay Practiced how to create Temporally Tables(temp_table), and the highlight of my day was that I successful imported data into SQL with the help of @Iam_Uchenna. #31DaysofSQL
#31DaysofSQL I get this error every-time I try to import this particular data into my database. Any help in solving this?
So today,I left R for a minute to participate in the #31daysofSQL challenge,I went to data camp and tied my loose ends. Not bad for the first day😁
Something went wrong.
Something went wrong.
United States Trends
- 1. Canada 321K posts
- 2. Reagan 108K posts
- 3. #FanCashDropPromotion N/A
- 4. #FridayVibes 5,183 posts
- 5. Good Friday 66.4K posts
- 6. Immigration 159K posts
- 7. #FridayFeeling 2,816 posts
- 8. Happy Friyay 1,622 posts
- 9. #FursuitFriday 12.4K posts
- 10. U-Haul 9,184 posts
- 11. Cyrene 25.6K posts
- 12. 3% in September 5,454 posts
- 13. MADURO LOS TIENE LOCOS 1,270 posts
- 14. Tren de Aragua 17.3K posts
- 15. #phanniefriday N/A
- 16. Halle 24K posts
- 17. Oval Office 21.2K posts
- 18. Core CPI 4,997 posts
- 19. Leon Thomas 6,561 posts
- 20. Inflation 102K posts