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. NT-campus
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.
Note: This tutorial will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals.
Note: This tutorial will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals.
Topics
include:
- 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
0 comments:
Post a Comment