SQL Fundamentals
Product description
This course is designed for the beginner SQL user. It is for anyone who works with data– regardless of technical or analytical background. During this course, you should be able to gain a basic understanding of what SQL is about and how to use its most common functionalities.
Product description
Do you want to upskill yourself in one of the most popular languages in the data world? Then this course is for you.
Structured Query Language (SQL) is regarded as one of the most popular languages in the data world.
SQL is the standard and most widely used programming language for relational databases. It is used to manage and organise data in all sorts of systems in which various data relationships exist. SQL is a valuable programming language with strong career prospects.
Let’s assist you and your team to gear yourself with SQL knowledge to your toolkit to take advantage of the world of analytics..
Audience Overview
This course is designed for the beginner SQL user. It is for anyone who works with data– regardless of technical or analytical background.
During this course, you should be able to gain a basic understanding of what SQL is about and how to use its most common functionalities.
Typical users include:
- Analytics teams or users that interact with the team’s data.
- Students looking to advance their careers in the data world.
- Users that will typically build reports.
Course Outcomes
At the end of this course, you should be able to gain a basic understanding of SQL principles and fundamentals.
Course Outline
Topics covered during the course include:
- Relational databases
- Writing basic select statements, such as where, between, null, order, top, group by, distinct, select, into etc.
- Querying from multiple data source, using joins and unions
- Writing subqueries and CTE’s
- Inserting, Updating, Altering, and Deleting data
- Working with functions like left, len, concat, if, and case
- Working with temp tables
- Creating, querying and deleting a view