Lynda – SQL Server 2014: Installation and Administration

Lynda - SQL Server 2014: Installation and Administration - 383046
Lynda – SQL Server 2014: Installation and Administration
Get up to speed on installing and administering the world’s most popular database, Microsoft SQL Server 2014. First, find out how to plan your installation of SQL Server, and get introduced to the various tools you’ll use for administration, such as SQL Server Management Studio. Then follow along with guide Ron Davis as he shows how to automate and set up maintenance plans, import and export data, and index databases. Finally, learn about monitoring SQL Server 2014 and keeping your databases—and users—secure.

Table of ContentsIntroduction1. Installing SQL Server 20142. Learning the SQL Server Tools3. Understanding Data Storage4. Automating Maintenance of SQL Server5. Implementing a Backup Plan6. Importing and Exporting Data7. Indexing the Databases8. Monitoring SQL Server9. Understanding SQL Server SecurityConclusion