Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

B&H # CLSQLSFADBA MFR # PE-019
Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

Show MoreLess

Close

Now Viewing:

Discontinued

Product Highlights

  • Instructor: Eric Johnson
Man Behind Layer

B&H $1000 Giveaway

Share your most-wanted item with friends & family for chances to win a $1000 B&H Gift Card. It's that easy!

1 new winner announced every week!
Limit 1 entry per day; Come back every day to increase your chance of winning!

Be sure to mention #BHWishList when you share!

Share on Twitter Share on Facebook

Congrats to our winners so far — Lauren K. & Daniel M.

Official Rules

OFFICIAL B&H $1,000.00 GIVEAWAY RULES

NO PURCHASE IS NECESSARY TO ENTER OR WIN. The B&H $1,000.00 Giveaway (the "Giveaway" or "Sweepstakes") is void where prohibited by law and is sponsored by B&H Foto & Electronics Corp., 440 Ninth Avenue, New York, NY 10001 ("Sponsor"). It is not sponsored or endorsed by Facebook or Twitter in any way.

Entry Period/Methods of Entry. The Sweepstakes will run from on or about November 7, 2016 until on or about December 19, 2016 (the "Entry Period"). Entries received outside the Entry Period are void. Enter the Sweepstakes via either one of the following methods. (1) Share your most wanted item on Facebook or Twitter via the dedicated links found on the B&H Website (www.bhphoto.com); or (2) Mail a postcard (postmarked during the Entry Period) containing your name, address, phone number, and email address, and indicate the subject(s), if any, about which you are interested in receiving future emails from B&H (e.g. photo, video, audio, computers, home theater, portable entertainment ) (optional) to: B&H $1,000.00 Giveaway, c/o B&H Foto & Electronics Corp., 440 Ninth Avenue, New York, NY 10001 (either option, an "Entry"). Entries must not, in the sole and absolute discretion of the Sponsor, contain obscene, provocative, defamatory, sexually explicit, or otherwise objectionable or inappropriate content. Entries deemed by Sponsor to be inappropriate will be disqualified. Entries owned by a third party, or the use of any trademarks, service marks, logos, brands, or products owned by a third-party are not acceptable for entry into the Sweepstakes. Limit 1 entry per person, per day.

Winner Selection/Prizes/Odds. The B&H Social Team will randomly select a winner from among all eligible entries every Monday during the Entry Period, for a total three (3) winners (each a "Winner"). Each Winner will receive a B&H Gift Card pre-valued in the amount of $1000.00. No cash or other substitutions will be offered. Winner selection is in the sole and absolute discretion of the B&H Social Team. Any taxes are the sole responsibility of the winner. Winners will be notified and receive their prize to the e-mail address associated with the account to which their Entry was posted or the email account provided with a mail-in entry. The odds of winning depend on the number of eligible entries received.

Identity of Winners/Eligible Participants. Winners will be identified by the e-mail account associated with the Facebook or Twitter account from which their Entry was submitted or the email account provided with a mail-in entry. An e-mail account holder shall mean the natural person assigned to such e-mail account by the internet access or online service provider or other organization responsible for assigning e-mail addresses for the domain associated with such e-mail account. Any issues regarding the identity of a Winner shall be resolved by Sponsor in its sole discretion. The Sweepstakes is only open to residents of the United States that are at least eighteen (18) years of age on their entry date and is not open to employees of Sponsor, their immediate family, any person domiciled with such employees, or any affiliates or subsidiaries of Sponsor.

Entry Ownership/Entrant Agreements. Entrants retain full ownership and copyrights to their Submission. However, by entering the Sweepstakes entrants grant Sponsor permission to use their Entries for promotional purposes on their respective social media channels with proper credit. Entrants also agree: (a) to be bound by these Official B&H $1,000.00 Giveaway Rules; (b) that any claims related to this Sweepstakes shall be resolved individually without resort to any form of class action and that awards, shall be limited to actual out-of-pocket costs incurred in entering the Sweepstakes, and shall not include incidental or consequential damages or attorneys fees; and (c) that any actual or perceived ambiguities in these rules shall be interpreted by Sponsor in their sole discretion.

