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

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)