YoVDO

Learning SQL Programming

Offered By: LinkedIn Learning

Tags

SQL Courses Databases Courses MySQL Courses PostgreSQL Courses MariaDB Courses Relational Databases Courses Data Manipulation Courses Data Retrieval Courses

Course Description

Overview

Learn the basics of SQL, the programming language for retrieving and editing data from databases such as SQL Server, MySQL, MariaDB, and PostgreSQL.

Syllabus

Introduction
  • Learning SQL programming
  • Exercise files
  • Exploring DB Browser for SQLite
  • CoderPad tour
  • What is a database?
  • What is SQL?
1. Ask for Data from a Database
  • Ask for data with SELECT
  • Narrow down a query with WHERE
  • Adding more criteria to a statement
  • Broadening and limiting responses
  • Organize responses with ORDER BY
  • Find information about the data
  • Solution: Retrieve data from the database
2. Ask for Data from Two or More Tables
  • Ask for data across two or more tables
  • Understand JOIN types
  • Grouping results
  • Solution: Practice with JOINs
3. Data Types, Math, and Helpful Features
  • Data types in SQL
  • Math in SQL
  • Compound Select
  • Transforming data
  • Creating aliases with AS
  • Solution: State score metrics
4. Add or Modify Data
  • Add data to a table
  • Modify data in a table
  • Removing data from a table
  • Solution: Identifying the correct record
Conclusion
  • Overcoming common SQL mistakes
  • Next steps

Taught by

Scott Simpson

Related Courses

Managing Big Data with MySQL
Duke University via Coursera
Database Management Essentials
University of Colorado System via Coursera
Business Metrics for Data-Driven Companies
Duke University via Coursera
Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique
Базы данных (Databases)
Saint Petersburg State University via Coursera