The SQL Server Database Design and Development course provides step-by-step instructions on how to develop an understanding of the database design and development process, as well as the models used in each phase of the development lifecycle. You'll develop the skills to model and understand the database development lifecycle based on real life examples, while mapping the objects and engineer the logical model to a relational model.
On successful Completion of this course you will be able to:
Understand Relational Database Concepts
Understand Types of Databases Models
Understand Gathering Requirements for Database Design
Understand the Stages of Database system Development
Designing and implementing normalized database schemas
Understand SQL Server Data Tools
Writing SELECT queries
Sorting and filtering data
Using SQL aggregate functions
Using SET operators
Writing joins to query multiple tables
Using built-in functions
Using Subqueries
Inserting, updating, deleting and merging rows
Transaction control
Creating and using views
Using table expressions
Enhanced Grouping and Pivoting data
Using Windowing ranking, offset and ranking functions
Creating and using Stored Procedures
Controlling Program Flow
Using Dynamic SQL
Implementing Error Handling
Improving Query Performance
Course Requirements
Prerequisites
Some knowledge of Database Management Systems
Target Audience
Audience
Systems Analyst
Database Developers
Application Developers
Software Architects