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
It will be good to start with a foundational course. there are lots of resources in this space so I will list them:
2. W3Schools. Don't joke with this site. highly valuable and resourceful. You also have the opportunity of trying out the queries without installing any software on your laptop. w3schools.com/sql/
3. SQLCourse: This is another amazing site with easy-to-read instructions just like W3Schools and an online SQL interpreter. sqlcourse.com
4. SQLBolt
Still on the fundamentals. there are lots of resources out there and SQLBolt is one of them
All Levels 1. Hackerrank:
I love the hackerrank approach to learning SQL. You learn by solving challenges and acrrued points to move across levels.
A 30 minutes on hackerrank everyday for 60 days will make a significant impact hackerrank.com/domains/sql
before I move on from Hackerrank, companies today access your SQL skill by sending you tasks on hackerrank. so, the faster you've gone learning and practicing there, the better you are to write efficient queries
2. Leetcode: This is yet another superb SQL learning resource. select different tasks to solve.
very similar to hackerrank, some organizations also test your SQL skill with Leetcode assessment
3. Select Star SQL:
This is an interactive book that aims to be the best place on the internet for learning SQL. It is free of charge, free of ads, and doesn't require registration or downloads.
How to Get the Best from the Global Power Platform Bootcamp 2022, Lagos Nigeria.
Tips can be applied to other areas of your life
Global Power Platform Bootcamp is an annual event that takes place in over 70 cities across the globe where people come together to learn about Power Platform Tools; Power BI, Power Apps, Power Automate, and Power Virtual Agent.
You can register here bit.ly/GPPB2022LAGOS
We will be holding the Lagos edition as a Physical event at the University of Lagos Main Auditorium.
Learning SQL can be very interesting if you are just watching video but nay, watching video or reading SQL Blog doesn't take you anywhere.
Structure your learning and practice in this form 1. Basic SQL: select, filter using where, like, in, etc... #SQLOnBirdApp
2. SQL Joins: focus on learning how to combine data from multiple tables.
I will recommend you learn Set theory and try to solve set questions with 3 subjects involved. It really break down the whole logic and possible relationships.
Google Data Analytics Professional Certificate
Open this THREAD if interested
About Google Data Analytics Professional Certificate.
This was released alongside other course by Google on Coursera in 2021 with over 571k students already.
The Certificate Course has 8 Modules which are courses and takes approximately 6 months to complete at 10hours/week
You will need to subscribe to Coursera or seek for Financial Aid to be able to take the courses and earn a Certificate.
The courses are listed below 1. Foundations: Data, Data, Everywhere coursera.org/learn/foundati…
This is the first course. It has 5 Weeks Learning contents
Let's talk about Adventureworks Database.
This database is popular among data enthusiasts as it is a one of the several free dataset out there to learn with.
In this thread, I will enlighten you on the business behind the database to help you better understand it.
I will put...
.. I will share links to help you learn more.
AdventureWorks Database is a Microsoft product sample for an online transaction processing (OLTP) database.
It is a database for a fictitious multinational company called Adventure Works Cycles.
They are into the manufacturing of ..
... and selling of metal and composite bicycles to North American, European and Asian commercial markets.
HQ in Bothell, Washington with 290 employees, with several regional sales teams are located throughout their market base.
They acquired a manufacturing plant in Mexico in ..
Let's get this right, in the 4th Industrial Revolution which we are in, not everyone can be a Data Scientists, Analytics Engineer, or even a Data Analyst, but everyone must be digital literate to benefit from its numerous opportunities.
Let's see what it takes to be digitally ..
.. literate.
Simply put, digital literacy is the ability for every individual to leverage on the existing and modern technologies for improved productivity at work and in their personal lives.
This means you need to know how to use productivity & collaborative tools efficiently
Learning Microsoft Power Platform will naturally get you to be digitally literate.
For example, you get to know how to use the following apps MS Teams, OneDrive, SharePoint, Outlook, Power Automate, Power Apps, MS Forms etc.
You get to build solutions that will expose you ...