Pluralsight – SQL Server Indexing for Performance

Pluralsight – SQL Server: Indexing for Performance
English | Size: 1.35 GB
Category: Tutorial

The most important feature in SQL Server when it comes to getting the required workload performance is probably indexing. But the indexing possibilities you have can be bewildering, and it’s easy to make the wrong choice, leading to wasted resources and maybe even worse performance! In this course, SQL Server: Indexing for Performance, you’ll learn how to correctly choose indexes for your environment. First, you’ll discover how clustered and nonclustered indexes work and how they are used by SQL Server, both of which are crucial when choosing the correct indexes to create. Next you’ll explore the tipping point – when an index can be used or not, the benefits of covering queries, and how to use the INCLUDE option to more effectively cover queries. Finally, you’ll learn how to use filtered indexes and get an introduction to index consolidation for effective server tuning. When you’ve finished this course, you’ll have the skills and knowledge to start adding and changing indexes in your environment for better performance! [Read more…]

LiveLesson MCSA SQL Server 70-761 Querying Data with Transact SQL Tutorial OXBRiDG

LiveLesson: MCSA SQL Server 70-761 Querying Data with Transact SQL Tutorial OXBRiDG
English | Size: 21.07 GB
Category: Tutorial

Training material for the MCSA 70-761 exam. [Read more…]

Lynda – CompTIA Server+ (SK0-004) Cert Prep – 5 Networking

Lynda – CompTIA Server+ (SK0-004) Cert Prep – 5 Networking
English | Size: 161.40 MB
Category: Tutorial

Earn your CompTIA Server+ certification and validate your skills with the most commonly used server technologies. CompTIA Server+ Cert Prep is a comprehensive 7-part series designed to help you prepare for and pass the CompTIA Server+ exam (SK0-004). Join Ed Liberman for this course, which tackles the networking objectives. Learn about IP addressing, ports and protocols, and laying network cable, both copper and fiber. [Read more…]

Lynda – CompTIA Server+ (SK0-004) Cert Prep – 4 Security

Lynda – CompTIA Server+ (SK0-004) Cert Prep – 4 Security
English | Size: 153.95 MB
Category: Tutorial

Earning the CompTIA Server+ certification signals to potential employers that you have a robust understanding of server management. It’s a vendor-neutral certification that ensures administrators can manage a variety of systems, including web servers, virtual servers, mail servers, and more. Our series, CompTIA Server+ Cert Prep, is designed to help you prepare for and pass the exam. In this course, Ed Liberman helps you study for the security objectives. Review the three major layers of security-server, network, and data-as well as concepts such as multifactor authentication, logical access control, and environmental security. [Read more…]

Lynda – CompTIA Server+ (SK0-004) Cert Prep – 3 Storage.

Lynda – CompTIA Server+ (SK0-004) Cert Prep – 3 Storage.
English | Size: 128.40 MB
Category: Tutorial

Earning the CompTIA Server+ certification signals to potential employers that you have a robust understanding of server management. In this course, Ed Liberman prepares you for the storage portion of the CompTIA Server+ (SK0-004) exam. Here, Ed dives into the topic of server storage. He covers primary storage technologies, RAID, and storage capacity planning. [Read more…]

CentOS 7 Linux Server alternative to Red Hat Enterprise

CentOS 7 Linux Server alternative to Red Hat Enterprise
English | Size: 1.43 GB
Category: Tutotial

Linux is the fastest growing operating system in the world. Get the CentOS Server skills you need to succeed with this comprehensive course.
Let’s be honest; technical books are boring. Sure, you could learn CentOS 7 server administration from some long-winded encyclopedia, but why waste all that time?
Udemy’s video content delivery system will have you operating your own CentOS sever in minutes.
If you want to increase your IT skills, this course is a great place to start. More and more companies are utilizing Linux servers in their day-to-day operations. So, don’t be left behind! [Read more…]

Linux Academy – Red Hat Certificate of Expertise in Server Hardening Prep Course

Linux Academy – Red Hat Certificate of Expertise in Server Hardening Prep Course
English | Size: 1.86 GB
Category: CBTs

Linux Academy Red Hat Certificate of Expertise in Server Hardening Prep Course
The performance-based Red Hat Certificate of Expertise in Server Hardening exam (EX413) tests your ability to perform a number of systems administration tasks focused on securing servers against unauthorized access. [Read more…]

Linux Academy – CentOS 7 – Enterprise Linux Server Update

Linux Academy – CentOS 7 – Enterprise Linux Server Update
English | Size: 1.14 GB
Category: CBTs

CentOS 7: Enterprise Linux Server Update
This course covers the newly released CentOS 7 Enterprise Linux Distribution. We will talk about the evolution and lifecycle of support for CentOS and introduce its symbiotic relationship with Red Hat Enterprise Linux. We will then install from scratch and show the major departures from previous versions as it morphs into the more modern distribution it is today. [Read more…]

Lynda – SUSE Linux Enterprise Server Essential Training

Lynda – SUSE Linux Enterprise Server Essential Training
English | Size: 426.54 MB
Category: CBTs

Get started with SUSE Linux Enterprise Server, a secure, open source server operating system designed to tackle mission-critical workloads. In this course, learn essential SUSE Linux Enterprise Server administration concepts. Chaim Krause explains how to use YaST, set up a server to use Secure Boot, manage users and groups, and administer the most common network services. Plus, he covers various file systems, and using logical volume management to optimize your storage. [Read more…]

Lynda – CompTIA Server+ (SK0-004) Cert Prep 2 – Server Architecture

Lynda – CompTIA Server+ (SK0-004) Cert Prep 2 – Server Architecture
English | Size: 142.99 MB
Category: CBTs

Demonstrate your understanding of how to manage servers by earning the CompTIA Server+ certification. In this course, Ed Liberman prepares you for the server architecture portion of the CompTIA Server+ (SK0-004) exam. Ed goes into server form factors, discussing rack mount and tower servers, as well as blade technology. He also explains how to work with server components and power and cooling. [Read more…]