18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

20762:Developing SQL Databases Training


What 20762:Developing SQL Databases training is all about?

20762: Developing SQL Databases Training helps professionals gain the important skills and knowledge to build an MS SQL Server 2016 database. This technical course's focus is to teach professionals how to utilize SQL Server 2016 product tools and features related to building a database. It teaches them the techniques to design and apply tables and demonstrate advanced table designs. Professionals will also learn to describe indices, which include Column store and Optimizes indices. This training program is ideal for IT Professionals who want to develop their skills and knowledge of SQL Server 2016 technologies and products for implementing a database. It is also suitable for individuals who are into other product platforms and want to develop skills in the implementation of a SQL Server 2016 database. By the end of this course, trainees will know the methodology to respond to data manipulation and design Store Procedures.

Schedule
  • Delivery Format:
Date: Oct 26, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$2875 USD
  • Delivery Format:
Date: Dec 14, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$2875 USD
What are the course objectives for 20762:Developing SQL Databases training?
  • Designing and Implementing Tables.
  • Describing advanced table designs
  • Ensuring Data Integrity Constraints.
  • Describing Column store and Optimized indexes
  • Designing and Implementing Views.
  • Designing and Implementing Stored Procedures.
  • Designing and Implementing User-Defined Functions.
  • Using triggers to respond to data manipulation.
  • Designing and Implementing In-Memory Tables.
  • Implementing Managed Code within SQL Server.
  • Query and Store XML Data.
  • Working with Spatial Data.
  • Store and Query Text Documents and Blobs.
Who should attend 20762:Developing SQL Databases training?

The course is well versed for IT workers wanting to upgrade their skills on product features and technologies of SQL Server to implement databases. Individual developers of other platforms and products looking to broaden their knowledge in SQL Server databases can take this course as well.

What are the prerequisites for 20762:Developing SQL Databases training?
  • Knowledge of Microsoft Windows operating system and core functionality
  • Knowledge of Transact-SQL and relational databases
What is the course outline for 20762:Developing SQL Databases training?
  • 1. Introduction to Database Development
  • a). Introduction to the SQL Server Platform
  • b). SQL Server Database Development Tasks
  • 2. Designing and Implementing Tables
  • a). Designing Tables
  • b). Data Types
  • c). Working with Schemas
  • d). Creating and Altering Tables
  • e). Lab : Designing and Implementing Tables
  • 3. Advanced Table Designs
  • a). Partitioning Data
  • b). Compressing Data
  • c). Temporal Tables
  • d). Lab : Using Advanced Table Designs
  • 4. Ensuring Data Integrity through Constraints
  • a). Enforcing Data Integrity
  • b). Implementing Data Domain Integrity
  • c). Implementing Entity and Referential Integrity
  • d). Lab : Using Data Integrity Through Constraints
  • 5. Introduction to Indexes
  • a). Core Indexing Concepts
  • b). Data Types and Indexes
  • c). Heaps, Clustered, and Nonclustered Indexes
  • d). Single Column and Composite Indexes
  • e). Lab : Implementing Indexes
  • 6. Designing Optimized Index Strategies
  • a). Index Strategies
  • b). Managing Indexes
  • c). Execution Plans
  • d). The Database Engine Tuning Advisor
  • e). Query Store
  • f). Lab : Optimizing Indexes
  • 7. Columnstore Indexes
  • a). Introduction to Columnstore Indexes
  • b). Creating Columnstore Indexes
  • c). Working with Columnstore Indexes
  • d). Lab : Using Columnstore Indexes
  • 8. Designing and Implementing Views
  • a). Introduction to Views
  • b). Creating and Managing Views
  • c). Performance Considerations for Views
  • d). Lab : Designing and Implementing Views
  • 9. Designing and Implementing Stored Procedures
  • a). Introduction to Stored Procedures
  • b). Working with Stored Procedures
  • c). Implementing Parameterized Stored Procedures
  • d). Controlling Execution Context
  • e). Lab : Designing and Implementing Stored Procedures
  • 10. Designing and Implementing User-Defined Functions
  • a). Overview of Functions
  • b). Designing and Implementing Scalar Functions
  • c). Designing and Implementing Table-Valued Functions
  • d). Considerations for Implementing Functions
  • e). Alternatives to Functions
  • f). Lab : Designing and Implementing User-Defined Functions
  • 11. Responding to Data Manipulation via Triggers
  • a). Designing DML Triggers
  • b). Implementing DML Triggers
  • c). Advanced Trigger Concepts
  • d). Lab : Responding to Data Manipulation by Using Triggers
  • 12. Using In-Memory Tables
  • a). Memory-Optimized Tables
  • b). Natively Compiled Stored Procedures
  • c). Lab : Using In-Memory Database Capabilities
  • 13. Implementing Managed Code in SQL Server
  • a). Introduction to CLR Integration in SQL Server
  • b). Implementing and Publishing CLR Assemblies
  • c). Lab : Implementing Managed Code in SQL Server
  • 14. Storing and Querying XML Data in SQL Server
  • a). Introduction to XML and XML Schemas
  • b). Storing XML Data and Schemas in SQL Server
  • c). Implementing the XML Data Type
  • d). Using the Transact-SQL FOR XML Statement
  • e). Getting Started with XQuery
  • f). Shredding XML
  • g). Lab : Storing and Querying XML Data in SQL Server
  • 15. Storing and Querying Spatial Data in SQL Server
  • a). Introduction to Spatial Data
  • b). Working with SQL Server Spatial Data Types
  • c). Using Spatial Data in Applications
  • d). Lab : Working with SQL Server Spatial Data
  • 16. Storing and Querying BLOBs and Text Documents in SQL Server
  • a). Considerations for BLOB Data
  • b). Working with FILESTREAM
  • c). Using Full-Text Search
  • d). Lab : Storing and Querying BLOBs and Text Documents in SQL Server
  • 17. SQL Server Concurrency
  • a). Concurrency and Transactions
  • b). Locking Internals
  • c). Lab : SQL Server Concurrency
  • 18. Performance and Monitoring
  • a). Extended Events
  • b). Working with extended Events
  • c). Live Query Statistics
  • d). Optimize Database File Configuration
  • e). Metrics
  • f). Lab : Monitoring, Tracing, and Baselining
FAQ's

Yes, you can use SATVs for 70-762 - Developing SQL Databases certification exam.

70-762 exam course is designed to help you get Microsoft certification for Developing SQL Databases.

Yes, it meets out the requirements for MCSA: SQL 2016 Database Development and MCSE: Data Management and Analytics certifications.

The 70-762 exam is structured to measure your skills in following domains:

  • Design and implement database objects
  • Implement programmability objects
  • Manage database concurrency
  • Optimize database objects and SQL infrastructure
  • 5 Days | $ 2875
    4.3
      243 Ratings

    1159 Learners