Descrizione:Questo corso di cinque giorni con istruttore, fornisce agli studenti le conoscenze e le abilità per sviluppare un Database Microsoft SQL Server.Il corso si focalizza sull'insegnare agli individui come usare SQL Server le caratteristiche e gli strumenti relativi allo sviluppo di un database.
A chi è rivolto: Il pubblico principale di questo corso è costituito da professionisti IT che desiderano acquisire competenze sulle funzionalità e sulle tecnologie dei prodotti SQL Server per l'implementazione di un database. I destinatari secondari di questo corso sono le persone che sono sviluppatori di altre piattaforme di prodotti che desiderano diventare esperti nell'implementazione di un database SQL Server.
• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
Module 1: Introduction to Database Development
Before beginning to work with Microsoft SQL Server in either a development or an administration role, it is important to understand the scope of the SQL Server platform. In particular, it is useful to understand that SQL Server is not just a database engine—it is a complete platform for managing enterprise data. SQL Server provides a strong data platform for all sizes of organizations, in addition to a comprehensive set of tools to make development easier, and more robust.
Module 2: Designing and Implementing Tables
In a relational database management system (RDBMS), user and system data is stored in tables. Each table consists of a set of rows that describe entities and a set of columns that hold the attributes of an entity. For example, a Customer table might have columns such as CustomerName and CreditLimit, and a row for each customer. In Microsoft SQL Server data management software tables are contained within schemas that are very similar in concept to folders that contain files in the operating system. Designing tables is one of the most important tasks that a database developer undertakes, because incorrect table design leads to the inability to query the data efficiently. After an appropriate design has been created, it is important to know how to correctly implement the design.
Module 3: Advanced Table Designs
The physical design of a database can have a significant impact on the ability of the database to meet the storage and performance requirements set out by the stakeholders. Designing a physical database implementation includes planning the filegroups, how to use partitioning to manage large tables, and using compression to improve storage and performance. Temporal tables are a new feature in SQL Server and offer a straightforward solution to collecting changes to your data.
Module 4: Ensuring Data Integrity through Constraints
The quality of data in your database largely determines the usefulness and effectiveness of applications that rely on it—the success or failure of an organization or a business venture could depend on it. Ensuring data integrity is a critical step in maintaining high-quality data. You should enforce data integrity at all levels of an application from first entry or collection through storage. Microsoft SQL Server data management software provides a range of features to simplify the job.
Module 5: Introduction to Indexes
An index is a collection of pages associated with a table. Indexes are used to improve the performance of queries or enforce uniqueness. Before learning to implement indexes, it is helpful to understand how they work, how effective different data types are when used within indexes, and how indexes can be constructed from multiple columns. This module discusses table structures that do not have indexes, and the different index types available in Microsoft SQL Server.
Module 6: Designing Optimized Index Strategies
Indexes play an important role in enabling SQL Server to retrieve data from a database quickly and efficiently. This module discusses advanced index topics including covering indexes, the INCLUDE clause, query hints, padding and fill factor, statistics, using DMOs, the Database Tuning Advisor, and Query Store.
Il corso prosegue con i moduli:
Module 7: Columnstore Indexes - Module 8: Designing and Implementing Views Module 9: Designing and Implementing Stored Procedures Module 10: Designing and Implementing User-Defined Functions Module 11: Responding to Data Manipulation via Triggers Module 12: Using In-Memory Tables Module 13: Implementing Managed Code in SQL Server Module 14: Storing and Querying XML Data in SQL Server Module 15: Storing and Querying Spatial Data in SQL Server Module 16: Storing and Querying BLOBs and Text Documents in SQL Server Module 17: SQL Server Concurrency Module 18: Performance and Monitoring