The Comprehensive SQL Course
What you'll learn
- MySQL
- Become proficient in SQL
- Relational Database Design
- Students will be able to apply SQL to real world problems
- Boost your CV with one of the most in-demand skills in the data analysis and software development professions
- Apply what you've learnt across different database management systems
Requirements
- Absolutely no prior knowledge required
Description
This course has been completely re-done
Want to learn one of the most in-demand skills in the business and technology sector? Then this course is perfect for you!
SQL is one of the most in demand programming languages in the world. It’s the language used to communicate with Relational Databases.
In addition to the extremely popular relational databases such as MySQL, Microsoft SQL Server and Oracle Databases more and more platforms new and old are supporting SQL including Amazon Redshift, Databricks, Snowflake, Google BigQuery and the list goes on and on…
According to IEEE Spectrum - SQL is the top programming language when it comes to its “Jobs” ranking.
This course has been designed for:
Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language
Those with some experience looking to brush up on their SQL knowledge
We will be using MySQL which is one of the most widely used relational databases in the world. The version we’ll be using is open source and completely free.
Although we will be using MySQL the course has been designed to highlight key differences between some of the main Database Management Systems such as Oracle, Postgre and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.
The lectures in this course are arranged in a logical flow and delivered as short, bite-sized videos. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every major section of the course will be rounded off coding challenges and dedicated assignment sections to give you an opportunity to develop your practical skills.
Who this course is for:
- Beginners looking to learn SQL
- Individuals with prior SQL knowledge looking to refresh their SQL skills
- Individuals looking to pursue a career in software engineering, business intelligence or data analysis
Instructor
Malvik is an Instructor specialising in Data Analytics and BI.
He has spent 10+ years working for and consulting a number of publicly listed / unlisted companies as a Data and BI specialist. Over the course of his career Malvik has developed a skillset in data engineering, data analytics and business intelligence, with expertise across a number of technologies and programming languages including SQL, Python and R. He has worked extensively with a number of leading software platforms including Azure, Hadoop, Spark, Databricks, MongoDB, Oracle, MySQL, MS SQL Server, Qlik and more.