About this course
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 course 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 youve 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 youll ever need.
Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is co-founder of Consortio Services, and the companys primary Database Technologies Consultant. 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.
What are the requirements?
- Basic IT Skills.
What am I going to get from this course?
- Over 47 lectures and 7 hours of content!
- ¢ Obtain an understanding of SQL Server in order to produce better code for communicating with SQL Server.
- ¢ Gain an understanding of crucial topics like indexing, query plans, and the execution cache.
- ¢ Attain the basic skills and knowledge needed to maintain SQL Server.
- ¢ Understand all the programmability objects in SQL Server and how the use of each is appropriate.
- ¢ Secure an understanding of relational databases and how to go about accessing and storing data in a relational database.
What is the target audience?
- 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.
