Quantcast

Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

Exam 98-364: MTA: Database Fundamentals

Databases and the data they contain are crucial to every business and application out there today, which is why IT professionals with data-oriented skills are in constant demand! Whether you're looking to pick up basic SQL skills for data analysis or begin your journey to becoming a full-blown database engineer, this course is the starting line as it assumes no prior database or query experience, and will prepare you to delve deeper into the world of database platforms and certifications....
Databases and the data they contain are crucial to every business and application out there today, which is why IT professionals with data-oriented skills are in constant demand! Whether you're looking to pick up basic SQL skills for data analysis or begin your journey to becoming a full-blown database engineer, this course is the starting line as it assumes no prior database or query experience, and will prepare you to delve deeper into the world of database platforms and certifications.

This Database Fundamentals course introduces you to the basics of creating, querying, and administering databases. We cover core database concepts; relational database concepts; querying data using the SQL language; database objects such as tables, views and stored procedures; Microsoft's SQL Server database platform; working in graphical tools such as SQL Server Management Studio; and the basics of administering a database.

Recommended Experience
  • None
Recommended Equipment
  • None
Related Certifications
  • Microsoft Technology Associate (MTA)
Related Job Functions
  • Data analyst
  • Database administrator
  • Database developer
  • Database designer
  • SQL ninja


Garth Schulte has been a CBT Nuggets trainer since 2002 and has over 20 years experience as a database professional across a wide range of database roles and platforms. He holds many SQL Server certifications from SQL Server 7.0 to SQL Server 2014.
 show less
1. Welcome to Database Fundamentals (9 min)
2. Getting Started with Databases (15 min)
3. The Relational Database (19 min)
4. The SQL Language (26 min)
5. Lab: Creating a Database (7 min)
6. Creating Tables (24 min)
7. Lab: Working with Tables (16 min)
8. Writing Basic Queries (23 min)
9. Enhancing Queries with Conditions (23 min)
10. Modifying Data with Queries (16 min)
11. Lab: Working with SQL (25 min)
12. Normalization (16 min)
13. Keys & Constraints (21 min)
14. Indexes (14 min)
15. Writing Advanced Queries (18 min)
16. Lab: Designing a Database (12 min)
17. Creating Views (11 min)
18. Creating Stored Procedures (17 min)
19. Creating Functions (18 min)
20. Lab: Working with Database Objects (15 min)
21. Security (14 min)
22. Backup & Recovery (16 min)
23. Ongoing Maintenance (15 min)
24. Lab: Administering a Database (12 min)

Welcome to Database Fundamentals

00:00:00

Hey, hey, hey, welcome to database fundamentals. My name's Garth Schulte. I'll be your host throughout this course. We're going to put the fun in fundamentals. And we're going to learn all about databases and SQL, the structured query language, which is the language of love for relational databases.

00:00:17

We're going to kick this course off with an introductory Nugget to define what a database is, talk about what to expect out of this course, what you'll be learning and who it's for. And I'll get you familiar with our lab environment, the Virtual Nuggetlab.

00:00:28

Well let's jump in head first and get started. Now this course assumes absolutely no database experience, the fundamentals. So whether you're looking to become a database professional, maybe you want to be a DBA, a database administrator, or a database developer, an architect, or a data scientist or data analyst, this is the beginning of the road to all of those career paths.

00:00:48

So that's why we're going to start by answering that all important question, what is a database. A database by definition is a collection of data organized for rapid search and retrieval. Some key words there-- organized and rapid search and retrieval.

00:01:03

Let's start with physical databases. Can you think of any physical databases out there in the world today? What about a phone book? A phone book is a great example of a database, a lot of data inside of a phone book that contains individuals and their phone numbers.

00:01:15

And it's organized in a way that makes sense to us, right? It's organized alphabetically so we can easily find the general area where, if we're looking for something specific, where it lives. And then once we get there, again, we can find it pretty quickly.

00:01:28

But again, this is the physical world. Nothing's quick compared to the electronic world. But it's as good as it gets in the physical world. What about a library? There's another one, right? Lots of books inside of a library. And if you walk into a library and you're looking for something specific, how are you going to find it?

00:01:43

Are you going to go scan shelf by shelf? Well thankfully we would get there eventually because of the way the library is organized. But if you really wanted to get something fast, you'd probably use index cards to point you in the specific area or general area where that book might be.

00:01:57

And then you can start scanning from there. Again, both just examples of physical databases. And the key thing to take from that is that our data is organized in a way that makes it easy for us to find that data. Now in today's world, when you hear the word database, you're probably not thinking about phone books or libraries.

00:02:14

You're thinking about machines, computers with database software installed on them that host and manage all the data for an organization. Speaking of which, databases are the heart and soul, the lifeblood of every organization out there today, from ma and pa shops that store their information in Excel spreadsheets to small businesses that use desktop database software like Microsoft Access, to medium to large companies that need full blown relational database management systems like SQL Server to power all of their applications, to even enterprise style companies like the Googles and the Microsofts and the Facebooks of the world that store everybody's data, usually with home grown or open source distributed databases, databases that are spread across hundreds or thousands of machines.

00:02:56

So data is important. Databases are important. And data professionals at all levels are extremely important, because they're the ones that are managing all of this data. In fact, this has been a very popular field since the '70s when the SQL language was created and, really, the relational database took off.

00:03:13

And it's only going to get hotter as time goes on, especially with the advent of big data and that little acronym called IoT, Internet of Things, which means essentially everything is going to be connected to the internet, from our appliances to our automobiles to the clothes and shoes that we wear.

00:03:31

