Learning SQL Programming
Offered By: LinkedIn Learning
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?
- 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
- Ask for data across two or more tables
- Understand JOIN types
- Grouping results
- Solution: Practice with JOINs
- Data types in SQL
- Math in SQL
- Compound Select
- Transforming data
- Creating aliases with AS
- Solution: State score metrics
- Add data to a table
- Modify data in a table
- Removing data from a table
- Solution: Identifying the correct record
- Overcoming common SQL mistakes
- Next steps
Taught by
Scott Simpson
Related Courses
ちゃんと学ぶ、PHP+MySQL(MariaDB)入門講座Udemy Stream Processing Design Patterns with Kafka Streams
LinkedIn Learning Stream Processing Design Patterns with Spark
LinkedIn Learning Servidor de Base de Datos con Linux y MySQL
Udemy Build a REST API with MariaDB ,Python, Django
Udemy