SQL stands for Structured Query Language and used for creating, maintaining, and communicating with databases. Databases are essential part of the website, games, and other software we interact with on daily basis. They make the storing, transfer of data quick and efficient and make our daily digital experiences smooth and enjoyable.
There is incredible amount data created everyday, everywhere. Databases make storing them and using them possible. SQL is a standard language for relational database management systems. While the usage of SQL have differences between different systems, for the most part they share the common language, commands, and syntax.
We can even use SQL to get Hive blockchain data. There is HiveSQL services that is available for anybody to use for free. But of course SQL can be used in many other places for different purposes. It is one of the commonly used languages for data analysis and may even be a requirement for jobs in this field.
Reasons to consider learning SQL will be different for everyone. They may range from learning new skills for career purposes, developing software, automating personal or work projects, etc. Besides the reasons, it is also important to consider resources available and time that may be required to learn these skills. There are many resources and educational material available online for free. Some people even may prefer learning from books, which are also available in abundance. However, learning any programming language is done best by practice and actually typing in the code and experimenting. Same thing is true for SQL.
I prefer better structured approach and wouldn't mind paying a fee for a course if it saves time. One of the online courses I took when learning SQL was - The Complete SQL Bootcamp 2022: Go from Zero to Hero by Jose Portilla on Udemy. This course focuses on teaching PostgreSQL while pointing out what may be different in other systems like MSSQL, etc. This is a great course for any beginner. Jose has a unique approach of teaching that keeps things simple, keeps the student interested, recognizes where new learners may have difficulty understanding beforehand. It also utilized practical approach of keeping learners engaged by giving tasks to complete, and assessment tests.
When it comes to SQL skills, in my understanding there are two main use cases. The first being an ability to build and maintain databases for others to use. This would be the database architects and administrators. The second is getting data from the database, using the database for various purposes. This could be data analysts, data scientists, and other data users. For example, HiveSQL is a service to get Hive blockchain data. We can only query data from the HiveSQL. We don't have to worry about how it is created and maintained.
Just learning how to retrieve data with SQL queries alone can be a powerful skill to have. In such cases we don't even have to worry about the database creating, data manipulation, adding, deleting, and altering data aspects of the SQL.
Jose does a great job recognizing this, and starts out teaching how to retrieve data and all possible ways of dealing with database and tables in obtaining desired data and results. At later stages of the course he does cover creating and maintaining databases as well. However, he doesn't go too much into details. He teaches just enough for any beginner to get started and provides other resources like documentation and how to read them to gain more skill and the beginner progresses in this journey. Also, Jose shows ways of utilizing python in combination with SQL. IF you also like or learning python, combining SQL with python can be a powerful skillset to have.
Another online course I would recommend is by Venkat at Pragim Technologies and is titled - SQL Server Tutorial for Beginners | SQL Tutorial for Beginners. It is free and consists of 150 parts. All of the videos are available on youtube. This course uses MS SQL and more in-depth compared to Jose's courses. Venkat uses MS SQL Server and SQL Server Management Studio. If you are a Windows user, it should be easy to follow the steps to install needed software at the start of the course. Mac users may have difficulty following this course, since the software used are not available for Mac.
Unlike Jose, Venkat starts out with teaching how to creating and altering databases and database objects. He doesn't start talking about how to retrieve data from a database until Part 10. Those of us who initially might be interested in learning how to write queries to get data from databases, may get discourages at the beginning. For this reason I would suggest to start with Part 10-17 after Part 1, which shows how to install needed software. After covering Parts 10-17, go back to Part 2 and continue from there. Or just start from the start and don't give up too early.
Venkat's teaching methodology may seem boring at first, but after going through multiple parts it becomes very obvious that the course is structured very well to build the knowledge and skills one step at a time. I am half way through this course and really like. I like how the parts are divided up on certain topics, which makes it easy to go back and review.
He doesn't provide any practice tests and assessment tests to keep learners engaged with the topic. But it is expected that learners practice on their computers and use the codes taught as they watch the lessons. That makes a big difference in learning any programming language. Venkat's approach is very detailed. He goes into all details when covering a topic and shows various ways of achieving given tasks.
These are two courses I would suggest to anyone who is interested in learning SQL. I hope you find them useful.
Posted Using LeoFinance Beta
