[caption id="attachment_1273" align="alignright" width="300" class=" "] Microsoft System Center Configuration Manager SCCM 2012[/caption] Автор: Производитель: CBT Nuggets Год выпуска: 2013 Продолжительность: 10:42:55 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: This Microsoft video training course with Greg Shields covers how create a private cloud with the latest version of Microsoft System Center, including how to install and configure VMM 2012, automating the deployment of Hyper-V hosts, and more. Related Area of Expertise: Microsoft System Center Recommended skills: Experience with Windows Server, Active Directory, System Center 2012, security, high availability, fault tolerance, and networking in an enterprise environment Basic knowledge of Microsoft SQL Server and Windows PowerShell Familiarity with with ITIL and MOF concepts Recommended equipment: Microsoft System Center 2012 Related certifications: MCSE: Private Cloud Related job functions: IT professionals In a world of confusion about cloud computing’s technologies, techniques, and reason for being, it takes a lot of guts for Microsoft to include a button marked “Create Cloud” in System Center Virtual Machine Manager 2012. With so many people still trying to figure out what cloud means, the clever developers at Microsoft can now simply say, “Hey, we’ve got a button for that!” That button might be a bold move for Microsoft, but clicking it isn’t something to be taken lightly. Before you ever consider that click, you’ve got to build Hyper-V hosts. You’ll need a storage and network fabric among those hosts. You might even need shared storage if clustering, automatic failover, and load balancing are your requirements. Indeed, that button might seem simple, but there’re a lot of configurations that require attention first. In this course, Greg Shields walks you through the technologies that get your Microsoft Private Cloud operational. He helps you with learning the topics and technologies you need for success on the first of two MCSE: Private Cloud exams, the 70-247. But he doesn’t stop there. He digs deep into the reasons why the Microsoft Private Cloud is the next step in virtualization. You’ll learn how Microsoft’s System Center 2012 components like Virtual Machine Manager, Server App-V, App Controller, Operations Manager, Service Manager, and even Data Protection Manager integrate to automate everything in IT service delivery. You’ll construct complex IT services, made of virtualized applications, web applications, and databases, and configure them for self-service delivery by others in IT. Configuring and deploying a Microsoft Private Cloud with System Center 2012 isn’t a task to be taken lightly. It takes up-front effort to build the proper automations and craft the right experience for self-serving users. And the reward? What you’ll get is near-complete automation for everything that makes up your Windows server operating environment. So, consider joining Greg in this MCSE and Private Cloud exploration. There’s effort involved, but you won’t be sorry when all that IT scut work suddenly becomes smooth automation. [wpspoiler name="Подробное описание" ] 1. Introduction to System Center 2012, VMM 2012, and the 70-247 Exam (00:27:41) A Microsoft Private Cloud has Hyper-V as its foundation, but the MCSE: Private Cloud focuses little on Hyper-V itself. The exam’s focus is instead on System Center 2012, and most specifically VMM 2012. But don’t fret if you’re still a Hyper-V neophyte. Nearly all of Hyper-V’s activities are entirely manageable inside VMM these days. What you need is an introduction to Microsoft’s Private Cloud mindset and supporting System Center solutions. Get that and more in this introductory Nugget. 2. Understanding the Microsoft Private Cloud Architecture and Components (00:13:58) Eight individual components make up the System Center 2012 portfolio. You’ll need experience in at least seven of them to pass the MCSE Private Cloud. You’ll also need that experience to truly appreciate Microsoft’s vision in delivering IT services. Greg gets you started in this Nugget as he whiteboards the entire solution set and accelerates your understanding of System Center’s place in Windows and Microsoft Private Cloud management. 3. Installing and Configuring Hyper-V on Windows Server 2008 R2 (00:37:07) What? We’re not starting with Hyper-V on Windows Server 2012? What gives? Due to differences in the delivery schedules for Windows Server and System Center, VMM 2012 RTM only supports Hyper-V v2 on Windows Server 2008 R2. It isn’t until SP1 where Windows Server 2012 support gets added. Notwithstanding, most environments these days are still running Microsoft’s immediately-previous server OS. Not to worry: This is our only Nugget where we spend time in Hyper-V itself. Everything else happens inside System Center. In this Nugget, Greg will share his experience in preparing Hyper-V hosts for System Center management. You’ll get the exam info, but also the best practices in configuring Hyper-V hosts for best availability and performance. 4. Installing and Configuring VMM 2012 (00:49:40) Our first activity in System Center is merely getting VMM 2012 installed. That’s an activity that requires a few prerequisites, as well as a few preparatory activities. Don’t waste time tracking down the TechNet minutiae of requirements. Get started fast by joining Greg in this installation and initial configuration. 5. Configuring the Network and Storage Fabric (00:28:10) For the new Hyper-V admin, VMM’s “fabric” concept is going to seem a bit cumbersome. One can’t create a Private Cloud without it, and configuring its network and storage components might seem like extra work. But there are reasons for the fabric’s existence. Learn the right (and wrong) ways to build your own fabric with Greg in this incredibly important pre-cloud Nugget. 6. Clustering Hyper-V Hosts and Creating a Microsoft Private Cloud (00:32:27) Your Private Cloud doesn’t necessarily require a Windows Failover Cluster, but yours might really want one. High availability and VM load balancing all require a cluster if they’re to protect your VMs. It is for those reasons that our entire Private Cloud build centers around standing up a Hyper-V host cluster. That’s not an easy task, even with VMM’s new built-in automations. Learn how best to cluster, and how to create your own highly-available Private Cloud in this Nugget. 7. Working with the VMM 2012 Library: Profiles and VM Templates (00:39:22) Creating that Private Cloud is great, but it is merely the first step in assembling the building blocks you’ll need to automate your IT operations. Being smart in managing your Private Cloud means laying down the myriad of constituent components your Private Cloud services will eventually need. Those components include items in the VMM library like OS Profiles, Hardware Profiles, and VM Templates, among other things. Spend plenty of quality time with this Nugget, because your success here will determine everything about your automation success in the Nuggets to come. 8. Configuring VMM User Roles and the Self-Service Portal (00:22:43) Get this: VMM’s Self-Service Portal is in fact deprecated in this version! Then why are we spending any time with it? Well, you’ve got to know it for the MCSE, and it in fact, is a great starting point for our Private Cloud exploration of self-service. You’ll get a chance to see it in this Nugget. Those self-serving activities require some high-quality roles and permissions too. That knowledge Greg also shares in this quick Nugget. 9. Creating Virtual Application Packages with the Server App-V Sequencer (00:30:07) Heard of App-V? How about Server App-V? These two solutions have similarly-sounding names, but they are in fact quite different when you peel away the layers. Server App-V, as you can expect, is designed to deliver application packages to… servers! It’s also a built-in feature of VMM 2012 that many admins have missed entirely. Save yourself days of research, time, and effort. Learn the foundations of creating your own Server App-V packages in this art-and-science Nugget. You won’t get this kind of surprisingly-important training anywhere else. 10. Working with VMM 2012 Services and Service Templates (00:25:41) VMM 2012 can provision virtual machines just like its previous versions, but VMM 2012 takes VM management to an entirely new level with Services and Service Templates. Using a VMM Service Template, you can automatically deploy a VM, its needed applications, any further configurations, and everything else that VM needs to be ready for production. But the hard part is in the Service Template Designer, an entirely new tool that takes getting used to. Greg shares his experience in this useful Nugget. 11. Automating the Private Cloud Deployment of a Three-Tier Service (00:58:05) This Nugget is our capstone, and the learning you get here hasn’t been replicated anywhere else. Go ahead! Search around on the internet for a complete, start-to-finish explanation of how to deploy a multiple-tier VMM 2012 Service that mimics something you’d do in real life. Greg tells us he spent more hours – four full days, three to prepare and one to film – on this single Nugget than any other in any CBTN course he has created. You’ll need to watch it to understand why. Once you do, you’ll share in his awestruck realization of how powerful VMM 2012 can really be. Discover how to create complete automation for your IT services in this unprecedented hour-long Nugget with Greg Shields. 12. Managing Fabric Updates in VMM 2012 (00:20:29) Deploying an IT service is one thing, but after that deployment come the daily care-and-feeding drudgery of maintaining those services. Those updates might seem extra challenging when you realize that Hyper-V is an OS in an OS. Windows requires patches, which means Windows Hyper-V hosts require them too. Greg shows you how to automate the process (almost) entirely by linking WSUS with VMM in this Nugget. 13. Automating the Deployment of Hyper-V Hosts (00:22:03) VMM can automatically deploy VMs. It can deploy applications. It can even deploy SQL DAC packages and scripts. But get this: it can also deliver entire Hyper-V hosts, if you’ve got the hardware and the technical chops. Boot your Hyper-V hosts from VHDs and continue adding automation with what you learn in this bare-metal Nugget. 14. Installing and Configuring App Controller (00:18:51) Fourteen Nuggets later and we’re finally getting around to an actual self-service solution (that isn’t deprecated). That’s on purpose, because the administrator’s job in System Center and VMM 2012 is all about creating and managing the building blocks. Once prepared for prime time delivery, then those components be exposed for others in IT to self-service their needs. System Center 2012’s tool to accomplish this is App Controller. You’ll be excited to see how it works. 15. Integrating Private Cloud Monitoring with Operations Manager 2012 (00:52:21) With a constructed and self-servable Private Cloud now in operations, you’re ready to add in the rest of System Center’s functionality. You’re also ready for the set of MCSE test questions that focus on “the rest” of System Center’s components. Monitoring your Private Cloud is a task for Operations Manager. Integrating it with VMM and getting alerted on your Private Cloud’s behaviors is the topic of this Nugget. 16. Integrating Service Manager 2012 (00:24:04) With monitoring set up, your next task centers on managing requests. System Center Service Manager is your tool for request management and further service automation. With Service Manager 2012 in place, an environment can take a user request through all its approvals through to delivery. Discover the steps in integrating this key solution into your workflow in this Nugget. 17. Incorporating Orchestrator 2012 Runbooks and Integration Packs into Service Delivery (00:52:48) Building the building blocks is indeed a primary task for the VMM 2012 systems administrator. But sometimes a fully-automated service requires attention from datacenter components that exist outside VMM. It’s here that System Center Orchestrator becomes the administrator’s (and developer’s) best friend. In this Nugget, Greg will share his experience in creating Orchestrator runbooks and deploying Integration Packs for even greater automation flexibility in managing your Private Cloud. 18. Protecting Private Cloud Data with Data Protection Manager 2012 (00:28:50) Backups are arguably the administrator’s most important job. With the wrong tools, they’re also one of the hardest and least enjoyable jobs as well. This is one activity you can’t screw up, which is why Data Protection Manager 2012 now even more tightly integrates with VMM. Learn how to protect your data, your VMs, and your applications and services in this Nugget. 19. Working with VMM 2012 SP1 and Hyper-V v3 in Windows Server 2012 (00:28:13) You’ll notice as you’re watching this course that only once has our learning been directly on Hyper-V technology. That obfuscation is on purpose, partially because it mirrors what you need to know for the MCSE and partially because Hyper-V these days can almost be managed like an “appliance." VMM 2012 SP1 adds support for Hyper-V v3 atop Windows Server 2012 as well as an entirely new Windows management experience. Life doesn’t change in System Center but it does in Windows Server, so this Nugget gets you started down the path of Hyper-V v3 success as you configure Windows Server 2012. 20. Extending VMM into the Windows Azure Public Cloud (00:30:15) Microsoft Private Cloud, meet Microsoft Public Cloud! Say hello to Windows Azure, a solution ready to support your virtual machines in the cloud. A second new feature of VMM 2012 SP1 is the near-seamless integration of VMM and Windows Azure: VMM offers the management tools, Azure provides the cloud resources. Not every environment might need those resources, but more are every day. Get burstability and near-unlimited expandability for your IT needs with the knowledge you’ll learn in extending VMM onto Windows Azure. [/wpspoiler]

