From Excel To Sql

Currently reading:
 From Excel To Sql

0nelove

Member
Amateur
LV
4
Joined
Jul 12, 2024
Threads
1,504
Likes
12
Awards
9
Credits
8,401©
Cash
0$
Hq720

Duration: 1h 24m | MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size: 863 MBsh​

Skill Level: Beginner | Genre: eLearning | Language: English + Subtitles
Data is powerful, and the ability to access it quickly and accurately is important. In this course, instructor James Parkin helps you use your existing Excel skills to master the basics of working with data in SQL, one of the most common languages for database wrangling. James shows you how to set up your environment for SQL and shares some differences between spreadsheets and databases. He steps through SQL basics that you need to know to access and identify the data you need. In both Excel and SQL, you work with functions. James covers several, including SUM, AVERAGE, MIN, MAX, COUNT. He explains different methods of sorting, grouping, and organizing your data in SQL. James concludes by showing you how to use joins, VLOOKUP, HLOOKUP, and XLOOKUP to combine your data.This course was created by Madecraft. We are pleased to host this training in our library.
Homepage
Screenshots


Buy Premium From My Links To Get Resumable Support and Max Speed
 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Tips
Top Bottom