Corso Implementing a Microsoft SQL Server 2008 R2 Database 2008 SpecialistThecla Informatica
Chiedi il prezzo
Cosa impari in questo corso?
Microsoft SQL Server
Nessun prerequisito richiesto Module 1: Introduction to SQL Server and its Toolset This module introduces you to the entire SQL Server platform and its major tools. This module also covers editions, versions, basics of network listeners, and concepts of services and service accounts. Lessons Introduction to SQL Server Platform Working with SQL Server Tools Configuring SQL Server Services Lab : Introduction to SQL Server and its Toolset Verifying SQL Server Component Installation Altering Service Accounts for New Instance Enabling Named Pipes Protocol for Both Instances Creating Aliases for AdventureWorks and Proseware Ensuring SQL Browser is Disabled and Configure a Fixed TCP/IP Port After completing this module, students will be able to: Describe the SQL Server Platform. Work with SQL Server Tools. Configure SQL Server Services. Module 2: Working with Data Types This module describes the data types supported by SQL Server and how to work with them. Lessons Using Data Types Working with Character Data Converting Data Types Working with Specialized Data Types Lab : Working with Data Types Choosing Appropriate Data Types Writing Queries With Data Type Conversions Designing and Creating Alias Data Types After completing this module, students will be able to: Work with data types. Work with character data. Convert between data types. Use specialized data types. Module 3: Designing and Implementing Tables This module describes the design and implementation of tables. Lessons Designing Tables Working with Schemas Creating and Altering Tables Lab : Designing and Implementing Tables Improving the Design of Tables Creating a Schema Creating the Tables After completing this module, students will be able to: Design tables. Work with schemas. Create and alter tables. Module 4: Designing and Implementing Views This module describes the design and implementation of views. Lessons Introduction to Views Creating and Managing Views Performance Considerations for Views Lab : Designing and Implementing Views Designing, Implementing and Testing the WebStock Views Designing and Implementing the Contacts View Modifying the AvailableModels View After completing this module, students will be able to: Explain the role of views in database development. Implement views. Describe the performance related impacts of views. Module 5: Planning for SQL Server Indexing This module describes the concept of an index and discusses selectivity, density, and statistics. It covers appropriate data type choices and choices around composite index structures. Lessons Core Indexing Concepts Data Types and Indexes Single Column and Composite Indexes Lab : Planning for SQL Server Indexing Exploring Existing Index Statistics Designing Column Orders for Indexes After completing this module, students will be able to: Explain core indexing concepts. Describe the effectiveness of each data type common used in indexes. Plan for single column and composite indexes. Module 6: Implementing Table Structures in SQL Server This module covers clustered indexes and heaps. Lessons SQL Server Table Structures Working with Clustered Indexes Designing Effective Clustered Indexes Lab : Implementing Table Structures in SQL Server Creating Tables as Heaps Creating Tables with Clustered Indexes Comparing the Performance of Clustered Indexes vs. Heaps After completing this module, students will be able to: Explain how tables can be structured in SQL Server databases. Work with clustered indexes. Design effective clustered indexes Module 7: Reading SQL Server Execution Plans This module introduces the concept of reading execution plans. Lessons Execution Plan Core Concepts Common Execution Plan Elements Working with Execution Plans Lab : Reading SQL Server Execution Plans Actual vs. Estimated Plans Identify Common Plan Elements Query Co Corso di gruppo Corso personalizzato (1 o 2 partecipanti) 40 ore 40 ore (consigliate) min. 5 - max. 10 partecipanti 2 persone: sconto del 50% Corso individuale a distanza su VoIP non previsto