[caption id="attachment_1273" align="alignright" width="300" class=" "] Microsoft System Center Configuration Manager SCCM 2012[/caption] Автор: Производитель: VCT Год выпуска: 2013 Продолжительность: 10:31:28 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: This System Center video training with Greg Shields covers how to manage the infrastructure of Microsoft’s latest version of Windows, through topics such as deploying ConfigMgr clients and managing client settings, and more. Related Area of Expertise: Microsoft System Center Recommended skills: Experience working with System Center Configuration Manager 2012, Windows Server, security, and networking experience in an enterprise environment Basic knowledge of Microsoft SQL Server and Windows PowerShell knowledge, mobile device management, and application configuration One to three years of experience supporting multiple desktop and server computers running the Windows Server OS in medium to large organizations Recommended equipment: Microsoft System Center 2012 Configuration Manager Related certifications: MCTS: Administering and Deploying System Center 2012 Configuration Manager Related job functions: IT professionals How do you manage a Windows infrastructure? Installing applications by walking around is so 1990. Automation is the name of today’s game, and nothing spells Windows automation like System Center Configuration Manager. Automation has been called the Windows Administrator’s force multiplier. With the right tools, it enables a well-prepared administrator to monitor and enact change to exactly the right devices at exactly the right time. Prepping you to use those tools and wield that incredible power is the reason behind this video course. This course delivers a broad and deep exposure into Microsoft’s ConfigMgr 2012. Greg has been working with ConfigMgr since its early days as SMS 2.0. Throughout the years, he has developed a second sense for managing Windows desktops and servers with this powerful toolkit. He shares from his personal experience in this course to deliver not only the science (what buttons to click), but also the art (why you should click them) of managing a Windows infrastructure with ConfigMgr 2012. You’ll learn how to package and deploy software and virtual applications, as well as how to automate everything from individual configurations to entire OS deployments. You’ll learn the foundations of what you need to know for certification success, but you’ll also learn a few ConfigMgr best practices the consultants rarely share. In a Windows world where clicking Next, Next, Finish is no longer good enough. Smart IT professionals know that automation savvy is key to guaranteed employment. Join Greg in this ConfigMgr 2012 course and deep dive to develop exactly those skills that’ll make you the Most Valuable Professional of your own IT organization. [wpspoiler name="Подробное описание" ] 1. Introduction to System Center 2012, ConfigMgr 2012, and the 70-243 Exam (00:17:14) ConfigMgr 2012 is but one of the eight products that comprise Microsoft’s System Center portfolio. It is also one of the oldest, and potentially the most powerful. Kick off your training by understanding what you’ll need to know for this course and taking that 70-243 exam. 2. Understanding the ConfigMgr Architecture and Components (00:13:38) With an understanding of ConfigMgr’s fit as a product, your next task is to understand how its various functions interrelate. ConfigMgr has been around since 1994, making it an extremely mature and full-featured solution. All those functions can also make it a bit overwhelming for the newbie ConfigMgr administrator. Join Greg in this high-level introduction of ConfigMgr’s architecture and components and leave with a better understanding of the solution you’re about to learn. 3. Preparing for and Installing ConfigMgr 2012 (00:40:36) Every good product starts with an installation, and ConfigMgr is no different. While installing the ConfigMgr product is a task that’s far easier today than in previous versions, there are still a few prerequisites and gotchas you’ll need to know. Get those, and get started quickly in this Nugget. 4. Setting Boundaries and Enabling Discovery Methods (00:25:10) With an installed and functioning ConfigMgr site and site server, your next task involves setting the boundaries for management and enabling ConfigMgr’s various discovery methods. Doing so seems trivial, but a wrong move here could have huge impacts down the road. Greg shares the click-by-click and the best practices in this Nugget. 5. Deploying ConfigMgr Clients and Managing Client Settings (00:38:27) One of ConfigMgr’s most difficult tasks is client management, making sure clients exist where they should (and don’t where they shouldn’t). This task was a nightmarish chore in previous ConfigMgr versions, and gets only a bit better in this one. In this Nugget, Greg delivers the step-by-step to get clients delivered effectively, and shares a few key suggestions for configuring their settings to get the best experience. 6. Collecting Inventory and Creating Simple Collections (00:29:03) Data in a ConfigMgr system is gathered through what is really a two-step process. The first step often involves discovery information. That process brings data to ConfigMgr that can then be used in the second process: Inventory. Gathering inventory and using that data to create simple collections is the topic in this Nugget. 7. Constructing Queries and Building Query-based Collections (00:35:51) Another of the sometimes-incredibly challenging activities in ConfigMgr is creating queries and query-based collections. At fault is ConfigMgr’s interface, which even in this version is far from beginner-friendly. But coming to the rescue are a few tricks involving SQL Views that make performing this task far easier. Greg shows you how, and shares a few of his lessons learned in this Nugget. 8. Creating and Managing Reports (00:24:17) Just when you thought you had queries, WQL, and the ConfigMgr console figured out, you realize that creating reports requires an entirely new skill set. Reports in ConfigMgr 2012 can be ridiculously customized, if you know what you’re doing. Learn how in this Nugget. 9. Packaging Software for Local Installation and Application Virtualization (00:30:21) Take a look through Microsoft’s ConfigMgr documentation and nowhere will you ever find help in packaging software. That’s the process that “quiets” an installation, enabling it to execute automatically. That said, experience in packaging software for installation or App-V virtualization is the first step in any software deployment. Greg’s been packaging software for over a decade, and in this CBT Nuggets “Special Edition” Nugget he shares the tips and tools you’ll need to perform this task successfully. 10. Software Distribution the Old Way: Packages and Programs (00:42:16) Armed with a silenced software package, you’re ready to deploy applications anywhere with a ConfigMgr client. All you need is a little help in creating Packages and Programs. Technically, the Packages and Programs method is ConfigMgr 2012’s “old way," but you’ll need the steps here if you’re ever to be successful with deploying the “new way” with Applications. Kick off your learning with this deep dive on the fundamentals of distributing software. 11. Software Distribution the New Way: Applications! (00:49:55) One of ConfigMgr 2012’s new features is an entirely new user-centric application deployment model that Microsoft calls: Applications! Designed around delivering apps to users (as opposed to computers in the Packages and Programs approach), this new approach revolutionizes how we connect users with their applications and data. That said, being successful here requires extra effort and smart thinking. Greg got you started in that last Nugget, and finishes the job in this one. You’ll never walk around with DVDs ever again. 12. Deploying Operating Systems (01:06:30) Deploying an application? No problem. But an entire OS? Also no problem with the help of ConfigMgr. In this critically important Nugget, you’ll learn about User State Migration Tool (USMT), ConfigMgr Task Sequences, along with all the necessary skills you need to deploy operating systems. Better yet, Greg will share a few key tricks you can implement immediately that will enable users to refresh their own computers. Who knows? With a bit of up-front effort, you could realistically create a situation where you’ll never need to troubleshoot desktop problems again. Don’t believe it? Watch this Nugget to find out how. 13. Deploying Software Updates (00:39:40) You’ve mastered WSUS, but how confident are you in the WSUS reporting engine? Reporting on patching success means delivering the right metrics for all the right computers. Software updates in ConfigMgr 2012 gain some major improvements that make this upgrade worth the effort, like Automatic Deployment Rules that eliminate the scut work in patch deployment and updated reports that prove your compliance. Learn about all these and more in this Nugget. 14. Deploying and Managing Compliance Baselines (00:25:39) With software, operating systems, and updates under your belt, you’re almost ready for complete automation. One final step remains: Controlling configurations. ConfigMgr 2007’s DCM was a feature worth overlooking. No more with Compliance Baselines in ConfigMgr 2012. In this all-important Nugget, Greg shows you exactly how important this new feature can be for completely automating your Windows administration. You’ll learn how to find the configurations worth controlling, and how to build your own compliance settings to keep every application in check. 15. Metering Software Usage (00:09:43) Every IT environment has “those apps," those you know haven’t been used in years even though you’re still responsible for them. Not to mention “those users," the ones who demand certain expensive applications that they rarely use. It’s hard to prove them wrong, or at least it used to be before ConfigMgr Metering Rules. With ConfigMgr Metering Rules you can measure exactly how many minutes a month “those apps” get used and “those users” use them. Save your company money, and pay for your ConfigMgr investment with just a single feature by watching this Nugget. 16. Managing Forefront Endpoint Protection Settings (00:14:44) ConfigMgr 2012 merges with Microsoft Forefront in this version to deliver comprehensive endpoint security. With a separate license and a few extra steps, you’ll be protecting your clients and managing their configurations – all from the same comfortable instance. Greg shows you all the setup, as well as the ongoing management in this Nugget. 17. Managing Mobile Devices and Securing Client Communication (00:51:16) Every so often a Nugget gets released that pays for your entire training. This could be that Nugget. Configuring HTTPS client communication and mutual authentication isn’t a task taken lightly. Back in ConfigMgr 2007 it was called “Native Mode," and almost everyone ignored it. Complete client security and complete mobile device management are back in 2012, but they’re no less challenging to implement. Learn the exact step-by-step to secure your client communication and enable mobile device management in this not-to-be-missed Nugget. 18. Monitoring and Managing Site and Client Status (00:26:46) Every Nugget training course has its “miscellaneous” topic. While no less important, Greg collects a variety of site and client management and monitoring topics into this kitchen sink Nugget. In it he explains working with alerts, power management, remote control settings, site, component, and client status, site maintenance tasks, backups, and Wake on LAN settings. Like any good server, ConfigMgr requires regular care and feeding. Getting that done right is the topic for this Nugget. 19. Implementing ConfigMgr Role-based Security (00:15:15) ConfigMgr 2007’s security model was AMPITA – A Major Pain in the Administrator. Delegating permissions to administrators in 2012 gets better…just a bit. Greg gives you the shortcuts you need to set permissions successfully in this Nugget. 20. Planning and Implementing a ConfigMgr Site Hierarchy (00:35:07) Nineteen videos later and your ConfigMgr experience is nearly complete. Yet there’s one last topic that you absolutely can’t miss. So far, you’ve been working in a single-server and single-site environment. That architecture can’t scale. Creating one that can requires a bit of extra thinking. Don’t make the easy mistakes in extending your environment past one server and site. Join Greg in this 20th and final video to get the smart strategies for implementing your ConfigMgr site hierarchy. [/wpspoiler]

