Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
I welcome back to Module six Sequel in applications We are moving into lesson to excel on. This is sub Listen to point to what we're going to do in this lesson as actually prep our Excel for getting data from the my simple database and to prep it, we're actually going to need to install an O. D. B C driver.
00:19
Now an O. D. B C driver is a special type of driver that allows Windows to connect two different types of database. So naturally we need the my sequel O D B C drivers and ah, typically, the different
00:32
types of databases have different O. D B C drivers
00:36
that you will need to install.
00:38
So I'm at the my sequel download session for the oh DBC driver and A the U R l for this download will be in the material for this lesson as well. So look for there if you need help finding it with that said, I'm gonna go ahead and start the download.
00:57
Go ahead on and download the top one.
01:00
Actually, I think I'm gonna get the 64 bit.
01:04
No, thanks. Just start my download
01:07
just
01:11
and it didn't take too long at all.
01:15
Go ahead and open the file that I just downloaded.
01:22
You want to say Okay,
01:23
Next I accept the license agreement
01:27
next,
01:30
and I'm going to go with the typical set up type
01:34
and install
01:36
and click through the admin prompts with a yes
01:38
finish. We need to go into our oh DBC driver settings.
01:44
So if we open up the Windows 10 search problem prompt and just search for oh DBC
01:49
and sold the 64 bit version Something go there,
01:55
I'm going. Thio, go ahead and put it under the user D S n If you wanted to share it across users, you would of course, want to use the system d s in. But I'm just gonna use the user. One
02:05
click add.
02:07
Let's choose the my sequel. Oh, DBC ansi driver.
02:10
It's like to finish,
02:12
and here we type in our connection criteria.
02:15
So we're gonna type in what we've been using
02:19
local. My sequel.
02:24
Actually, we need to put this here.
02:29
I'll just say this is the local. My sequel
02:35
on type in your user name and password.
02:40
Go ahead and test.
02:45
Oh, I forgot a period
02:50
and test.
02:54
Okay, I was typing it in the wrong password. I have a ton of passwords. So occasionally I do that. So test
03:01
next thing successful,
03:05
we just connect to the axiomatic A database. Yes, we can. So we'll go ahead and select the axiomatic in database it. Okay,
03:12
And I'm gonna hit. Okay,
03:14
Okay.
03:15
And I'm gonna go ahead and close. Ex, actually, let's go in and check to see if it sees that connection
03:22
from other sources on ABC
03:29
on the local. My sequel. That's the one I just made.
03:32
And the next lesson we're gonna go ahead and connect to our my single database and connect to the schematic a database to be specific. We're gonna graft the results of that same query with that we used in the power bi I module. And we're gonna look at how to refresh that data as well from Excel, which is very useful
03:50
for a lot of business users. Because in my experience, I've found that a lot of business users really love excel,
03:57
and a lot of them are excited if you get them a data connection to excel that they can refresh their Selves while in excel. Anyways, that completes this lesson. And I hope to see you in the next. Thank you

Up Next

Introduction to SQL

This introductory SQL training teaches SQL core concepts that can be applied in professional environments. Once students complete this course, they will be able to query and interact with an SQL database, and know how to design database schemas.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor