2013
Addison-Wesley Professional
Eric Johnson
6:52
English

SQL Server is installed behind many third-party applications and behind Microsoft development tools such as Visual Studio. System administrators and developers alike are increasingly responsible for working with and managing SQL Server with no prior exposure or background. Further, they need to understand the basics of relational databases and technologies such as indexing and stored procedures to effectively develop applications. This video covers SQL Server from their perspectives and gives them what they need to manage these instances.
SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons is for power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. In it, SQL Server MVP Eric Johnson shows you how to perform the essential DBA tasks with SQL Server 2012, even if you’ve never had any DBA training. In these lessons, you will learn at your own pace through realistic hands-on examples that walk you through every step. If you are an accidental DBA—out of the blue expected to run Microsoft SQL Server efficiently, reliably, and securely—when nobody ever taught you how, then this is the video for you. From installation to backup/restore, indexing to scheduling to memory management, you get all the personal, practical DBA training you’ll ever need.

Introduction to SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons
Lesson 1 SQL Server Overview
1.1 Understanding SQL Server
1.2 SQL Server Uses
Lesson 2 The Tools
2.1 SQL Server Management Studio
2.2 Configuration Manager
2.3 Profiler
2.4 SQL Server Data Tools
Lesson 3 Relational Database Basics
3.1 Tables
3.2 Relationships
Lesson 4 Understanding SQL Server Databases
4.1 Database Files
4.2 Transaction Log
4.3 Understanding System Databases
Lesson 5 Server Configuration
5.1 Basic SQL Server Configuration
Lesson 6 Backing Up SQL Server Database
6.1 Backup Types
6.2 Scheduling Backups
Lesson 7 Restoring SQL Server Databases
7.1 Restore Type
7.2 Restoring System Databases
Lesson 8 Server Security
8.1 Server Security
Lesson 9 Database Security
9.1 Users
9.2 Database Roles
9.3 Ownership Changing
Lesson 10 T-SQL
10.1 Basic Data Manipulation Language
10.2 Basic Data Definition Language
Lesson 11 Advanced Programmability
11.1 Stored Procedures
11.2 Functions
11.3 Views
11.4 Triggers
11.5 CLR Integration
Lesson 12 Indexing
12.1 Index Overview
12.2 Working with Indexes
12.3 Included Columns
Lesson 13 Application Security
13.1 How to Set Up Security
13.2 Understanding Abstraction Layers
Summary of SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons

awprofessional.com, informit.com/store/sql-server-2012-fundamentals-for-the-accidental-dba-9780321934581

Download File Size:1.47 GB

---