MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
Join this course if you are seeking to learn data skills to advance in your current field or pivot to a different field where you will interact with data.
In this SQL tutorial you will learn how to interact with the SQL server with the proper syntax, begin to use SQL commands and SQL databases, perform SQL queries, work with data types and database tables, and use
This course is part of the From Database to Dashboard using SQL and Power BI Professional Certificate.
What you'll learn
- How to use a relational database
- How to query data and shape results
- How to write advanced queries and analytic functions
- How to create and modify data in tables
Syllabus
SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting, and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professionals to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases. Join this course if you are a student or professional hoping to learn data skills to advance in your current field or pivot to a different career that is more data focused. _ ****_
Week 1
Introduction and History of SQL
Installing PostgreSQL
Basic SQL
Comments & SQL Styles
Week 2
SQL Joins
Aggregations & Subqueries
Data Inspeciton and Converting Data
String Manipulation
Week 3
Analytic Functions
Variables and Temporary Sets
Recursive Operations Using CTEs
Pivoting Data
Week 4
Sample Database Installation
3 Final Exercises
Putting It All Together!
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.