[caption id="attachment_1273" align="alignright" width="300" class=" "] Microsoft System Center Configuration Manager SCCM 2012[/caption] Автор: Производитель: CBT Nuggets Год выпуска: 2013 Продолжительность: 10:31:28 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: This System Center video training with Greg Shields covers how to manage the infrastructure of Microsoft’s latest version of Windows, through topics such as deploying ConfigMgr clients and managing client settings, and more. Related Area of Expertise: Microsoft System Center Recommended skills: Experience working with System Center Configuration Manager 2012, Windows Server, security, and networking experience in an enterprise environment Basic knowledge of Microsoft SQL Server and Windows PowerShell knowledge, mobile device management, and application configuration One to three years of experience supporting multiple desktop and server computers running the Windows Server OS in medium to large organizations Recommended equipment: Microsoft System Center 2012 Configuration Manager Related certifications: MCTS: Administering and Deploying System Center 2012 Configuration Manager Related job functions: IT professionals How do you manage a Windows infrastructure? Installing applications by walking around is so 1990. Automation is the name of today’s game, and nothing spells Windows automation like System Center Configuration Manager. Automation has been called the Windows Administrator’s force multiplier. With the right tools, it enables a well-prepared administrator to monitor and enact change to exactly the right devices at exactly the right time. Prepping you to use those tools and wield that incredible power is the reason behind this video course. This course delivers a broad and deep exposure into Microsoft’s ConfigMgr 2012. Greg has been working with ConfigMgr since its early days as SMS 2.0. Throughout the years, he has developed a second sense for managing Windows desktops and servers with this powerful toolkit. He shares from his personal experience in this course to deliver not only the science (what buttons to click), but also the art (why you should click them) of managing a Windows infrastructure with ConfigMgr 2012. You’ll learn how to package and deploy software and virtual applications, as well as how to automate everything from individual configurations to entire OS deployments. You’ll learn the foundations of what you need to know for certification success, but you’ll also learn a few ConfigMgr best practices the consultants rarely share. In a Windows world where clicking Next, Next, Finish is no longer good enough. Smart IT professionals know that automation savvy is key to guaranteed employment. Join Greg in this ConfigMgr 2012 course and deep dive to develop exactly those skills that’ll make you the Most Valuable Professional of your own IT organization. [wpspoiler name="Подробное описание" ] 1. Introduction to System Center 2012, ConfigMgr 2012, and the 70-243 Exam (00:17:14) ConfigMgr 2012 is but one of the eight products that comprise Microsoft’s System Center portfolio. It is also one of the oldest, and potentially the most powerful. Kick off your training by understanding what you’ll need to know for this course and taking that 70-243 exam. 2. Understanding the ConfigMgr Architecture and Components (00:13:38) With an understanding of ConfigMgr’s fit as a product, your next task is to understand how its various functions interrelate. ConfigMgr has been around since 1994, making it an extremely mature and full-featured solution. All those functions can also make it a bit overwhelming for the newbie ConfigMgr administrator. Join Greg in this high-level introduction of ConfigMgr’s architecture and components and leave with a better understanding of the solution you’re about to learn. 3. Preparing for and Installing ConfigMgr 2012 (00:40:36) Every good product starts with an installation, and ConfigMgr is no different. While installing the ConfigMgr product is a task that’s far easier today than in previous versions, there are still a few prerequisites and gotchas you’ll need to know. Get those, and get started quickly in this Nugget. 4. Setting Boundaries and Enabling Discovery Methods (00:25:10) With an installed and functioning ConfigMgr site and site server, your next task involves setting the boundaries for management and enabling ConfigMgr’s various discovery methods. Doing so seems trivial, but a wrong move here could have huge impacts down the road. Greg shares the click-by-click and the best practices in this Nugget. 5. Deploying ConfigMgr Clients and Managing Client Settings (00:38:27) One of ConfigMgr’s most difficult tasks is client management, making sure clients exist where they should (and don’t where they shouldn’t). This task was a nightmarish chore in previous ConfigMgr versions, and gets only a bit better in this one. In this Nugget, Greg delivers the step-by-step to get clients delivered effectively, and shares a few key suggestions for configuring their settings to get the best experience. 6. Collecting Inventory and Creating Simple Collections (00:29:03) Data in a ConfigMgr system is gathered through what is really a two-step process. The first step often involves discovery information. That process brings data to ConfigMgr that can then be used in the second process: Inventory. Gathering inventory and using that data to create simple collections is the topic in this Nugget. 7. Constructing Queries and Building Query-based Collections (00:35:51) Another of the sometimes-incredibly challenging activities in ConfigMgr is creating queries and query-based collections. At fault is ConfigMgr’s interface, which even in this version is far from beginner-friendly. But coming to the rescue are a few tricks involving SQL Views that make performing this task far easier. Greg shows you how, and shares a few of his lessons learned in this Nugget. 8. Creating and Managing Reports (00:24:17) Just when you thought you had queries, WQL, and the ConfigMgr console figured out, you realize that creating reports requires an entirely new skill set. Reports in ConfigMgr 2012 can be ridiculously customized, if you know what you’re doing. Learn how in this Nugget. 9. Packaging Software for Local Installation and Application Virtualization (00:30:21) Take a look through Microsoft’s ConfigMgr documentation and nowhere will you ever find help in packaging software. That’s the process that “quiets” an installation, enabling it to execute automatically. That said, experience in packaging software for installation or App-V virtualization is the first step in any software deployment. Greg’s been packaging software for over a decade, and in this CBT Nuggets “Special Edition” Nugget he shares the tips and tools you’ll need to perform this task successfully. 10. Software Distribution the Old Way: Packages and Programs (00:42:16) Armed with a silenced software package, you’re ready to deploy applications anywhere with a ConfigMgr client. All you need is a little help in creating Packages and Programs. Technically, the Packages and Programs method is ConfigMgr 2012’s “old way," but you’ll need the steps here if you’re ever to be successful with deploying the “new way” with Applications. Kick off your learning with this deep dive on the fundamentals of distributing software. 11. Software Distribution the New Way: Applications! (00:49:55) One of ConfigMgr 2012’s new features is an entirely new user-centric application deployment model that Microsoft calls: Applications! Designed around delivering apps to users (as opposed to computers in the Packages and Programs approach), this new approach revolutionizes how we connect users with their applications and data. That said, being successful here requires extra effort and smart thinking. Greg got you started in that last Nugget, and finishes the job in this one. You’ll never walk around with DVDs ever again. 12. Deploying Operating Systems (01:06:30) Deploying an application? No problem. But an entire OS? Also no problem with the help of ConfigMgr. In this critically important Nugget, you’ll learn about User State Migration Tool (USMT), ConfigMgr Task Sequences, along with all the necessary skills you need to deploy operating systems. Better yet, Greg will share a few key tricks you can implement immediately that will enable users to refresh their own computers. Who knows? With a bit of up-front effort, you could realistically create a situation where you’ll never need to troubleshoot desktop problems again. Don’t believe it? Watch this Nugget to find out how. 13. Deploying Software Updates (00:39:40) You’ve mastered WSUS, but how confident are you in the WSUS reporting engine? Reporting on patching success means delivering the right metrics for all the right computers. Software updates in ConfigMgr 2012 gain some major improvements that make this upgrade worth the effort, like Automatic Deployment Rules that eliminate the scut work in patch deployment and updated reports that prove your compliance. Learn about all these and more in this Nugget. 14. Deploying and Managing Compliance Baselines (00:25:39) With software, operating systems, and updates under your belt, you’re almost ready for complete automation. One final step remains: Controlling configurations. ConfigMgr 2007’s DCM was a feature worth overlooking. No more with Compliance Baselines in ConfigMgr 2012. In this all-important Nugget, Greg shows you exactly how important this new feature can be for completely automating your Windows administration. You’ll learn how to find the configurations worth controlling, and how to build your own compliance settings to keep every application in check. 15. Metering Software Usage (00:09:43) Every IT environment has “those apps," those you know haven’t been used in years even though you’re still responsible for them. Not to mention “those users," the ones who demand certain expensive applications that they rarely use. It’s hard to prove them wrong, or at least it used to be before ConfigMgr Metering Rules. With ConfigMgr Metering Rules you can measure exactly how many minutes a month “those apps” get used and “those users” use them. Save your company money, and pay for your ConfigMgr investment with just a single feature by watching this Nugget. 16. Managing Forefront Endpoint Protection Settings (00:14:44) ConfigMgr 2012 merges with Microsoft Forefront in this version to deliver comprehensive endpoint security. With a separate license and a few extra steps, you’ll be protecting your clients and managing their configurations – all from the same comfortable instance. Greg shows you all the setup, as well as the ongoing management in this Nugget. 17. Managing Mobile Devices and Securing Client Communication (00:51:16) Every so often a Nugget gets released that pays for your entire training. This could be that Nugget. Configuring HTTPS client communication and mutual authentication isn’t a task taken lightly. Back in ConfigMgr 2007 it was called “Native Mode," and almost everyone ignored it. Complete client security and complete mobile device management are back in 2012, but they’re no less challenging to implement. Learn the exact step-by-step to secure your client communication and enable mobile device management in this not-to-be-missed Nugget. 18. Monitoring and Managing Site and Client Status (00:26:46) Every Nugget training course has its “miscellaneous” topic. While no less important, Greg collects a variety of site and client management and monitoring topics into this kitchen sink Nugget. In it he explains working with alerts, power management, remote control settings, site, component, and client status, site maintenance tasks, backups, and Wake on LAN settings. Like any good server, ConfigMgr requires regular care and feeding. Getting that done right is the topic for this Nugget. 19. Implementing ConfigMgr Role-based Security (00:15:15) ConfigMgr 2007’s security model was AMPITA – A Major Pain in the Administrator. Delegating permissions to administrators in 2012 gets better…just a bit. Greg gives you the shortcuts you need to set permissions successfully in this Nugget. 20. Planning and Implementing a ConfigMgr Site Hierarchy (00:35:07) Nineteen videos later and your ConfigMgr experience is nearly complete. Yet there’s one last topic that you absolutely can’t miss. So far, you’ve been working in a single-server and single-site environment. That architecture can’t scale. Creating one that can requires a bit of extra thinking. Don’t make the easy mistakes in extending your environment past one server and site. Join Greg in this 20th and final video to get the smart strategies for implementing your ConfigMgr site hierarchy. [/wpspoiler]

