Transcript Brian Alderman | MCT, CEO / Founder of

Brian Alderman | MCT, CEO / Founder of MicroTechPoint
Pete Harris | Microsoft Senior Content Publisher
Industry-recognized consultant
Noted author and conference speaker
Brian’s expertise and designs range across Microsoft
operating systems
Brian has been focused on helping IT Pros and Database Administrators (DBAs) better
understand core Microsoft technologies for over 25 years.
A frequent presenter at SharePoint Conferences around the world, he has authored or
contributed to several SharePoint, SQL Server, and other technical books, and is a MCSE, MCT,
and MCITP: SharePoint and SQL Server Administrator.
Brian has a BS and MS in Computer Information Systems where he graduated summa cum laude
from Regis University of Colorado Springs and lives in Scottsdale, AZ where he enjoys playing
golf year round and traveling around the world.
Content Development Manager in Microsoft’s
Learning Experiences team
Focuses on SQL Server and Web training
With Microsoft since 1995
Part of the first team of developer training folks in the post-Microsoft
University era
Has built a variety of content and spoken to customers all over the world
Database Fundamentals
01 | Introducing core database concepts (50 minutes)
Define databases, example of relational database tables, and introduce common database terminology
02 | Relational Concepts (50 minutes)
Normalization, referential integrity, and constraints
03 | Creating databases and database objects (50 minutes)
Data types, database objects, DDL statements, and creating scripts
04 | Using DML statements (50 minutes)
DML statements, using the SELECT statement; using INSERT, UPDATE, and DELETE to manage data; indexes and triggers
05 | SQL Server Administration Fundamentals (50 minutes)
SQL Server security; securing database and objects; performing database backups and database restores
03 | Creating Databases and Database
Objects
Brian Alderman | MCT, CEO / Founder of MicroTechPoint
Pete Harris | Microsoft Senior Content Publisher
Data Type
Use/Description
Storage Size
Money
Monetary or currency values -922,337,203,685,477.5808 to
922,337,203,685,477.5807
8 bytes
Int
Integer data from -2^31 (-2,147,483,648) to 2^31-1
(2,147,483,647)
4 bytes
Float
Approximate number - 1.79E+308 to -2.23E-308, 0 and 2.23E308 to 1.79E+308
Depends on the
value of n
Datetime
Date Range January 1, 1753, through December 31, 9999
Time Range 00:00:00 through 23:59:59.997
8 bytes
Char
Fixed-length, non-Unicode string data. Can be a value from 1
through 8,000
n bytes
Varchar
Variable-length non-Unicode string. Can be a value from 1
through 8,000
Actual length +
2 bytes
Bit
Integer with a value of 0 or 1.
1 byte for every
8 bit columns
Datetimeoffset
Date range January 1,1 A.D. through December 31, 9999 A.D.
Time range 00:00:00 through 23:59:59.9999999
Time zone offset range -14:00 through +14:00
10 Bytes
EmployeeID
LastName
FirstName
Department
100
Smith
Bob
IT
101
Jones
Susan
Marketing
102
Adams
John
Finance
©2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Office, Azure, System Center, Dynamics and other product names are or may be registered trademarks and/or trademarks in
the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because
Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information
provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.