MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Installing SQL Server 2012

Course Summary

Learn how to install, secure, and maintain SQL Server 2012.     


  • +

    Course Syllabus

    Introduction
       Welcome 
    1. Planning Your Installation
       SQL Server versions and supported operating systems 
       Hardware requirements 
       SQL Server components 
       Installation options 
    2. Install SQL Server 2012
       Install SQL Server using the GUI: Getting started 
       Install SQL Server using the GUI: Role and features 
       Install SQL Server using the GUI: Instance and server 
       Install SQL Server using the GUI: Engine and installation 
       Install SQL Server from the command prompt 
       Adding or removing features 
       Testing the installation and connectivity 
    3. Configure SQL Server 2012
       SQL Server properties: Machine resources 
       SQL Server properties: Security, Connections, and Advanced sections 
       Configure SQL Server services 
       Configure client and network connections 
    4. Creating and Connecting to Databases
       Understanding SQL Server database files 
       Creating a database using Management Studio 
       Creating a database using Transact-SQL 
       Connecting to a database 
       Securing the database 
    5. Back Up and Restore
       Understanding SQL Server backup and restore options 
       Designing a backup-and-restore strategy 
       Backing up a database 
       Scheduling a backup 
       Restoring a database 
    Conclusion
       Goodbye 


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

4 - 5 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top