Microsoft SQL Server 2012 Administration
This Microsoft SQL Server 2012 contains 22 Units and each Unit contains 150 slides in it.
To "View/Download" the sample of this presentation, go to the following link: http://www.slideshare.net/nsprash/microsoft-sql-server-2012-unit-01
Contents…
Level: I
Relational Database Management System
• Define a Database Management System
• Describe the types of data models
• Create an entity-relationship model
• List the types of relationships between entities
• Define a Relational Database Management System
• Describe the operators that work on relations
• Map an ER diagram to a table
• Describe data redundancy
• Describe the first, second, and third normal forms
• Describe the Boyce-Codd Normal Form
• Appreciate the need for denormalization.
Level: - II
Querying and Managing Data Using MS SQL Server 2012
• Appreciate SQL Server 2012 as a database server
• Identify the SQL Server 2012 tools
• Retrieve data
• Use functions to customize the result set
• Summarize and group data
• Query data by using joins
• Query data by using sub queries
• Manage databases
• Manage tables
• Manipulate data by using (DML) Data Manipulation Language statements
• Manipulate the (XML) Extensible Markup Language data
• Create and manage indexes
• Create and manage views
• Implement a full-text search
• Implement batches
• Implement stored procedures
• Implement functions
• Implement triggers
• Implement transactions
• Understand managed code
• Create managed database objects
• Define the (HTTP) Hypertext Transfer Protocol endpoints
• Implement the Hypertext Transfer Protocol endpoints for Web services
• Appreciate message-based communication
• Implement Service Broker
Level: - III
Administering Database Using MS SQL Server 2012
• Install SQL Server 2012
• Upgrade to SQL Server 2012
• Configure SQL Server 2012
• Create databases
• Manage databases
• Automate database management by using SQL Server Agent
• Secure a database
• Encrypt data
• Back up a database
• Restore a database
• Monitor and optimize performance
• Troubleshoot performance
• Implement database mirroring
• Implement log shipping
• Implement database snapshot
• Replicate data
• Manage replication
• Import and export data by using T-SQL commands
• Import and export data by using SSIS