[caption id="attachment_1260" align="alignright" width="300" class=" "] SQL Server 2012[/caption]   Автор: Производитель: Специалист Год выпуска: 2013 Продолжительность: 40:00:00 Тип материала: Видеоурок Язык: Русский Стоимость: 7999 рублей Описание: В ходе занятий по этому 5-дневному курсу Вы овладеете реализацией BI-платформы для поддержки аналитики для информационных работников. Вы узнаете, как создать хранилище данных в SQL Server 2012, внедрить решение ETL со службами SQL Server Integration Services, проверить и очистить данные с помощью SQL Server Data Quality Services и SQL Server Master Data Services. Успешное окончание курса поможет Вам подготовиться к экзамену Microsoft 70-463. Microsoft SQL Server 2012 - система управления реляционными базами данных. Программный продукт предлагает разработчикам и пользователям широкий набор возможностей по созданию решений с высоким уровнем производительности, надежности и безопасности, является комплексной платформой управления данными и бизнес-анализа. BI-технологии позволяют анализировать большие объёмы информации, заостряя внимание пользователей лишь на ключевых факторах эффективности, моделируя исход различных вариантов действий, отслеживая результаты принятия тех или иных решений. SQL Server 2008 R2 содержит ряд новых возможностей BI, дает всем пользователям доступ к развитым средствам бизнес-анализа. Основной аудиторией данного курса являются лица, в обязанности которых входит администрирование SQL-сервера, а также аналитики, разработчики, специалисты по системам отчётности, программисты 1С и т.п. Их обязанности фокусируются на практической работе по созданию BI-решений, включая внедрение хранилищ данных, ETL, и очистке данных. Основные обязанности: Реализация хранилища данных Разработка пакетов SSIS для извлечения данных и загрузки / передачи / преобразования Обеспечение целостности данных, с использованием Master Data Services Очистка данных с помощью служб Data Quality [wpspoiler name="Подробное описание" ] Модуль 1. Введение в хранилища данных Описание концепции и архитектуры хранилища данных Решение для хранилища данных Лабораторная работа: Изучение решения для хранилища данных Изучение источников данных Изучение процессов ETL Изучение хранилищ данных 4 Модуль 2. Аппаратное обеспечение для хранилища данных Сложности построения хранилищ данных Архитектура хранилищ данных Оборудование для хранилищ данных 2 Модуль 3. Проектирование и реализация хранилищ данных Логический дизайн хранилищ данных Физический дизайн хранилищ данных Лабораторная работа: Реализация схемы хранилища данных Реализация схемы Звезда Реализация схемы Снежинка Реализация таблицы времени 2 Модуль 4. Разработка и внедрение схемы для хранилища данных Введение в ETL с SSIS Изучение источников данных Реализация потока данных Лабораторная работа: Реализация потока данных в пакете служб SSIS Изучение источников данных Передача данных с помощью задачи потока данных Использование преобразования в потоке данных 4 Модуль 5. Реализация потока управления в пакете SSIS Введение в поток управления Создание динамических пакетов Использование контейнеров Управление согласованностью Лабораторная работа: Реализация потока управления в пакете SSIS Использование задач и очередность в потоке управления Использование переменных и параметров Использование контейнеров Лабораторная работа: Использование транзакций и контрольных точек Использование транзакций Использование контрольных точек 2 Модуль 6. Отладка и устранение неполадок служб SSIS Отладка пакетов служб SSIS Ведение журнала событий пакетов служб SSIS Обработка ошибок в пакете служб SSIS Лабораторная работа: Отладка и устранение неполадок пакетов служб SSIS Отладка пакетов служб SSIS Ведение журнала выполнения пакетов служб SSIS Реализация обработчиков событий Обработка ошибок в потоке данных 4 Модуль 7. Реализация инкрементных ETL процессов Введение в инкрементные процессы ETL Извлечение изменения данных Загрузка измененных данных Лабораторная работа: извлечение измененных данных Использование столбца типа DateTime для поэтапного извлечения данных Использование отслеживания изменений Лабораторная работа: загрузка инкрементных изменений Использование задачи Lookup task, чтобы вставить данные измерений Использование задачи Lookup task, чтобы вставить или обновить данные измерений Реализация медленно изменяющихся измерений Использование инструкции MERGE для загрузки фактических данных 4 Модуль 8. Включение данных из облака в хранилище данных Обзор «облачных» источников данных SQL Server Azure Рынок данных Azure Лабораторная работа: Включение данных из облака в хранилище данных Извлечение данных из SQL Azure Получение данных из рынка данных Azure 2 Модуль 9. Обеспечение качества данных Введение в очистку данных Использование Data Quality Services для очистки данных Использование Data Quality Services для соответствия данных Лабораторная работа: Очистка данных Создание базы знаний DQS Очистка данных с помощью проекта DQS Использование DQS в SSIS пакете Лабораторная работа: удаление повторяющихся данных Создание политики соответствия Использование Data Quality Services для соответствия данных 4 Модуль 10. Использование Master Data Services Основные понятия Master Data Services Реализация модели Master Data Services Использование надстройки Excel с Master Data Services Лабораторная работа: Реализация Master Data Services Создание базовой модели MDS Редактирование моделей MDS с помощью Excel Загрузка данных в MDS Обеспечение бизнес-правил Получение Master Data Services данных 2 Модуль 11. Расширение SSIS Использование пользовательских компонентов в SSIS Использование сценариев в SSIS Лабораторная работа: использование скриптов и пользовательских компонентов Использование пользовательских компонентов Использование Задачи сценарий (Script Task) 2 Модуль 12. Развертывание и настройка пакетов служб SSIS Обзор развертывания Развертывание проектов служб SSIS Планирование выполнения пакетов служб SSIS Лабораторная работа: Развертывание и настройка пакетов служб SSIS Создание каталога SSIS Развертывание SSIS проекта Создание среды для SSIS решений Запуск пакетов служб SSIS в SQL Server Management Studio Запуск пакетов SSIS по расписанию агентом SQL Server 4 Модуль 13. Использование данных в хранилище Использование Excel для анализа данных в хранилище Введение в PowerPivot Введение в Crescent Лабораторная работа: использование хранилищ данных Использование PowerPivot для создания запроса к хранилищу данных Визуализация данных с помощью Crescent [/wpspoiler]

