SQL Server Database Design and Development

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