A free online course to learn SQL programming from Microsoft
SQL programming learning course details:
SQL (Structured Query Language) is a popular tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this basic programming language. Learn how to request data from a server, restrict and sort responses, combine data from multiple tables with joins, and edit and delete data. Trainer Scott Simpson also demonstrates how to perform simple calculations and convert data into various formats
SQL Programming Learning Course Instructor:
Scott Simpson
He holds a master’s degree in education and is currently creating technology courses as an author on LinkedIn.
About SQL programming:
Our world is driven by data and a lot of that data is stored in databases. In order to unlock the information and ideas stored in databases, we need a way to request data. One popular language for querying and modifying data in databases is SQL. SQL is more or less used in database products across the spectrum. From small SQLite databases in mobile devices to MySQL servers and data hosting for blogs and other applications, to Oracle and Microsoft SQL server databases that run billions of dollars in businesses. But the same basic language underlies all of this. In this course, I’ll explain what SQL is, and take an introduction to the language. You’ll see how to ask questions about databases in an organized manner to get the information you need. We’ll focus on the language itself, not any particular tool. And the amount of preparation you’ll need to do in order to get started is minimal. The aim of this course is to make you feel comfortable …
Course contents:
1- Part One: Database data
Data request
Narrow down the query by using WHERE
Find information about the data
2- Obtaining data from two tables
Data type
Data collection
3- Data types and their functions
Types of data
Mathematics in the data
Data transfer
Use aliases to shorten field names
4- Add and modify data
Add data to a table
Modify data in the table
Remove data from table
