by | Released July 2013 | ISBN: 0133442071

6+ Hours of Video InstructionOverviewHelping non-DBAs learn the critical skills they need to manage SQL ServersDescriptionSQL 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.About the InstructorEric Johnson (MCSE, MCDBA, MCSD, CCNP) is co-founder of Consortio Services, and the company's primary Database Technologies Consultant. His background in information technology is diverse—ranging from operating systems and hardware, specialized applications and development to a fair amount of work on networks. Since IT is really just a way to support business processes, he also acquired an MBA. In total, he has more than 15 years IT experience, with a good number of those dedicated to working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes and has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Most recently, he presented at TechMentor on SQL Server Replication, Reporting Services, and Integration Services. He also does a good deal of writing, including the four-part series "Tour de SQL" published in Redmondmagazine and the book A Developer's Guide to Data Modeling for SQL Server(Addison-Wesley, 2008). In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users' Group.Skill LevelBeginnerIntermediateTopics CoveredYou will obtain an understanding of SQL Server in order to produce better code for communicating with SQL Server.You will gain an understanding of crucial topics like indexing, query plans, and the execution cache.You will attain the basic skills and knowledge needed to maintain SQL Server.You will understand all the programmability objects in SQL Server and how the use of each is appropriate.You will secure an understanding of relational databases and how to go about accessing and storing data in a relational database.Who Should Take this Course?Any developer or admin who has been given the responsibility of managing SQL Server. Also a good study resource for IT professionals pursuing SQL Certification.Course RequirementsBasic IT SkillsTable of Contents:Introduction to SQL Server 2012 Fundamentals for the Accidental DBA LiveLessonsLesson 1 SQL Server Overview1.1 Understanding SQL Server1.2 SQL Server UsesLesson 2 The Tools2.1 SQL Server Management Studio2.2 Configuration Manager2.3 Profiler2.4 SQL Server Data ToolsLesson 3 Relational Database Basics3.1 Tables3.2 RelationshipsLesson 4 Understanding SQL Server Databases4.1 Database Files4.2 Transaction Log4.3 Understanding System DatabasesLesson 5 Server Configuration5.1 Basic SQL Server ConfigurationLesson 6 Backing Up SQL Server Database6.1 Backup Types6.2 Scheduling BackupsLesson 7 Restoring SQL Server Databases7.1 Restore Type7.2 Restoring System DatabasesLesson 8 Server Security8.1 Server SecurityLesson 9 Database Security9.1 Users9.2 Database Roles9.3 Ownership ChangingLesson 10 T-SQL10.1 Basic Data Manipulation Language10.2 Basic Data Definition LanguageLesson 11 Advanced Programmability11.1 Stored Procedures11.2 Functions11.3 Views11.4 Triggers11.5 CLR IntegrationLesson 12 Indexing12.1 Index Overview12.2 Working with Indexes12.3 Included ColumnsLesson 13 Application Security13.1 How to Set Up Security13.2 Understanding Abstraction LayersSummary of SQL Server 2012 Fundamentals for the Accidental DBA LiveLessonsLiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, VMware Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View All LiveLessons http://www.pearsonitcertification.com/imprint/series_detail.aspx?ser=2185116 Show and hide more

1. Introduction
   • Introduction to SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons 00:05:08
2. Lesson 1 SQL Server Overview
   • Learning objectives 00:00:37
   • 1.1 Understanding SQL Server 00:08:45
   • 1.2 SQL Server Uses 00:05:08
3. Lesson 2 The Tools
   • Learning objectives 00:00:32
   • 2.1 SQL Server Management Studio 00:09:55
   • 2.2 Configuration Manager 00:11:53
   • 2.3 Profiler 00:12:32
   • 2.4 SQL Server Data Tools 00:06:35
4. Lesson 3 Relational Database Basics
   • Learning objectives 00:00:42
   • 3.1 Tables 00:15:30
   • 3.2 Relationships 00:19:09
5. Lesson 4 Understanding SQL Server Databases
   • Learning objectives 00:00:35
   • 4.1 Database Files 00:14:51
   • 4.2 Transaction Log 00:11:02
   • 4.3 Understanding System Databases 00:11:37
6. Lesson 5 Server Configuration
   • Learning objectives 00:00:42
   • 5.1 Basic SQL Server Configuration 00:10:09
7. Lesson 6 Backing Up SQL Server Database
   • Learning objectives 00:00:44
   • 6.1 Backup Types 00:20:18
   • 6.2 Scheduling Backups 00:17:49
8. Lesson 7 Restoring SQL Server Databases
   • Learning objectives 00:00:28
   • 7.1 Restore Type 00:14:28
   • 7.2 Restoring System Databases 00:11:43
9. Lesson 8 Server Security
   • Learning objectives 00:00:38
   • 8.1 Server Security 00:11:42
10. Lesson 9 Database Security
    • Learning objectives 00:00:54
    • 9.1 Users 00:07:07
    • 9.2 Database Roles 00:09:34
    • 9.3 Ownership Changing 00:18:42
11. Lesson 10 T-SQL
    • Learning objectives 00:00:40
    • 10.1 Basic Data Manipulation Language 00:23:03
    • 10.2 Basic Data Definition Language 00:13:34
12. Lesson 11 Advanced Programmability
    • Learning objectives 00:00:39
    • 11.1 Stored Procedures 00:11:11
    • 11.2 Functions 00:12:32
    • 11.3 Views 00:09:25
    • 11.4 Triggers 00:17:33
    • 11.5 CLR Integration 00:07:11
13. Lesson 12 Indexing
    • Learning objectives 00:00:44
    • 12.1 Index Overview 00:07:59
    • 12.2 Working with Indexes 00:14:15
    • 12.3 Included Columns 00:05:11
14. Lesson 13 Application Security
    • Learning objectives 00:00:52
    • 13.1 How to Set Up Security 00:12:55
    • 13.2 Understanding Abstraction Layers 00:12:52
15. Summary
    • Summary of SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons 00:02:10
Show and hide more



9780133442076.sql.server.2012.OR.part1.rar

9780133442076.sql.server.2012.OR.part2.rar

9780133442076.sql.server.2012.OR.part3.rar