From Excel to SQL

Focused View

James Parkin and Madecraft

1:24:45

306 View

01 - Introduction

01 - Moving from Excel to SQL.mp4

01:03

02 - Setting up your environment for SQL.mp4

03:08

02 - Comparing Excel and SQL

01 - Spreadsheets vs. databases.mp4

02:41

02 - What is SQL.mp4

02:53

03 - SQL Basics

01 - Viewing data in SQL.mp4

03:43

02 - Identifying columns in SQL.mp4

03:13

03 - Filtering rows in SQL.mp4

05:28

04 - Combining filters in SQL.mp4

08:35

05 - Limiting results in SQL.mp4

03:25

06 - Comparison operators in SQL.mp4

02:08

07 - The LIKE operator in SQL.mp4

02:17

04 - Working with Functions

01 - Using SUM in SQL.mp4

03:14

02 - AVERAGE, MIN, MAX, and COUNT in SQL.mp4

04:17

03 - Finding unique values in SQL.mp4

03:33

04 - UPPER, LOWER, and LENGTH in SQL.mp4

02:00

05 - Organizing Data

01 - Sorting data.mp4

04:21

02 - Grouping data.mp4

04:01

03 - Using a pivot table in SQL.mp4

03:26

04 - Subqueries in SQL.mp4

03:27

05 - Advanced subqueries in SQL.mp4

05:37

06 - Combining Data

01 - Using JOINs.mp4

03:22

02 - The different types of JOINs.mp4

05:05

03 - Using VLOOKUP, HLOOKUP, XLOOKUP in SQL.mp4

02:22

07 - Conclusion

01 - Taking your SQL skills to the next level.mp4

01:26

Exercise Files

Ex_Files_Excel_SQL.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Excel

James Parkin and Madecraft

Instructor's Courses

My name is James Parkin, and I help organizations to meet and exceed their goals. I am an accomplished, versatile, and articulate Senior Software Engineer with experience in IT application development and enhancement, cross-functional teams’ collaboration, and business process automation. I have well-developed skills in designing, testing, and updating digital solutions and recommending applications improvement/enhancements while completing deliverables within scope, time, and budget through the implementation of agile methodologies. I have demonstrated expertise in leading, mentoring, and developing skillful and dedicated teams, identifying and resolving problems at the initial stage to drive continuous improvement. I am an expert in developing and managing complex databases, conducting detailed data analysis, and implementing efficient programming methods. I have a proven track record of generating and maintaining technical reports, debugging advanced software programs, and overseeing and revitalizing workflow processes to accomplish strategic objectives. I am well-versed in adapting to rapidly evolving environments by cultivating productive relationships, thinking outside the box, and demonstrating flexibility and an innovative mindset. ★ Few highlights of my career are: ☛ I secured 250K downloads on the first day of the product launch by leading the software development team of five engineers on the design of BBC iPlayer using Microsoft Xbox 360 and Sony PlayStation. ☛ I reduced customer complaints by more than 90% and maximized the performance of the Lynda.com video player through updating software and reducing the total Lynda.com bug count from over 200 P1 issues down below 10 P1 issues. ☛ I delivered support to certify BBC TV iPlayer on over 30 devices while acting as a certification manager and technical contact. I am technically proficient in Java, C#.NET, and JavaScript and have experience working with other languages, including Actionscript, Flash, Silverlight, MHEG, and OpenTV. I have experience with software engineering practices, including Agile development, Test Driven Development (TDD), and Behaviour Driven Development (BDD). I also have experience with line management and recruitment. While others take pride in meeting all standards set before them, my passion is for delivering service that goes beyond organizational expectations. Connect with me today at [email protected] to find out how I’ll make your mission my mission, to help bring all of your business objectives into focus!

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.