Time
9 hours 41 minutes
Difficulty
Intermediate
CEU/CPE
10

Video Transcription

00:00
I Welcome back to module six. This is less than 6.6 a que Matic A database. And this lesson, we're gonna stall the axiomatic a database with some sample data and for many of the remaining lessons were actually going to use the axiomatic a data base to program against.
00:15
And the reason we were going to do this is because axiomatic A is a very large professional e r P database.
00:21
So it provides a excellent playground for lots of practice with complicated reporting.
00:27
So let's go ahead and walk through these bullet points. We're going to use the provided database dump file to import so the import file will be provided.
00:35
You will want to look for that in the resource section.
00:38
When you create a new database in D beaver, you want to be sure to use the charset utf eight and before and the collation utf eight and before underscore Unicode on a score c I that deals with how the application is encoded.
00:52
And if you get that wrong, that can cause very strange airs occur sometimes depending on what the air is causing to occur.
01:00
Now again, the axiomatic A databases Ah professional Air P database. However, it is missing many of the foreign keys, which means to get used to the database, actually require some insider knowledge, or you need some experience with the application to understand how stuff is being stored. But you won't have to worry about that
01:18
in my challenges. And in my practice, I will always point out which tables in which objects we need.
01:23
And again, it's great for sequel programming practice. So let's go ahead and head over to the development environment and get that database imported.
01:32
I welcome back to the developer environment, so let's get started with that database installation. I'm also gonna describe an issue I encountered when trying to use the file from the introductory to sequel course.
01:44
So if I bring up the file,
01:47
I've already made that required changes, and this database file will be available for use in this course. I believe the change or the problem occurs because there's a difference between how my sequel on Windows behaves and how my sequel and Lennox Behaves
02:02
So and this dump axiomatic a DB from the introductory course.
02:07
There are instances in which
02:08
the reference a table that was previously created with a different casing and that causes it to fail when you try to run it on our current installation in the vagrant.
02:21
However, in this one, I ran through the file and I switched all occurrences from upper case to lower case so that it will run.
02:29
And that's the file we're going to use.
02:30
So be sure to use this file and not just the file from the in deduct introductory to sequel course.
02:38
So first, what we want to do is we want to right click on database, create new database. I'm just gonna call this a cume Attica
02:46
and I have the charge that correctly. But I'm gonna change the collation
02:50
to the Unicode variance
02:55
to this choice right here. Go ahead. Okay.
03:00
And then I'm going to just select around. I want to make sure this is set to my active database. This is important here. You definitely wanna make sure that you have that set. Because that's your active database is where d Beaver is going. Try going to try and run the script,
03:15
so I'm gonna go to tools, restore database,
03:19
click my little folder.
03:21
I'm going to select the file I need and I'm gonna go ahead and select Start,
03:25
and I'll fast forward to the end of this. This does take a little bit of time to complete on my set up. It takes about 2 to 3 minutes,
03:36
and that completes the installation. So let's go ahead and head over to the summary,
03:42
and that brings us to the 6.6 summary. So what do we do in this lesson? We installed a new database.
03:47
We detailed an issue in the database file while we went to that installation. That's something that you again don't have to worry about. With the file provided in this course. It would be an issue if you tried to use the file from the introductory course, though.
04:01
And again the last boat was This is already resolved in the provided file. So that completes this lesson, and I hope to see in the next Thank you

Up Next

Intermediate SQL

This free course introduces the student to intermediate concepts found in the implementation and application of Structured Query Language (SQL) within professional business environments.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor