SQL Server Development Fundamentals

Course Summary

Training levelSQL Server Fundamental Courses
Duration5 days (40 hours)
Delivery methodIn class
Level200
LanguageBulgarian/English
List price750 Euro VAT excl.

Click Tabs for Detailed info

Тhe class is designed for new specialist in role of Database Developers and gives a good understanding of SQL Server product for a very successful career start. The course focuses teaching individuals on how to use SQL Server product features and tools related to developing a database. This is a very practically oriented class with numerous exercises and examples.

  • New specialists in role of DBAs/Devs;
  • Professionals working with other technology platforms
  • DB Specialists coming from versions earlier than SQL Server 2008
  • Developers who are willing to fill the gaps in their T-SQL knowledge and build a good understanding of SQL Server product
  • Write a good T-SQL code
  • Protect against use of bad practices when writing code, and code that leads to performance problems
  • Understand and use appropriate data types, understand indexes, their structure and use cases
  • Understand the different types of JOIN, sub-queries, CTE, Windowing functions and when and how to use them
  • Understand the principles of generating Execution Plans, reading and troubleshooting simple plans
  • Develop programming objects in a database and understand their use cases
  • Understand Transactions and SQL Server Locking architecture

Module 1. SQL Server and T-SQL Overview

Module 2. The SELECT module

Module 3. Joins and Subqueries

Module 4. Introduction to Data Types, Tables and Constraints

Module 5. Indexing Fundamentals

Module 6. Foundations of Query Execution and Reading Query Plans

Module 7. Dynamic SQL, specific constructs and their usage

Module 8. T-SQL Programming Objects Fundamentals-Views, Stored Procedures, Triggers, Functions

Module 9. Foundations of Data Modifications, Data Loading and Error Handling

Module 10. Transactions and Lock Management

Module 11. InMemory OLTP Concept

Next planned dates:

Trainer: Rozalina Zaharieva

rozi_portrait

Reserve your seat





Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date
Days
Hours
Minutes
Seconds