Learning SQL Programming
4.8 /5- Offered byLinkedin Learning
Learning SQL Programming at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹899 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Learning SQL Programming at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Learning SQL Programming at Linkedin Learning Course details
- Structured Query Language (SQL) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL
- This course provides an introduction to this core programming language
- Learn how to request data from a database, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data
- Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats
Learning SQL Programming at Linkedin Learning Curriculum
Introduction
Learning SQL programming
Exercise files
Exploring DB Browser for SQLite
What is a database?
What is SQL?
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
Challenge: Retrieve data from the database
Solution: Retrieve data from the database
Ask for Data from Two or More Tables
Ask for data across two or more tables
Understand JOIN types
Grouping results
Challenge: Practice with JOINs
Solution: Practice with JOINs
Data Types, Math, and Helpful Features
Data types in SQL
Math in SQL
Compound Select
Transforming data
Creating aliases with AS
Challenge: Calculate participant metrics
Solution: Calculate participant metrics
Add or Modify Data
Add data to a table
Modify data in a table
Removing data from a table
Challenge: Practice working with data
Solution: Practice working with data
Conclusion
Overcoming common SQL mistakes
Learning SQL Programming at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?