This course is designed to help experienced database developers deepen their expertise in Microsoft SQL Server development. You’ll explore advanced database design principles, optimize queries for performance, and apply best practices in schema design, concurrency, and maintainability.
As applications become more data-driven, the role of the database developer expands beyond writing basic queries. In this course, you’ll work with real scenarios to normalize schemas, prevent data anomalies, implement transactions safely, and write efficient and maintainable T-SQL code. The focus is on building robust, scalable, and high-performance database applications with SQL Server.
Key takeawaysAfter completing this course, participants will be able to:
PrerequisitesRecommended:
Target audienceThis course is ideal for:
Participants explore normalization, schema refinement, and strategies to prevent data anomalies and redundancy.
This section focuses on writing complex queries, using subqueries, CTEs, window functions, and modular T-SQL components like stored procedures and functions.
Learn how indexing strategies affect query performance, and how to analyze and tune execution plans for efficiency.
This topic covers transaction scopes, isolation levels, and how to implement robust error handling to maintain data integrity.
Participants gain insight into SQL Server’s concurrency control mechanisms, locking behavior, and how to manage and minimize contention.
This section explores advanced programming patterns with stored procedures, user-defined functions, and triggers to enforce business rules.
Learn how to apply best practices to tune queries, handle large datasets, and design for performance and maintainability.
The course includes case studies and exercises focused on typical development challenges seen in enterprise applications.
We arrange this training for your company or departement upon request. Please contact us for dates and prices: itpro@glasspaper.no
Do I need to be an experienced SQL developer to take this course?
Yes. This course is designed for developers with solid foundational SQL knowledge.
Will this course improve my query performance skills?
Absolutely. A significant part of the training focuses on performance and optimization techniques.
Is this course hands-on?
Yes. Practical labs and real-world exercises are part of the course.
Will this course prepare me for a certification exam?
No. This course is not tied to a single certification, but it enhances practical SQL Server developer skills.
How long is the course?
The course is typically delivered over three days.
Is there a follow-up course?
Depending on your focus, advanced performance or high availability classes may be good next steps.
