Total Hours: 40

SQL Server 2014- pre-requisite knowledge course

  • Learn Database models
  • Overview of SQL Server Management Studio and Transact-SQL language
  • Master writing simple and complex queries that retrieve data from the database
  • Calculate information across result sets using aggregate queries (sum, min, max, Avg, etc.)
  • Insert, update, and delete data
  • Retrieve data from tables
  • Joins
  • Sub-queries
  • Working with Data Types
  • Procedure and Functions
  • Understand the different Views
  • Working with Triggers
  • Design a database
  • Maintain databases, tables, and sequences with SQL statements
  • Create and manage views
  • Ensure the integrity of multiple, related database updates by using transactions
  • Retrieve data using cursors
  • Manage binary data using BLOBs

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