Database Foundations: Creating and Manipulating Data

- [Voiceover] Hello, my name is Adam Wilbert and I'd like to welcome you to Database Fundamentals Creating and Manipulating Data. This is the second of four courses in the Database Fundamentals series where we'll ease you into the world of information technology. We're going to start with a deep dive into the various data types that can be assigned to your data columns and explore how to get the most out of each type. I'll walk you through the difference between an exact number and an approximate number, explore the various character data types, and even show you how to calculate the distance between two cities using the spatial data types.

Then, we're going to get into one of my favorite database topics, queries. We'll spend some time writing commands in the sequel editor in order to select out the exact subset of records that we're looking for. We'll see how to use aware clause to filter our data. We'll join multiple related tables together. And we'll use aggregate functions to provide further insight into the data that we're storing. Along the way, I'll provide some helpful tips to working with sequel server management studio as well as provide some insight into the way I work with databases through a couple of hands on challenges and solution movies.

If you're brand new to databases and are interested in finding out how to begin working with databases in your own organization, then this is the series for you. We'll take it one step at a time to make sure that you've got a solid foundation that will support a life long journey in IT. Now, let's get started.