Roadmap to learn SQL | SQL Roadmap | Learn SQL in 1 month

Key Takeaways

hi friends we are back with our roadmap series video on sequel so welcome to this short and crisp video on how to learn SQL in just four weeks watch this video till the end as there is a bonus waiting for you right at the end of this video but before we jump into the roadmap let me give you a quick backdrop of the ups and downs in the Journey of SQL as a tool so SQL or structured query language is a programming language used for managing and manipulating relational databases it was first introduced in the 1970s and hence since become the standard for managing and querying relational databases in the late 2000s a new type of database called nosql emerged which offered a different approach to data management suitable for handling large amount of unstructured data such as brick data and as a result many companies begin to adopt nosql databases and there were predictions out there saying that SQL would become obsolete however SQL managed to adopt and evolve to meet the changing needs of modern applications in many SQL databases now offer features like horizontal scaling and improved performance companies today use a combination of both SQL and nosql databases to get the best of both worlds not just that according to Glassdoor the average salary for a SQL Developer in the US is over eighty thousand dollars per year and with the rise of big data and data analytics this demand for SQL skills is only going to increase so I hope I've excited you enough to get started on this amazing journey to learn SQL in 2023 this is our fifth video in our career roadmap series hope you are liking them till now in order to learn SQL you need to focus on mainly three SQL components the first one is data manipulation language which is used to manipulate data in a database and comprises of commands like select insert update and delete the second component is data definition language which is used for defining and modifying the structure of a database and has commands like create alter and drop and finally the third component data control language which is used for controlling access to the data in a database and has commands like Grant and revoke so in our roadmap we are asking you to spend week one and two on DML week 3 on ddl and week 4 on DCL you may also need to choose a dbms which could be MySQL Oracle postgres SQL or Microsoft SQL Server we shall be assuming that we are using MySQL because it is beginner friendly we have divided this roadmap to learn SQL in four weeks presuming you shall study for 10 hours per week so amounting to a total of 40 hours of learning time so let's get started so week one is your getting started with SQL week where we would look at overview of databases including various types of databases relational and non-relational databases how are they different and how is data stored in them the asset properties of relational databases and the database management system you will also need to set up your machine to run SQL you may either install MySQL on your machine or end the complete installation guide is provided in our SQL free course or you can use online tools like SQL boot or SQL teaching or W3 schools any of those are great now coming back to the roadmap we'll next look at basic data manipulation by performing select commands on pre-existing database with mySQL like where order by Group by having unconditional statements by the end of this first week you shall have a holistic understanding of databases and Hands-On SQL experience for data manipulation on a single table which brings us to the week 2 which is where we'll work with multiple tables so we'll start with concept of various Keys like primary key foreign key and joins using them and different kind of joints like inner join outer join right join left join Etc will also understand how to do SUB queries and write various functions like some average Max Min Etc so by end of week two you will be able to practice data manipulation queries on platforms like hacker Earth and w3schools next we move to week 3 which is where you'll create and manage databases and tables using crud operations so crud stands for creating databases retrieving records from databases updating those records or deleting those records all of these four steps combined are called crud operations in SQL and by end of third week you should have a holistic sense of data manipulation as well as data definition in week 4 we'll focus on the third part which is data control so you would need to focus on creating views it is defined as a virtual table based on the result of SQL statements which help you simplify the data for analysis or reporting and offers better security you are bound to use it in day-to-day usage Additionally you should look at triggers stored procedures query optimization and data normalization how does it affect your database design and how to normalize any data next you should study various things like module packages triggers and cursor you should get familiar with admin access of these databases and at this point you should also do a project and this project you should choose based on your interest so if you are someone who likes watching movies you can do a project on creating a movie databases if you are someone who likes music you could create your own music library if you're someone who is creating your own social media profile you can create a database of interesting posts you might have seen before so by end of this four week Journey you'll have a solid understanding of SQL and you'll be able to use it to manage and analyze data remember to practice whatever you have learned and continue to expand your knowledge by exploring new topics and resources don't forget to subscribe to our channel for more such data related videos and upcoming content thanks for watching bye