
This section provides an overview of SQL, the following will be covered"
Introduction to SQL
Table and Column Structure
Data Types in SQL
Relational Data and Normalization
Primary and Foreign Keys
This section provides an overview of Basic SQL Queries , the following will be covered"
Selecting data
Using a column alias
Filtering data
Ordering data
This section provides an overview of Basic SQL Queries , the following will be covered"
Aggregates: Max, Min, Sum, Avg and Last
Grouping data with Group By
Filtering grouped results with Having
This section provides an overview of SQL joins , the following will be covered"
Intro to joins
Inner joins
Left/Right joins
Full outer joins
Self joins
This section provides an overview of additional SQL operators, the following will be covered"
Case statements
Wildcards / Like
Limit and offset
And, Or and Between
Even more SQL commands
Why Learn SQL?
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.
Take-Away Skills:
In this course, you’ll learn how to communicate with relational databases through SQL. You’ll learn—and practice hands on—how to manipulate data and build queries that communicate with more than one table.