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

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)