[caption id="attachment_1260" align="alignright" width="300" class=" "] SQL Server 2012[/caption] Автор: Производитель: Специалист Год выпуска: 2013 Продолжительность: 40:00:00 Тип материала: Видеоурок Язык: Русский Стоимость: 7999 рублей Описание: В ходе этого 5-дневного курса Вы получите технические навыки написания основных запросов на языке Transact-SQL для Microsoft SQL Server 2012. Курс является основой для всех дисциплин, связанных с SQL Server, а именно администрирования баз данных, разработки баз данных и бизнес-аналитики. Занятия на этом курсе позволят Вам подготовиться к экзамену Microsoft 70-461. Многие упражнения, выполняемые при обучении на курсе, включают работу с SQL Azure. [wpspoiler name="Подробное описание" ] Создавать запросы на выборку данных (SELECT) Создавать запросы к нескольким таблицам Использовать встроенные функции Использовать подзапросы Выполнять хранимые процедуры Использовать операции над множествами Реализовывать обработку ошибок Реализовывать транзакции Использовать табличные выражения Осуществлять сортировку и фильтрацию данных Использовать функции ранжирования, смещения и агрегирования Создавать запросы к метаданным SQL Server Программировать на T-SQL Повышать производительность запросов [/wpspoiler]

[caption id="attachment_1260" align="alignright" width="300" class=" "] SQL Server 2012[/caption] Автор: Mark Long Производитель: VTC Год выпуска: 2013 Продолжительность: 8:49:10 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: Business data analysis becomes more important as the amount of data involved in the analysis grows. This data is in various database management products, spreadsheets, and documents. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present. In this VTC course, author Mark Long walks you through the information you need to get prepared to take Microsoft’s 70-463 certification exam: Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is part of Microsoft’s MCSA: SQL Server Certification. [wpspoiler name="Подробное описание" ] 1. Welcome 2. Getting Set Up 3. Data Warehouse Basics 4. Creating a Data Warehouse 5. Data Flow Using SSIS 6. Design and Implement Data Flow 7. Advanced Control Flow 8. Data Services 9. Custom Code in SSIS 10. Deploying Packages 11. Conclusion [/wpspoiler]

