Microsoft SQL Server 2012 Admin (70-462) Tutorials
Introduction / Course Overview
Subtitles of the Movie (Microsoft SQL Server 2012 Admin (70-462) / Introduction / Course Overview)
Now before we dive into the course, let's talk about what we're going to do here and I want to give you a little course overview so that you kind of know what to anticipate. I'll start off doing just a little bit about SQL Server History, nobody wants a history lesson. But you do need to understand where SQL Server came from, it will also make you look a little more knowledgeable around the water fountain at work. Then we'll talk about some of Microsoft's new SQL Server Certifications. Now keep in mind we're building this course kind of on the cutting edge here, we're, SQL Server 2012 has just been released and so we're jumping on it very quickly here to get this information to you. And Microsoft SQL Server Certification Program is, we already know there is going to be some New Certifications for SQL Server. I'll talk about those but we're probably going to see some more changes as well. So you need to check back to Microsoft's website later on by the time you see this. Now then we're going to talk about the improvements in SQL Server 2012, what's new here, where the enhancements have taken place and what the focus was. Then we'll talk about some of the essentials about SQL Server 2012, the different editions that are out there. Licensing Requirements and how there has been some changes there, then we'll talk about hardware and software requirements, installation options and those sorts of things. Then we'll talk about what's gone, what's been taken out of SQL Server and is no longer here, some things could be surprising, what some of those things are. Then we'll talk about installing SQL Server 2012 and some of the ups and downs and gotchas about that aspect of SQL Server 2012. And we'll talk about SQL Server Instances, the Configuration Manager, the Service Accounts and those sorts of things and get you up to speed on that stuff. Then from there we'll go into a few movies on SQL Server basics for those of you who are kind of moving into new territory here. We'll talk about just basics of understanding databases, tables, primary keys, data types, what normalization is, how to actually create a database here in this product. The database files themselves. We'll talk about transaction logs, schemas, synonyms all that sort of thing and then from there we'll jump into managing SQL Server 2012. And we'll talk about a lot of topics here, whether to use the, the Management Studio or Transact-SQL. We'll look at the graphical queries, authentication modes, linked servers. That sort of thing. Then we'll jump into automating SQL Server. We'll talk about the SQL Server Agent, then we'll talk about jobs, operators, schedules, alerts, just that whole thing. And we'll even talk about some maintenance plan, using the Wizard and using that really cool Design Tool that's in there. Then we'll jump in indexes, something that you really need to know to properly administer and tune SQL Server. We'll talk about Clustered Indexes, Non-Clustered Indexes, what needs to be indexed, how to know that. The Database Engine Tuning Adviser, lots of cool stuff about indexes. And then we'll move onto Performance Monitoring, some basics about monitoring SQL Server. The Dedicated Administrator Connection, using System Monitor, some of the other tools that are out there that you can use with SQL Server. The SQL Server Profiler and then we'll get into like Pages Extents, some really neat information about FillFactor that you need to understand. Then we'll jump on some security issues, principles, securables, understanding permissions, roles, those fixed server roles, the database level roles. And then we'll kind of close it out talking about Backup, Restore and Availability Options in SQL Server 2012. We're going to cover as you can tell a lot of information. You are going to get a good overview of SQL Server 2012 from an administrative standpoint. That's where we're headed so let's just jump in and get going.
Tutorial Information
| Course: | Microsoft SQL Server 2012 Admin (70-462) |
| Author: | Mark Long |
| SKU: | 34342 |
| ISBN: | 978-1-61866-048-0 |
| Release Date: | 2012-06-18 |
| Duration: | 9 hrs / 99 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
