2013
Lynda
Gerry O'Brien
3:03
English

Learn how to install, secure, and maintain SQL Server 2012. This course is designed to teach new database administrators how to choose the correct SQL Server edition, install it using the GUI or from the command prompt, configure services and network connections, and create and connect to databases. Author Gerry O'Brien also reviews critical backup and restore procedures.

Introduction 58s
Welcome 58s
1. Planning Your Installation 17m 46s
SQL Server versions and supported operating systems 3m 37s
Hardware requirements 2m 45s
SQL Server components 6m 20s
Installation options 5m 4s
2. Install SQL Server 2012 48m 12s
Install SQL Server using the GUI: Getting started 7m 8s
Install SQL Server using the GUI: Role and features 4m 37s
Install SQL Server using the GUI: Instance and server 5m 6s
Install SQL Server using the GUI: Engine and installation 9m 26s
Install SQL Server from the command prompt 6m 38s
Adding or removing features 10m 47s
Testing the installation and connectivity 4m 30s
3. Configure SQL Server 2012 35m 47s
SQL Server properties: Machine resources 9m 1s
SQL Server properties: Security, Connections, and Advanced sections 6m 3s
Configure SQL Server services 10m 24s
Configure client and network connections 10m 19s
4. Creating and Connecting to Databases 37m 18s
Understanding SQL Server database files 8m 55s
Creating a database using Management Studio 7m 59s
Creating a database using Transact-SQL 6m 14s
Connecting to a database 5m 19s
Securing the database 8m 51s
5. Back Up and Restore 41m 57s
Understanding SQL Server backup and restore options 8m 4s
Designing a backup-and-restore strategy 9m 16s
Backing up a database 9m 38s
Scheduling a backup 5m 8s
Restoring a database 9m 51s
Conclusion 1m 41s
Goodbye 1m 41s

http://www.lynda.com/SQL-Server-tutorials/Installing-SQL-Server-2012/137882-2.html

Download File Size:459.77 MB

---