Time
9 hours 41 minutes
Difficulty
Intermediate
CEU/CPE
10

Video Transcription

00:00
I welcome back to module one. This is less than 1.2 course flyover. And this lesson we're gonna take a look at the course outline at briefly discuss the various topics of the modules in this intermediate Sequel course.
00:13
So after this lesson, you'll be done with Module one and we'll get into module to which will be a quick review. This is just going to very quickly go over some concepts that should be familiar to you to get the ball rolling. Now, if these concepts are new to you, you probably want to take the beginner sequel, of course, so that you can really
00:33
iron down
00:34
those different joint types in those basic concepts before taking this intermediate course. Because we won't go too deep into the basics within this course, and then module three, the environment set up. We're gonna look at using vagrant and virtualization software to empower our development process.
00:52
The idea and this module is, too,
00:54
as a programmer slash developer to put you in a position where you can use virtualization to really empower yourself as a developer, we'll look at level tooling, database migrations and modeling with level
01:07
and in levels of PHP framer. But we'll get into that when we cross that module. It's very easy to go too deep into that. This is just a quick summary of the
01:15
different concepts will be going over.
01:18
Then, in Model four, we start intermediate database development. In one, we're going to review a document that describes an application that we need to build, and in this course that application is going to be a database that supports schools. And it's going to need to track teachers, students, grades and some other things as well.
01:37
We'll look at how we implement the models, the constraints, relationships in all that fun stuff.
01:42
Another interesting concept that we will cover in Module four is ceding the database, which is when we put out a bunch of test data in an automated fashion into our database so we can make thousands of tests records and then test our database to make sure everything functions the way we expected to. And that goes much faster than trying to manually create that
02:02
test data.
02:04
And it's much better than trying to give the application to your users to test, which you do see kind of often in this industry,
02:14
So moving on to Module five would continue the development process with intermediate database development to we're gonna look at various components of table such as indexes, clustered index composite keys as well as some other things as well.
02:28
Then in Module six, we're going to start intermediate sequel programming one. And that's where we're gonna take a much closer look at programming different sequel concepts. Some of this should be familiar, such as unions, table expressions and aggregation.
02:45
They'll be some challenges in this module to where you'll get a document that describes a challenge you need to meet. We, of course, have a video that goes along with that that shows you how to solve that challenge.
02:55
Then, in a Module seven, an intermediate sequel, programming to we continue the same trend. We take a close look at programming in the sequel language, and then we have four challenges to go over where, if you can get through all these challenges that you'll be in pretty good shape is a sequel programmer,
03:14
Then in Modulate will take a look at sequel optimization. Now sequel optimization is is a very interesting module. If you get good at sequel optimization. You will be a sequel programmer to be reckoned with. You'll be very good at it. So
03:30
what does that entail? What we're gonna look at? You know, we're started the basics. We're very briefly discussed how hardware impacts your performance.
03:36
Because sometimes if you're working with very old hardware, it's not going to matter how efficiently you write your program. It's just not going to run very fast.
03:46
We're gonna look at execution plans with Explain, which is a very powerful command in sequel or my sequel that allows you to see exactly how my sequel plans to execute your query. And you can use that to identify any significant problems and fix them
04:00
going to take a closer look at indexes were going to take a close look at full table on full index scans as well as partitions. And then there's four challenges related to that.
04:11
Then that brings us to Module nine review and Closing in Module, and I were just gonna review the concepts that we covered in the course. I'm gonna congratulate you for finishing the Intermediate Sequel course and kind of give you some advice of where to go from here. And also, once you finish this course, you should be Ah, pretty decent sequel. Programmer.
04:30
You shouldn't have any problems
04:31
doing basic development, writing complex queries and also optimizing. And what that said that completes this lesson. Let's get started, and I'll see you in the next lesson. 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