Lynda - Database Foundations: Creating and Manipulating Data

Lynda - Database Foundations: Creating and Manipulating Data

Brand new to database administration? Take it one step at a time with Database Fundamentals, a series designed to support a new career or lifelong journey in IT. This installment is devoted to data: getting it into and out of tables and databases. Adam Wilbert shows how to get the most out of each data type, including numbers, characters, and specialized types like spatial data. Next are queries. Learn how to write commands and invoke functions in the SQL Editor to select just the records you want. Finally, get comfortable inserting, updating, and deleting data with the SQL Server Management Studio (SSMS), a suite of graphical tools and rich editors that make working with databases much more intuitive. Do you want to test your knowledge? Watch the challenge videos to practice what you've learned along the way.

https://www.lynda.com/SQL-Server-tutorials/Database-Fundamentals-Creating-Manipulating-Data/385697-2.html

Introduction

1. Defining Data Types

2. Understanding Tables and How to Create Them

3. Using Queries to Select Data

4. Working with Views

5. Creating Stored Procedures and Functions

6. Inserting and Updating Data in a Table

7. Removing Data from the Database

Conclusion

Table of Contents

Would you like to be a Author?