Linkedin gives us this free SQL programming course with certification
Course details
Structured Query Language (SQL) is a common tool for retrieving data from relational databases such as SQL Server, Oracle, MySQL, MariaDB, and PostgreSQL.
This course provides an introduction to this core programming language.
Learn how to query data from a database, limit and sort responses, add data from multiple tables with joins, edit and delete data. Instructors of this course also show how to perform simple mathematical operations and transform data into different formats.
Course Contents
Introduction
Learning SQL programming
Exercise files
Exploring DB Browser for SQLite
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
Challenge: Retrieve data from the database
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
Challenge: Practice with JOINs
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
Challenge: Calculate participant metrics
Solution: Calculate participant metrics
4. 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
Next steps
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
Sample certificate
Showcase on your LinkedIn profile under “Licenses and Certificate” section
Download or print out as PDF to share with others
Share as image online to demonstrate your skill
Our task is to centralize the largest number of courses, training, tutorials, videos to make it easier for you to search when you want to train.
Generally, we incorporate those that are free, but if we find some interesting ones that are paid, we add them so that your training is more profitable and professional.
Keep training yourself to become a better professional or simply for personal achievements, cheer up, don't give up and go ahead !!!.
Good luck !!! The team of:
|