Seriously, it won't be long before shoes are connected to the internet and every step you take is generating data and getting stored in some database somewhere. Yeah, humanity's data footprint is growing exponentially every year. We're on this crazy banana curve, and we're going to need data professionals to manage all of this data.

00:03:48

And it's a great field to be a part of where there's a lot of opportunity, plenty of jobs, and they pay well. Let's take a look at the big picture to get a feeling for all the components and players involved with a database. Let's start at the top here with the database server.

00:04:01

So a database server is a machine with database software installed on it for creating, managing, and accessing the databases within. Another term for this software, and this software specifically here, MySQL, SQL Server, and PostgresSQL, is RDBMS, relational database management systems.

00:04:18

And if it's not relational, you'll see the R cut off. Then it will just be DBMS. RDBMSes come with a database engine and usually a suite of tools that we'll be using to create databases and work with the database objects and data within. Inside of an RDBMS is where we will be creating these databases.

00:04:35

And oftentimes you'll see a lot of databases packed onto one database server. Maybe we have departmental databases out there. HR needs a database. Marketing needs a database. Sales needs a database. Our products and services have applications that need databases.

00:04:48

So yeah, you'll see lots of databases packed onto a server more often than not. Inside of a database we have database objects. We have things like tables and views and stored procedures and functions. And these are all of the objects that database professionals like administrators and developers will be using to store the data as well as grant access to that stored data.

00:05:08

We will see how to create and work with all of these objects throughout the course. So a database is really just a container for our data and all of these database objects. And a relational database management system is a container for databases. And you're going to see a lot of common functionality across all of the relational database management systems out there.

00:05:26

And of course they all expose their own specific features and functionality as well. As I mentioned, SQL, the structured query language, is the language of love for relational database management systems. It's been around since the '70s, and it's wildly popular because it's standardized.

00:05:40

You'll learn it once and you can apply it to all RDBMSes out there, and it's extremely easy to learn. And it's used everywhere. Applications use it to pull data out of a database. Power users use it to write raw SQL queries to pull into their analytical tools such as Microsoft Excel for analysis.

00:05:56

And our database professionals, our developers and administrators, use it for both querying and to create these structures inside of the database. So we'll look at all those different layers of SQL-- DML, the data manipulation language for writing queries, and DDL, the data definition language for creating these objects.

00:06:12

So we're going to cover everything we just talked about and then some here in database fundamentals. On the right is our course outline. So each one of these is a Nugget. And right now we are at the very first Nugget, "Welcome to Database Fundamentals." We'll be covering core concepts, how to write queries with the SQL language, relational design concepts, creating and working with database objects, and the basics of database administration.

00:06:34

Now notice at the end of each one of these sections we have a lab. We're going to be utilizing the Virtual Nuggetlab-- more on that shortly-- to provide you with an environment that you can use to get some hands on experience. Certainly one of the best ways to learn databases, and especially the SQL language, is to get into them and write some queries.

00:06:52

So we'll be doing plenty of that here throughout the course. So this course assumes no prior experience with databases. It really is the starting line. Once you go through this course and get some basic database and SQL skills, then you can specialize and go down any role you wish.

00:07:06

And I should also mention, we are going to cover all the objectives for the MTA-- that's the Microsoft Technology Associate-- for database fundamentals. So if you want something to show for your learning efforts here in database fundamentals, check out that link.

00:07:20

That will give you more information about the MTA certification and the database fundamentals exam. This course has an associated Virtual Nuggetlab, which means you don't need your own database server and database software to learn SQL. We want to be able to just jump right in and start writing queries and learning SQL without having to worry about your environment.

00:07:39

So this Virtual Nuggetlab has one machine. Our database server here's name is SQLNUGGETLAB. It has Windows Server 2012 R2 installed. We'll be using SQL Server 2014 as our RDBMS. And we're going to be building together a database that's known as MusicDB.

00:07:55

This is going to be a great database to learn the fundamentals with, because it's fun. It's familiar. And it's simple. A lot of the sample databases that come packaged with RDBMS are really complex right out of the box. They're not very beginner friendly.

00:08:10

So that's why I chose something that's going to be a little more beginner friendly. And of course, we've got to make it fun. We're going to need to store information about artists, albums, genres, tracks, and playlists. And we're going to get to see how the relational aspect of databases plays out here, because artists create albums.

00:08:26

Albums can be of a genre. Albums contain tracks. And playlists can contain tracks that span albums. So it'll be great times creating, designing, loading it up with lots of data, and writing plenty of queries against our MusicDB in the Virtual Nuggetlab.

00:08:41

And by the way, you can access the Virtual Nuggetlab on the right hand side of the course page. In this CBT Nugget, I welcomed you to database fundamentals. Once again, welcome. Thank you for letting me be your guide. We're going have a lot of fun learning about the basics of databases and set you up for a good future in an awesome field.

00:08:57

I hope this has been informative for you and I'd like to thank you for viewing.

Getting Started with Databases

The Relational Database

The SQL Language

Lab: Creating a Database

Creating Tables

Lab: Working with Tables

Writing Basic Queries

Enhancing Queries with Conditions

Modifying Data with Queries

Lab: Working with SQL

Normalization

Keys & Constraints

Indexes

Writing Advanced Queries

Lab: Designing a Database

Creating Views

Creating Stored Procedures

Creating Functions

Lab: Working with Database Objects

Security

Backup & Recovery

Ongoing Maintenance

Lab: Administering a Database

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
Entry 7 hrs 24 videos

COURSE RATING

Training Features


Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Bookmarks
Included in this course
Pick up where you left off watching a video.

Notes
Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.
Garth Schulte
Nugget trainer since 2002