Author
Released
8/20/2015Note: This course will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals.
- Storing dates, times, and text
- Converting data types
- Creating tables
- Writing T-SQL commands
- Selecting records with queries
- Combining and sorting data
- Creating views
- Creating stored procedures and functions
- Inserting and updating data in a table
- Deleting records and tables
Skill Level Beginner
Duration
Views
- [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.
Related Courses
-
Database Foundations: Core Concepts
with Adam Wilbert2h 14m Beginner
-
Introduction
-
Welcome1m 18s
-
-
1. Defining Data Types
-
Storing date and time values4m 58s
-
2. Understanding Tables and How to Create Them
-
Defining your data needs1m 25s
-
-
3. Using Queries to Select Data
-
Sorting data with ORDER BY2m 21s
-
Using aggregate functions4m 18s
-
Solution: Making selections4m 22s
-
4. Working with Views
-
Solution: Creating a view2m 38s
-
5. Creating Stored Procedures and Functions
-
6. Inserting and Updating Data in a Table
-
Updating data in SSMS1m 40s
-
7. Removing Data from the Database
-
Deleting records in SSMS1m 16s
-
Using the DELETE statement2m 12s
-
Understanding transactions3m 27s
-
-
Conclusion
-
Next steps46s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome