LinkedIn – From Excel to SQL 2021-3

Description

From Excel to SQL course. This course will help you use your Excel skills to learn the basics of working with data in SQL. SQL is one of the most common languages ​​for working with databases. In today’s world, data is very valuable and the ability to access it quickly and accurately is very important. In this course, course instructor James Parkin shows you how to learn the basics of working with data in SQL using existing skills in Excel.

What you will learn:

• Comparing Excel and SQL: Understanding the differences between spreadsheets (like Excel) and databases.
• SQL Basics: How to view, filter and limit data in SQL.
• Working with Functions: Use functions like SUM, AVERAGE, MIN, MAX and COUNT to analyze data.
• Data organization: Sorting, grouping and creating pivot tables in SQL.
• Combining data: Using JOINs and functions similar to VLOOKUP and HLOOKUP in Excel to combine data from different sources.

This course is suitable for people who:

• Looking to expand their skills in the field of working with data.
• They are familiar with Excel software.
• Want to learn the basics of SQL.
• Interested in working with databases.

Details of the From Excel to SQL course

• Publisher:  LinkedIn
• Instructor: Madecraft , James Parkin
• Training level: beginner to advanced
• Training duration: 1 hour and 24 minutes

Course headings

Course images

Sample video of the course

download link

Download file – 826 MB

File(s) password: www.downloadly.ir

File size

826 MB