20762 Developing SQL Databases

Are you looking for hands-on experience developing a Microsoft SQL Server database? Complete this course from Network Technology Academy to confidently take the next step in your database career. In the Developing SQL Databases course, you will learn how to use SQL Server 2016 features and tools and gain the knowledge and skills to develop a SQL Server database.

After finishing this course, you’ll master key concepts involved in developing and managing SQL Server databases. You’ll be able to implement SQL views, indexes and tables. This course empowers you to:

  • Design and implement tables
  • Confidently speak about advanced table designs
  • Ensure data integrity through constraints
  • Describe indexes, including optimized and columnstore indexes
  • Work with spatial data
  • Address data manipulation using triggers
  • Execute managed code in SQL Server
  • Store and query XML data, BLOBs and text documents
  • Design and implement views, stored procedures, user-defined functions and in-memory tables

Course Outline
1 - INTRODUCTION TO DATABASE DEVELOPMENT
  • Navigate the SQL Server Platform
  • Perform SQL Server Database Development Tasks
2 - DESIGNING & IMPLEMENTING TABLES
  • Design, Create and Alter Tables
  • Understand the Different Data Types
  • Create and Manage Schemas
  • Lab: Designing and implementing tables
3 - ADVANCED TABLE DESIGNS
  • Partition and Compress Data
  • Create Temporal Tables
  • Lab: Using advanced table designs
4 - ENSURING DATA INTEGRITY THROUGH CONSTRAINTS
  • Enforce Data Integrity
  • Add and Test Constraints
  • Implement Data Domain, Entity and Referential Integrity
  • Lab: Using Data Integrity Through Constraints
5 - INTRODUCTION TO INDEXES
  • Understand Core Indexing Concepts
  • Learn about Data and Index Types – Including Heaps, Clustered, Nonclustered, Single Column and Composite Indexes
  • Develop Heaps and Clustered and Covered Indexes
  • Lab: Implementing Indexes
6 - DESIGNING OPTIMIZED INDEX STRATEGIES
  • Learn About Index Strategies, Managing Indexes and Execution Plans
  • Work with the Database Engine Tuning Advisor
  • Use the Query Store to Identify and Fix Queries
  • Lab: Optimizing Indexes
7 - COLUMNSTORE INDEXES
  • Interpret, Create and Work with Columnstore Indexes
  • Build a Memory Optimized Columnstore Table
  • Lab: Using Columnstore Indexes
8 - DESIGNING AND IMPLEMENTING VIEWS
  • Create and Manage Views
  • Understand Performance Considerations for Views
  • Set up Standard and Updateable Views
  • Lab: Designing and Implementing Views
9 - DESIGNING AND IMPLEMENTING STORED PROCEDURES
  • Create and Work with Stored Procedures
  • Build and Implement Parameterized Stored Procedures
  • Control Execution Context
  • Lab: Designing and Implementing Stored Procedures
10 - DESIGNING AND IMPLEMENTING USER-DEFINED FUNCTIONS
  • Understand the Types of Functions, Alternatives and Key Considerations for Implementation
  • Design and Implement Scalar and Table-Valued Functions
  • Lab: Designing and Implementing User-Defined Functions
11 - RESPONDING TO DATA MANIPULATION VIA TRIGGERS
  • Design and Implement DML Triggers
  • Learn about Advanced Trigger Concepts
  • Create, Test and Improve Audit Triggers
  • Lab: Responding to Data Manipulation by Using Triggers
12 - USING IN-MEMORY TABLES
  • Work With Memory-Optimized Tables
  • Establish Natively Compiled Stored Procedures
  • Lab: Using In-Memory Database Capabilities
13 - IMPLEMENTING MANAGED CODE IN SQL SERVER
  • Learn about CLR Integration in SQL Server
  • Implement and Publish CLR Assemblies
  • Lab: Implementing Managed Code in SQL Server
14 - STORING AND QUERYING XML DATA IN SQL SERVER
  • Understand XML and XML Schemas
  • Store XML Data and Schemas in SQL Server
  • Implement the XML Data Type
  • Use the Transact-SQL FOR XML Statement
  • Get Started with XQuery and Shredding XML
  • Lab: Storing and Querying XML Data in SQL Server
15 - STORING AND QUERYING SPATIAL DATA IN SQL SERVER
  • Store and Query Spatial Data
  • Work with SQL Server Spatial Data Types
  • Apply Spatial Data to Applications
  • Lab: Working with SQL Server Spatial Data
16 - STORING AND QUERYING BLOBS AND TEXT DOCUMENTS IN SQL SERVER
  • Understand Considerations for Working with BLOB Data
  • Store Unstructured Data Using FILESTREAM
  • Perform Full-Text Searches
  • Lab: Storing and Querying BLOBs and Text Documents in SQL Server
17 - SQL SERVER CONCURRENCY
  • Learn how to Create Concurrency in SQL Server
  • Execute Transactions and Lock Internals to Establish Concurrency
  • Lab: SQL Server Concurrency
18 - PERFORMANCE AND MONITORING
  • Work with Extended Events
  • View and Interpret Live Query Statistics and Metrics
  • Optimize Database File Configuration
  • Lab: Monitoring, Tracing, and Baselining

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

All class times shown are in Pacific Standard Time (PST)
This course is SATV-Eligible

Contact Us For Price

Course Length: 5 Days

1. Choose a Date | 2. Click Enroll Now
Need Help Picking the Right Course? Give us a call! 781-388-0026
Awaiting product image

Description

After finishing this course, you’ll master key concepts involved in developing and managing SQL Server databases. You’ll be able to implement SQL views, indexes and tables.

This course empowers you to:

  • Design and implement tables
  • Confidently speak about advanced table designs
  • Ensure data integrity through constraints
  • Describe indexes, including optimized and columnstore indexes
  • Work with spatial data
  • Address data manipulation using triggers
  • Execute managed code in SQL Server
  • Store and query XML data, BLOBs and text documents
  • Design and implement views, stored procedures, user-defined functions and in-memory tables

Reviews

There are no reviews yet.

Be the first to review “20762 Developing SQL Databases”

Your email address will not be published. Required fields are marked *

Related products

© Copyright - Network Technology Academy
20761 Querying Data with Transact SQL 20764 Administering a SQL Database Infrastructure