The Comprehensive SQL Course 2021
What you'll learn
- Become proficient in SQL
- 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
- Oracle SQL
- MySQL
- Microsoft SQL Server
Course content
- Preview03:45
- Preview00:31
- 04:13Getting Set Up On Oracle APEX
- 02:32Installing The Countries Dataset
- 07:27(OPTIONAL) - Manually Installing The Countries Dataset
- Preview02:14
- 02:22Exploring The Countries Sample Dataset
- 01:32Important infomation relating to Oracle APEX Sample Datasets
- Preview01:20
- 01:50Tables
- 01:50Basic Database Terminology
- Preview03:05
- 3 questionsQuiz
Requirements
- Absolutely no prior knowledge required
Description
Want to learn one of the most in-demand skills in the business and technology sector?
Then this course is for you!
SQL skills are highly marketable everywhere, especially in companies like Netflix, Facebook, Amazon, Google… the list goes on and on… The simple fact is that if you want to do any work involving data, then the chances are that you need to know SQL!
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
No downloads or software installation required! We will be using Oracle APEX which is a web-based application – you will be set up with your own virtual database hosted on the cloud! Although we will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL 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 into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every technical section of the course will be rounded off with quizzes / assignments and give you an opportunity to develop your practical skills.
The course will provide students with an extensive Question Bank section which is full of questions and walkthroughs designed to emulate real world scenarios and combine together all of the different SQL clauses, operations and commands taught in this course!
In this course you will learn about:
Data Definition Language Commands such as CREATE, DROP, TRUNCATE, ALTER and RENAME
Data Query Language Commands using the SELECT statement
Data Manipulation Commands such as INSERT, UPDATE and DELETE
Data Control Language Commands such as GRANT and REVOKE
Transaction Control Language commands such as COMMIT and ROLLBACK
Data Types
Qualifying Column Names
Aliasing Columns and Tables
Row Level Functions
Aggregation Functions
The Where Clause
The Group By and Having Clauses
The Order By Clause
Single Table and Multiple Table Joins
SET Operators
Subqueries
Database Constraints
Relational Databases and Data Model Design including STAR and SNOWFLAKE Schemas
Views
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 analsysis
Instructor
![Malvik Vaghadia](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.7 Instructor Rating
- 159 Reviews
- 22,696 Students
- 2 Courses
Malvik 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 analysis and visualisation, with expertise across a number of programming languages including SQL, Python and R. He has worked extensively with a number of leading software platforms including Hadoop, Oracle, MySQL, MS SQL Server, Qlik and Microsoft Power Platforms.
He has a number of certifications including:
· Microsoft Certified Solutions Expert: Data Management and Analytics
· Microsoft Certified Solutions Associate: BI Reporting
· Qlik Sense Data Architect Certification