[caption id="attachment_1260" align="alignright" width="300" class=" "] SQL Server 2012[/caption] Автор: Garth Schulte Производитель: CBT Nuggets Год выпуска: 2013 Продолжительность: 12:49:10 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: This SQL Server video training with Garth Schulte covers the latest version of Microsoft’s much in-demand server, including how to install SQL Server 2012, implement a backup strategy, and more. Related Area of Expertise: Database Development Recommended skills: Familiarity with databases Recommended equipment: Microsoft SQL Server 2012 Related certifications: MCSA: SQL Server 2012 MCSE: Data Platform MCSE: Business Intelligence MCSM: Data Platform Related job functions: Database administrators Database developers Database analysts SQL Server database administrators are in extremely high demand all over the world. SQL Server 2012, with its new high availability and cloud-ready features, is poised to be an industry leader, further increasing the demand for DBAs. If there ever was a time to get certified as a SQL Server professional, it's now! This course will lead you down the path of ultimate database geekery and develop the skills necessary to become a SQL Server DBA. You'll learn what it takes to administer and manage SQL Server 2012 – from planning, installing, troubleshooting, recovering, and securing instances and databases. Exam 70-462 is a prerequisite for the SQL Server 2012 MCSA certification, which is the first step towards attaining both MCSE certifications: Data Platform and Business Intelligence. This course will help prepare you for the 70-462 exam and beyond with real-world examples and live demonstrations! [wpspoiler name="Подробное описание" ] 1. Introduction to 70-462: Administering SQL Server 2012 (00:10:14) In this introductory Nugget we look at the major components of SQL Server 2012 and roles of the individuals involved with managing and developing with these technologies. We'll also get familiar with the 70-462 exam objectives and how they relate to this CBT Nuggets series outline. 2. Planning a SQL Server 2012 Installation (00:32:06) Understanding how and what to plan for when it comes to a SQL Server 2012 installation can not only ensure you have a successful deployment, but greatly minimize the chances for management pitfalls during its production lifetime. This Nugget will show you how to plan accordingly for an installation and beyond -- you'll learn about hardware and software requirements, capacity planning, scaling up vs. scaling out, logical and physical database design, standby database technologies, benchmarking and more. 3. Installing SQL Server 2012 (00:39:13) This Nugget will guide you through multiple installations of SQL Server 2012. You'll learn how to prepare the OS disk, install SQL Server Express and SQL Server Enterprise editions, install and configure Integration Services, test connectivity to the database engine and Integration Services using SQL Server Management Studio and the SQLCMD utility, and conclude with a look at how to do an unattended installation using a configuration file. 4. Implementing a Migration Strategy (00:31:51) Understanding how to move databases between SQL Servers will prepare you for any migration project. This Nugget will show you how to choose a migration strategy and what to migrate -- you'll learn how to move databases, security and related components manually and automatically. 5. Configuring SQL Server Components (00:52:26) Understanding how SQL Server's components work will ensure you have control over the installation and configuration process. This Nugget will show you how to install and configure Analysis Services and Reporting Services. You'll also learn how to create, configure and manage Full-Text Indexes, FileStreams and the new FileTable feature. 6. Managing SQL Server Agent (00:34:15) SQL Server Agent can help us automate processes and monitor the health of SQL Server instances and databases. This Nugget takes you through SQL Agent configuration and management -- where you'll learn how to create jobs, alerts, operators and automate a real world T-SQL script for backing up all databases on a SQL instance. You'll conclude with how to configure and manage master/target servers for multi server administration of jobs. 7. Configuring and Managing Databases (00:57:30) This Nugget will show you many of the database tasks every DBA should have in their skill set. You'll learn how to design a database using multiple filegroups, standardize database configuration, implement contained databases, work with data compression and transparent data encryption, partition tables/indexes as well as manage log file growth and work with DBCC statements. 8. Configuring and Managing Instances (00:46:35) Ensuring our SQL Server instances have the resources they need to function is vital for successful implementations. This Nugget will show you how to configure SQL Servers memory and processor resources in single and multi-instance environments. You'll also learn how to configure and manage Database Mail, Resource Governor, Windows System Resource Manager, work with SQL Servers error logs and view guidelines for deploying patches. 9. Implementing a Clustered Instance (00:43:38) High Availability is a hot topic in IT departments, and this Nugget will give you the skills you need to implement AlwaysOn Failover Clustered Instances (FCI's) to deploy a highly available SQL Server 2012 solution at the instance level. You'll learn how to design and prepare a single and multi-subnet network for a clustered deployment, install and configure Windows Server Failover Clustering (WSFC), implement a SAN using Microsoft's iSCI target software, install SQL Server FCIs and manage a clustered deployment. 10. Identifying and Resolving Concurrency Issues (00:36:08) Many concurrent database users can cause locking issues such as blocking and deadlocking. This Nugget will give you the skills needed to handle these situations and solutions to prevent them -- you'll learn how SQL Server's locking system works, why blocks/deadlocks occur and how to simulate, identify and resolve them. You'll also learn how to use monitoring and reporting to troubleshoot concurrency issues. 11. Troubleshooting SQL Server (00:35:10) Finding the problem is usually the hard part when troubleshooting server and database issues. This Nugget will show you the tools we can use to become top-notch investigators. You'll learn how to use the SQL Server Profiler and Extended Events Profiler to spy on SQL Server activity in real time, get help on DMV's for SQL Server state information, configure Data Collecttion to persist state information and use the Windows Performance Monitor to track down server bottlenecks. 12. Auditing SQL Server (00:32:24) This Nugget will show you how to audit actions performed against an instance or database and enforce configuration standards using policy-based management. You'll see how to create and log audit actions to a target such as the Windows event log and a log file. You'll also learn how create and enforce policies at the instance and enterprise level using a central management server. 13. Implementing a Backup Strategy (00:38:27) Having a reliable backup strategy is critical to ensuring we can recover in the event of a failure. This Nugget will show you how to implement backup strategies for databases of all sizes using full, differential, transaction log, file and filegroup backups. You'll also learn how to use backup compression, the copy only option and automate your backup strategies using a maintenance plan. 14. Restoring Databases (00:23:34) This Nugget will show you how to restore databases from the various types of backups and strategies. You'll also learn how to restore encrypted databases on remote instances, implement file and page restoration to recover from damaged or corrupted parts of your database and restore databases to a specific point in time. 15. Implementing and Maintaining Indexes (00:56:14) Indexes are the standard for optimizing query performance, and this Nugget will start with the basics of index design: structures, types, statistics, fragmentation and design guidelines. You'll also learn how to create and implement clustered, non-clustered, covering, filtered, XML, full-text and columnstore indexes along with creating and automating an index maintenance plan to keep your indexes highly optimized. 16. Importing and Exporting Data (00:27:10) Moving data in, out and around is a common task for today's DBA, and this Nugget will show you how to push, pull, migrate, transfer and copy data from in and out of SQL Server. You'll learn how to use the import and export wizard, bulk copy program (bcp), BULK INSERT statement, SELECT..INTO and some common guidelines for bulk loading data. 17. Managing Logins and Server Roles (00:24:51) This Nugget will show you how to manage access to SQL Server. You'll learn how to give individuals and groups access to SQL Server using logins, and choose an authentication method that fits your security strategy. You'll also learn how to create and manage server roles to control permissions at the SQL Server instance level. 18. Managing Users and Database Roles (00:28:39) This Nugget will show you how to manage access to databases. You'll learn how to create users that are mapped to logins, contained users and users for impersonation. You'll also learn how to create and manage database roles and application roles to control user and application permissions at the database level. 19. Managing and Troubleshooting Security (00:25:48) This Nugget will show you how to apply permissions and manage security. You'll learn how to design a security strategy using roles, securables, schemas and applying the principle of least privilege. You'll also learn how to troubleshoot common security issues and apply data encryption using certificates and keys. 20. Implementing AlwaysOn Availability Groups (00:37:50) AlwaysOn Availability Groups are the future of high availability and disaster recovery for databases and a highlight of SQL Server 2012. DBAs will never look back once they learn how to implement this amazing new technology! You'll learn the requirements, features and components of AlwaysOn Availability Groups in this Nugget -- and see how to configure, implement and manage them on top of a Windows Server Failover Cluster. You'll also learn how to enable read-only routing to spread the workload around our database replicas and configure applications and reports to utilize the read-only routes. 21. Implementing Database Mirroring (00:20:31) Database Mirroring is a widely used feature for deploying standby databases to eliminate downtime during planned or unexpected server maintenance. This Nugget will get you familiar with how mirroring works and show you how to create, configure, manage and monitor a fully functional database mirror. 22. Implementing Replication (00:34:36) Replication is a data distribution and synchronization technology used for a number of scenarios. This Nugget will start by taking you through the components, types and topologies replication is often used for. You'll also learn how to implement replication by setting up a distributor, creating publications of each type (snapshot, transactional, merge), configuring subscriptions and monitoring replication processes. [/wpspoiler]

[caption id="attachment_1260" align="alignright" width="300" class=" "] SQL Server 2012[/caption] Автор: Mark Long Производитель: VTC Год выпуска: 2013 Продолжительность: 8:29:50 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: The 2012 Microsoft MCSA Certification track includes Exam 70-461 Querying Microsoft SQL Server 2012. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This VTC course is intended for SQL Server database administrators, implementers, system engineers, and developers who are preparing to take the 70-461 exam as well as those who are just beginning to learn Transact-SQL. Mark Long is the instructor and will take you through the various tools and concepts needed to help you get ready for the 70-461 exam. [wpspoiler name="Подробное описание" ] Introduction Getting Set Up SQL Server 2012 Management Studio Creating Database Objects Basic Select Queries More Advanced Select Statements SQL Server 2012 Data Types Using Joins Querying Metadata Inserts / Updates / Deletes Subqueries Table Expression Stored Procedures Functions Transactions Conclusion Credits [/wpspoiler]

[caption id="attachment_1260" align="alignright" width="300" class=" "] SQL Server 2012[/caption] Автор: Garth Schulte CBT Nuggets Trainer Год выпуска: 2013 Продолжительность: 11:29:50 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: В курсе изучаются вопросы создания и использования баз данных Microsoft SQL Server 2008 R2. Рассматривается реализация хранения данных (таблицы, индексы) и обработки данных (программирование, транзакции, оптимизация) средствами MS SQL Server 2008 R2. Целевая аудитория курса: лица, в обязанности которых входит администрирование SQL-сервера, а также аналитики, разработчики, специалисты по системам отчётности, программисты 1С и т.п. [wpspoiler name="Подробное описание" ] 1. Introduction to 70-461: Querying Microsoft SQL Server 2012 (00:35:20) In this introductory Nugget we take a good look at what's in store for the course. We start with the 70-461 exam objectives from Microsoft and follow that up with a look at how this course is laid out. Next, we get familiar with the SQL Server 2012 express editions and install it on our Nuggetlab virtual machine. Finally we look at how to obtain and attach the AdventureWorks2012 sample database into our instance and show you a few tips on how to manage your queries and scripts using SQL Server projects. 2. Creating and Altering Tables with T-SQL (00:34:26) You'll learn how to create, modify and delete tables using T-SQL in this Nugget. You'll also learn how to utilize context sensitive help, translate T-SQL syntax, generate and analyze scripts from tables, and learn some tips and tricks in SQL Server 2012 Management Studio along the way. 3. Creating and Altering Views with T-SQL (00:43:22) This Nugget will show you how to create, modify and delete views using T-SQL. You'll learn how to modify data using views, create and use indexed views, analyze query execution plans and generate sample data for testing purposes. 4. Designing Views (00:32:22) Understanding when and how to design views will help you create solutions to common problems and simplify data access. This Nugget will give you the know-how to do just that -- you'll start with view design 101 and learn when to use views; next we'll learn how to design views in SQL Server 2012 Management Studio as well as encrypt view definitions. Finally we'll learn how to apply security at the view level to simplify permission management and keep our base tables secure. 5. Creating and Modifying Constraints (00:42:30) In this Nugget, you'll learn how to create constraints, which gives us a way to shape the data going into our database and ensure data integrity. You'll learn how to create column and table constraints such as defaults, checks, unique indexes, primary keys and foreign keys using T-SQL. You'll also see how to create a database diagram to get a better visual of the overall database design. 6. Creating and Modifying DML Triggers (00:46:11) DML Triggers allow us to respond to data modifications on our tables in real-time and are a great tool for any DBA or developer to have in their skill set. This Nugget will show you when and how to create every type of DML trigger for every type of data modification. You'll also learn how to build nested triggers, understand potential performance implications and see how to send an email from inside a trigger using T-SQL. 7. Querying Data using SELECT (00:58:55) This Nugget will take you on a tour through the SELECT statement and how we use it to return data from the database. You'll start with the basics -- learning the major components of the SELECT statement and follow it up with how to use some extremely useful T-SQL language constructs and built-in functions. You'll also learn how to rank data, build and execute dynamic SQL, and use system metadata to query the database about itself. 8. Implementing Subqueries (00:33:54) Learning how to write subqueries gives us more ways to design a query. This Nugget will start with the subquery basics and show you where and when we can write nested queries. You'll also learn how to create Common Table Expressions (CTEs) to help us better manage T-SQL code and finish with how to build matrix style results using pivot tables. 9. Implementing Data Types (00:40:16) Choosing the right data type for storing data, whether it be in table columns or variables, is essential for the integrity, storage and performance of our database. This Nugget gives you an understanding of every data type available in SQL Server 2012 -- you'll learn how to choose the right data type for your database structures, get some common guidelines for working with data types and see first hand the data we can store in each data type. 10. Implementing Aggregates (00:44:03) This Nugget will show you how to group and aggregate data in a variety of ways. You'll start with the GROUP BY clause to get a handle on the basics of grouping data and incorporate grouping sets for subtotaling our query results. You'll see the new analytic and ranking functions in action while learning how to generate, work with and aggregate spatial data. 11. Querying and Managing XML Data (00:43:24) XML is a widely adopted format for storing data and this Nugget will show you everything you need to know about XML in SQL Server. The basics cover XML itself -- from schemas to namespaces to how we transform relational data to an XML format. You'll also learn how to load and associate XSD schemas with XML columns and import/export XML using BCP, OPENXML and even SQL Server Integration Services (SSIS). 12. Creating and Altering Stored Procedures (00:33:21) Stored Procedures allow us to create reusable components on the database server to increase managability and performance of our T-SQL code -- this Nugget will show you the basics and beyond of creating and executing Stored Procedures as well as techniques for building and designing a set of Stored Procedures for use in the data layer of an application. 13. Modifying Data with T-SQL (00:33:08) This Nugget will show you the basics of data modification with the INSERT, UPDATE and DELETE statement. We'll analyze the syntax of each statement, learn the basic usages and see how to utilize the OUTPUT clause to discover what changes were caused by each statement. 14. Combining Datasets (00:22:49) Understanding how to work with data from multiple queries will give you another skill to prepare you for anything and everything. This Nugget will show you how to combine, compare and merge results using operators such as UNION, EXCEPT, INTERSECT and MERGE. 15. Working with Functions (00:42:21) Functions give us a great alternative to reusing code over stored procedures and provide more flexibility in where we can use them. This Nugget will get you familiar with everything functions in T-SQL -- you'll learn how to create scalar and table-value functions, use built-in and system functions and see examples of how to use them in the real world. 16. Optimizing Queries (00:37:24) Performance is a top priority for databases and many performance issues come from poorly designed queries. This Nugget will show you how to find query performance issues using query execution plans, find slow performing queries in a database using DMVs and give you design guidelines needed to create blazing fast queries. 17. Managing Transactions (00:27:41) Transactions ensure our data stays in a consistent state and is protected from concurrent processes. This Nugget will show you how to create, manage and work with transactions -- you'll also learn how locking works and see how isolation levels help us when it comes to concurrent operations. 18. Row-based vs. Set-based Operations (00:22:57) Understanding how T-SQL statements process rows can help you make better design decisions when creating queries. This Nugget will get you familiar with row-based operations such as cursors and loops, when to use them and how to convert them to set-based operations for performance benefits. 19. Implementing Error Handling (00:15:26) Knowing when and how to handle errors will improve end user and developer experience with the database. This Nugget will show you where, when and how to handle errors using the TRY..CATCH statement. You'll also learn how to generate, store and view custom error messages in SQL Server. [/wpspoiler]

[caption id="attachment_1233" align="alignright" width="300" class=" "] microsoft sql server 2008 r2[/caption] Автор (режиссер): Специалист Год выпуска: 2011 Продолжительность: 34:38:01 Тип материала: Видеоурок Язык: Русский Стоимость: 7999 рублей Описание: В курсе изучаются вопросы создания и использования баз данных Microsoft SQL Server 2008 R2. Рассматривается реализация хранения данных (таблицы, индексы) и обработки данных (программирование, транзакции, оптимизация) средствами MS SQL Server 2008 R2. Целевая аудитория курса: лица, в обязанности которых входит администрирование SQL-сервера, а также аналитики, разработчики, специалисты по системам отчётности, программисты 1С и т.п. [wpspoiler name="Подробное описание" ] Модуль 1. Введение в инструментарий SQL Server Введение в платформу SQL Server Работа с инструментами (SQLCmd, Management Studio, Configuration Management, Books Online) Настройка служб (учётные записи, режимы запуска, сетевой доступ) Лабораторная работа 2 Модуль 2. Типы данных Использование типов данных Работа с данными строкового типа Преобразование типов Специализированные типы данных Лабораторная работа 2 Модуль 3. Таблицы Проектирование таблиц Использование схем Создание и модификация таблиц Лабораторная работа 2 Модуль 4. Представления Назначение представлений Создание представлений Работа с представлениями Влияние представлений на производительность Лабораторная работа 2 Модуль 5. Планирование индексов Принципы работы индексов Влияние типов данных на индексы Простые и составные индексы Лабораторная работа 2 Модуль 6. Управление механизмом хранения таблиц Хранение таблицы в куче Хранение таблицы в кластеризованном индексе Влияние механизма хранения на производительность Лабораторная работа 2 Модуль 7. Планы исполнения запросов Назначение плана исполнения запроса Элементы плана исполнения Использование планов исполнения Лабораторная работа 2 Модуль 8. Оптимизация запросов с использованием некластеризованных индексов Планирование эффективных некластеризованных индексов Создание некластеризованных индексов Использование утилиты автоматической настройки индексов Лабораторная работа 2 Модуль 9. Хранимые процедуры Введение в хранимые процедуры Использование хранимых процедур Создание параметризованных хранимых процедур Подмена контекста исполнения Лабораторная работа 2 Модуль 10. Слияние и обмен табличными данными Использование инструкции MERGE Табличные типы Использование табличных типов в качестве параметров Лабораторная работа 2 Модуль 11. Обработка данных в режиме одновременного доступа Транзакции Блокировки Управление блокировками Режимы изоляции Лабораторная работа 2 Модуль 12. Перехват и обработка ошибок в коде Transact-SQL Планирование обработки нештатных ситуаций Перехват ошибок Структурированная обработка ошибок Лабораторная работа 2 Модуль 13. Функции Скалярные функции Табличные функции Применение функций Альтернативы функциям Лабораторная работа 2 Модуль 14. Обеспечение целостности данных Постановка задачи контроля целостности данных Доменная целостность Сущностная целостность Ссылочная целостность Лабораторная работа 2 Модуль 15. Триггеры Назначение DML-триггеров Создание триггеров Особенности использования триггеров Лабораторная работа 2 Модуль 16. Управляемый код Интеграция управляемого кода в базу данных Загрузка и настройка сборок Использование управляемого кода Лабораторная работа 2 Модуль 17. Хранение данных в формате XML Введение в XML XML-схемы Хранение XML в базе данных Создание XML-типов данных Лабораторная работа 2 Модуль 18. Использование XML-данных в запросах Преобразование табличных данных в формат XML Запросы xQuery Преобразование XML-данных в табличный формат Лабораторная работа 2 Модуль 19. Пространственные данные Введение в пространственные данные Работа с геометрическими и географическими типами данных Использование пространственных данных в приложениях Лабораторная работа 2 Модуль 20. Полнотекстовые запросы и индексы Назначение полнотекстовых запросов Полнотекстовые индексы Использование полнотекстовых запросов Лабораторная работа [/wpspoiler]