SQL for Non-Programmers
Offered By: LinkedIn Learning
Course Description
Overview
Practice using basic SQL Data Query Language commands in this course designed for non-programmers and non-data science professionals.
Syllabus
Introduction
- Why SQL and why now?
- What you should know
- Set up with SQLite and SQLiteStudio
- Relational databases
- Database structuring through normalization
- The power of SQL
- DQL for all
- Getting started with SQL
- Retrieving data with SELECT
- Formatting your query
- Putting order to your data with ORDER BY
- Filtering your data with WHERE
- Filtering your data with multiple conditions
- Challenge: Practice with basic commands
- Solution: Basic commands solved
- Getting started with aggregate functions
- Making aggregate functions work for you
- Group data using GROUP BY
- Filter on groups of data with HAVING
- Challenge: Practice with aggregate functions
- Solution: Aggregate functions solved
- Combining tables with an Equijoin
- From Equijoins to Inner Joins
- Other types of SQL joins
- Challenge: Practice with multiple table joins
- Solution: Multiple table joins solved
- Categorize data with CASE
- Beyond basic CASE statements
- Creating Calculated Fields
- Matching data with wildcards
- Combining data with UNION
- Challenge: Practice with advanced commands
- Solution: Advanced commands solved
- Recommendations and next steps
Taught by
Christina Stathopoulos
Related Courses
Developing Android AppsGoogle via Udacity Programming Mobile Services for Android Handheld Systems: Content
Vanderbilt University via Coursera Create Your First Web App with Python and Flask
Coursera Project Network via Coursera Python Mega Course : Go Beginner to Expert in Python3
Udemy Build Real Software with Python, PyQt5 and QT Designer
Udemy