Total Hours: 40 SQL Server 2014- pre-requisite knowledge course SQL Server and Database Fundamental OLTP vs. OLAP SQL Server Agent SQL Services SQL Server Configuration Database Index Statistics and Types of Statistics Backup and Recovery Fundamentals Monitoring Fundamental Performance Fundamental Log Shipping Fundamental Replication Fundamentals Mirroring Fundamentals Always On HA SQL Cluster SQL Server 2014 – New Features Course In-Memory OLTP Managed backup to Azure Encryption on Backup Azure VMs for Availability Replicas Data Files in Azure Updateable Column store Indexes Resource Governor for I/O Delayed Durability SSD Buffer pool extension Incremental Statistics Lock Priority of online operations Hardware and software requirement for SQL Server 2014 http://msdn.microsoft.com/en-us/library/ms143506.aspx#hwswr The following are some recommendations before installing SQL Server 2014: Access to the Internet and Windows Update Services is required, since SQL Server setup will try to get updates for SQL Server during installation. Hardware Requirements Processor. On 32-bit platforms, SQL Server 2014 requires a Pentium III or faster processor una 1.0 Ghz speed or better. On 64-bit platforms, SQL Server 2014 requires Intel Xeon, AMD Opteron or Athlon 64 with a minimum speed of 2.0 Ghz. Physical Memory (RAM). 512 MB minimum of RAM for Express Edition, but the minimum for all other editions is 1 GB of RAM (the minimum is 2 GB if Data Quality Services is going to be installed). Recommended amount of RAM for Express Edition is 1 GB of RAM, but the recommended amount of RAM for all other editions is 4 GB of RAM. Operating Systems Requirements Plan to install on a NTFS file system. Do not try to install SQL Server 2014 on a compressed, encrypted or read-only drive, because setup will block the installation. Do not install SQL Server on a Domain Controller. Click here for more information. Verify Windows Management Instrumentation service (Control Panel -> Administrative Tools -> Services) is running. Configure your firewall to allow SQL Server access. Click here for more information about protocols and port numbers. The user account that is running SQL Server Setup must have administrative privileges on the computer. It can be installed on Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 R2 Service Pack 1 (SP1), Windows Server 2008 Service Pack 2 (SP2), Windows 8.1, Windows 8, Windows 7 Service Pack 1 (SP1). The following operating systems are not supported: Windows Vista, Windows XP, Windows Server 2003 and Windows Server 2000. At least 6.0 GB of disk space are required by SQL Server setup. Additional software requirements and hardware requirements Enable .NET Framework 3.5. Click here to know how. SQL Server includes .NET Framework 4.0 and will install it .NET Framework 4.0. Express Edition will download it from the Internet. PowerShell 2.0. Click here if you need help to locate where to download PowerShell 2.0. SQL Server 2014 Evaluation Version: (download Link) http://technet.microsoft.com/en-in/evalcenter/dn205290.aspx