Limitation of Liability/Sponsor Modification/Cancellation Rights/ Choice of Law/ Venue/ Winners List. Sponsor is not responsible for incomplete entries or for failure to receive entries due to technical failures or human error of any kind. Winners agree that Sponsor will have no responsibility for losses or damage of any kind resulting from the acceptance, possession, or use of the prizes. Except where prohibited, participation in the Sweepstakes constitutes entrant's consent to the publication of his or her name by Sponsor in any media for commercial or promotional purposes without limitation or further compensation subject to Sponsor's respective Privacy Policies. Sponsor may modify or discontinue the Sweepstakes at any time and may disqualify from the Sweepstakes any person it determines, in its sole discretion, to have attempted to or actually tampered with or otherwise abused any aspect of the Sweepstakes. Entrants agree that in the unlikely event a dispute arises in connection with this Sweepstakes, it will be governed by the laws of the State of New York and heard exclusively in a court of applicable jurisdiction in the County and State of New York irrespective of any choice of law provisions to the contrary. To receive names of the winners by U.S. mail, please mail a self-addressed stamped envelope to: B&H Foto & Electronics Corp., Attn: B&H $1,000.00 Giveaway, 440 Ninth Avenue, New York, NY 10001. Any Winners List request must be received by B&H within one (1) year of the date the Sweepstakes is conducted.

Let us know how to reach you if you win!

Privacy 100% guaranteed; email address for contact purposes only

Email

Already have a B&H account? Just log in tomorrow to enter again!

  • 1Description
The video download SQL Server Fundamentals for the Accidental DBA from Class on Demand is useful for power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. Instructor Eric Johnson shows you how to perform every essential DBA task with SQL Server 2005 and SQL Server 2008, even if you’ve never had any DBA training. You will learn at your own pace through realistic hands-on examples that walk you through every step. It covers topics from installation to backup/restore and indexing to scheduling to memory management.

Lessons (Run Time)

Section 1: SQL Server Overview (00:11:58)

Course Introduction (2:09)
Overview (1:35)
1: Understanding SQL Server (8:14)

Section 2: SQL Server Tools (00:48:40)

Learning Objectives (1:53)
2: Common Uses of SQL Server (4:29)
3: SQL Server Management Studio (16:50)
4: SQL Server Configuration Manager (9:34)
5: SQL Server Profiler (9:51)
6: Business Intelligence Development Studio (6:03)

Section 3: Relational Database Basics (00:24:09)

Learning Objectives (1:52)
7: Understanding Tables (11:57)
8: Understanding Relationships (10:20)

Section 4: Understanding SQL Server Databases (00:34:58)

Learning Objectives (1:42)
9: Database Files (14:19)
10: The Transaction Log (9:33)
11: Understanding System Databases (9:24)

Section 5: Server Configuration (00:11:42)

Learning Objectives (1:47)
12: Processor Settings (4:39)
13: Memory Settings (5:16)

Section 6: Backing Up SQL Server Databases (00:35:21)

Learning Objectives (1:49)
14: Backing Up Databases (16:22)
15: Scheduling Backups (17:10)

Section 7: Restoring SQL Server Databases (00:24:02)

Learning Objectives (1:39)
16: Restoring Databases (12:34)
17: Restoring System Databases (9:49)

Section 8: SQL Server Security (00:41:54)

Learning Objectives (1:58)
18: Managing Logins (13:28)
19: Database Users (5:54)
20: Database Roles (8:43)
21: Ownership Chaining (11:51)

Section 9: Transact-SQL Basics (00:41:01)

Learning Objectives (1:59)
22: Data Manipulation Language (24:48)
23: Data Definition Language (14:14)

Section 10: Advanced Programmability (00:56:13)

Learning Objectives (1:58)
24: Stored Procedures (9:47)
25: Functions (11:13)
26: Views (9:34)
27: Triggers (12:51)
28: CLR Integration (10:50)

Section 11: Indexing (00:28:33)

Learning Objectives (1:46)
29: Indexing Overview (7:31)
30: Working with Indexes (13:13)
31: Included Columns (6:03)

Section 12: Application Security (00:25:07)

Learning Objectives (1:52)
32: Application Security (11:19)
33: Abstraction Layers (11:56)

About the Presenter

Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is a co-founder of Consortio Services, and the primary Database Technologies Consultant. His background in information technology is diverse, ranging from operating systems and hardware to specialized applications and development. He has even done his fair share of work on networks and has also acquired his MBA. In his 10 years of experience with IT, a large amount of which has been working with Microsoft SQL Server, Eric has managed and designed databases of all shapes and sizes.

He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. He has also presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He also does a good deal of writing, including the recent four-part series, Tour de SQL, published in Redmond magazine. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users' Group.

Table of Contents
  • 1Description
Instructor Eric Johnson
Run Time 6:23:38

Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA Review

Be the first to review this item
See any errors on this page? Let us know.