Introduction to SQL (edX)

Introduction to SQL (edX)
Course Auditing
Categories
Effort
Certification
Languages
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Introduction to SQL (edX)
In this introduction to SQL Online Course you will gain strong understanding and utilize SQL to aggregate, manipulate, analyze, and visualize data in your field. 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 professions 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.

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.

Course Auditing
181.00 EUR

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.