Top Tweets for #SQLOnBirdApp

over 4 years ago

SQL Learning Resources Thread As a Beginner learning Data Analysis, Data Science + SQL, it is always good to connect the dots through projects and use cases. In this growing thread, I will first share some resources with possible SQL projects to test your skill #SQLOnBirdApp

26

952

415

828

0

over 4 years ago

Vid 13: Fix ODBC Driver Error and Import Data in Excel 2007+ to MS SQL Server. If you have any challenges importing data from Excel versions 2007 and above, this video will help you address the issue. https://t.co/0uMo1oXn9g #SQLOnBirdApp

0

2

1

4

0

over 4 years ago

Vid 12: Turn Your Excel Data to SQL Database Table. I encourage data enthusiasts to try this method for their data projects. import your project data to SQL Server and connect to it from there. https://t.co/eIcdJCKy0F #SQLOnBirdApp

1

3

1

5

0

over 4 years ago

Vid 11: Create Database Diagram with SSMS. Using the Adventureworks database, I did not only share the importance of a Database Diagram, but I also showed you how to create one. https://t.co/XtyfUdZLQE #SQLOnBirdApp

1

3

0

2

0

over 4 years ago

Vid 10: What is SQL Self JOIN? Check this video for the answer with demonstrated practical examples. https://t.co/t1U2xdKF0m #SQLOnBirdApp

1

3

0

1

0

over 4 years ago

Vid 9: SQL JOINS I took my time to explain the concepts of SQL JOINS from Set Theorem and connect the dots together. with practical demonstrations. https://t.co/xcWYyNFLpN #SQLOnBirdApp

1

2

0

1

0

over 4 years ago

Vid 8: How to filter text in MS SQL using Wildcard I have taken live SQL coding tests and they all assess my knowledge of SQL Wildcard. This video demonstrates how to filter text using Wildcards https://t.co/XxsHHHqwou #SQLOnBirdApp

1

3

0

2

0

over 4 years ago

Vid 7: Let's Explore together, the AND,IN,BETWEEN commands. I shared use cases where they are applied using the Adventureworks database. https://t.co/34SuvFnDPd #SQLOnBirdApp

1

2

0

1

0

over 4 years ago

Vid 6: How do you query and handle NULL in MS SQL? Check this video for the answer with demonstrated examples. https://t.co/feZNO48l8p #SQLOnBirdApp

1

4

0

1

0

over 4 years ago

Vid 5: The CASE command can be very confusing if you don't understand their use cases and how to logically write one. I address this concern in this video. https://t.co/99joL3Caqa #SQLOnBirdApp

1

3

1

1

0

over 4 years ago

Vid4: Now unto DISTINCT and WHERE Command. Why do you need them and when to use them? I answered these questions with demonstrated examples. https://t.co/JUpnKaVvJA #SQLOnBirdApp

1

4

1

1

0

over 4 years ago

Vid 3: It's finally time to start writing queries. but before that, I shared the SQL Anatomy and we then proceed to write our first set of queries against the Adventureworks database https://t.co/TuNijhwqy6 #SQLOnBirdApp

1

2

1

1

0

over 4 years ago

Vid2: You should not miss this video for anything. A proper understanding of the database is required to effectively work with it. I did an exploration of the Adventureworks database and the business that generates the data. https://t.co/FNiUFcGQ2o #SQLOnBirdApp

1

4

1

1

0

over 4 years ago

Vid1: This is the first video in the series. I did a walkthrough on how to Install MS SQL Server on your computer and restore the Adventureworks database. This is the first step to getting your hands dirty with SQL https://t.co/3hHE4Vbrnn #SQLOnBirdApp

2

5

1

3

0

over 4 years ago

This is the Intro video. In this video, I shared what will be covered in the entire playlist. It is a Living Playlist hence new content will be added frequently. https://t.co/VLncCU6ie5 #SQLOnBirdApp

3

6

1

6

0

over 4 years ago

PRACTICAL SQL for Beginners. Check this thread for video resources I created on SQL for beginners #SQLOnBirdApp

6

187

90

162

0

over 4 years ago

SQL is not difficult. the challenge is how to comprehend business needs. If you know what you want to achieve and can visualize it, learning the queries can come easier. The thought process to solving SQL challenges is as important as the queries. #SQLOnBirdApp

9

144

24

7

0

over 4 years ago

7. Advanced SQL JOINs and Query Performance Tuning Writing Optimal queries is powerful. This is what different interview test cases are testing. Beyond having a query that runs successfully, it will be exposed to several use cases to validate if it's optimal. #SQLOnBirdApp

3

14

1

0

0

over 4 years ago

6. Now moving to the advance stage "SQL Windows Functions" Windows Functions allow you to compare one row to another without doing any joins. This concept is powerful. #SQLOnBirdApp

1

16

1

1

0

over 4 years ago

5. Data Cleaning in SQL Leveraging on what you've learnt from 1-4 above, you can combine this to clean data better, converting and transforming Date Value, Missing Data analysis, etc.. #SQLOnBirdApp

1

16

1

0

0

Last Seen Hashtags on Sotwe

Trends for you

Most Popular Users