Setup Menus in Admin Panel

Compu21

Setup Menus in Admin Panel

MS SQL Server 2012 Design

MS SQL Server 2012 Design Chapter 1: Introduction to Microsoft SQL Server 2008/2012 introduces you to SQL Server and explains …

0 STUDENTS ENROLLED

    MS SQL Server 2012 Design

    Chapter 1: Introduction to Microsoft SQL Server 2008/2012

    introduces you to SQL Server and explains what SQL Server is. The chapter provides a cohesive overview of SQL Server so that you can understand how all the pieces fit together.

    Chapter 2: Using Transact-SQL on a SQL Server Database

    introduces you to Transact-SQL and provides details about how to create and execute Transact-SQL statements in order to manage a SQL Server database and its data. The chapter also introduces you to the SQL Server programming tools that allow you to use Transact-SQL to interface with the database.

    Chapter 3: Designing a SQL Server Database

    introduces you to the process of creating a SQL Server database. It describes the basic concepts of database design and provides information about planning a database, identifying system requirements, and developing a logical data model.

    Chapter 4: Implementing SQL Server Databases and Tables

    explains how to create and manage a SQL Server database. It then discusses data types and how to identify which ones to use when creating a table. The chapter also describes how to create these tables—using the data type information—and how to modify the tables after they have been created.

    Chapter 5: Implementing Data Integrity

    provides an overview of the various methods that you can use to maintain data integrity and a description of the types of data integrity that you will find in a SQL Server database. The chapter also provides detailed information about the various types of integrity constraints that you can use to enforce data integrity and how to implement them in a database.

    Chapter 6: Accessing and Modifying Data

    provides detailed information about four Transact-SQL statements (SELECT, INSERT, UPDATE, and DELETE) and describes how each statement is used in Query Analyzer to retrieve and modify data. This chapter also introduces you to other methods for adding, modifying, and deleting data.

    Chapter 7: Managing and Manipulating Data

    describes more techniques for managing and manipulating data, including how to import and export data, how to manipulate heterogeneous data, how to use Transact-SQL cursors, and how to extract data in XML format.

    Chapter 8: Implementing Stored Procedures

    introduces you to the types of stored procedures available in SQL Server 2012 and how to create, execute, and alter them. You are also introduced to programming stored procedures.

    Chapter 9: Implementing Triggers

    introduces you to triggers and how to use them to extend data integrity and implement complex business logic. You will learn when it is appropriate to implement triggers and when basic constraints will suffice. You will also learn how to program triggers and how to use system commands and functions commonly used in trigger programming.

    Chapter 10: Implementing Views

    introduces you to views and the various functionality that they support. You will learn how to use views to insert, update, and modify data.

    Chapter 11: Implementing Indexes

    introduces you to the structure and purpose of indexes and the types and characteristics of indexes. You will learn how to determine when an index is appropriate, the type of index to create, and how to create it.

    Chapter 12: Managing SQL Server Transactions and Locks

    introduces you to the fundamentals of transactions and locks and describes how transactions and locks are used to process data modifications.

    Chapter 13: Designing and Administering SQL Server 2012 Security

    introduces you to SQL Server security. You will learn how to design SQL Server security to accommodate user requirements and protect the database from unauthorized access.

    Chapter 14: SQL Server Monitoring and Tuning

    examines how to use SQL Profiler to monitor a database system and explores methods of improving database performance through partitioning and index tuning.

     

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 10 Days

    Advanced Course Search Widget

    Popular Courses

    Recent Posts