SQL Server Development Fundamentals

Course Summary

Training levelSQL Server Foundation Courses
Duration3 days / 24 Hours
Delivery methodIn Class
Level200
LanguageBulgarian/English
List price450 Euro VAT Excl.

Click Tabs for Detailed info

SQL Server Fundamentals courses give you an excellent base for successful career as administrator or data base developer. Their practical purpose, use of scenarios of working practice will help both the beginners, as well as the more experienced students to protect in a better way the data of their organizations, to react quicker and adequate to all issues, which are data base related, and to avoid following some harmful myths and wrong concepts in administration and data base development.

  • 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
  • • To write an appropriate and correct T-SQL code
    • To protect against Use of improper practices when writing code
    • To read and create objects in the program, and can use the facilities suitable for
    • Know and use appropriate data types
    • Know indexes and their structure and use
    •Understand the different types of JOIN, sub-queries, CTE, Windowing functions and when and how to use your
    • Understand the principles of generating Execution Plans, and to rely on simple query execution plan and find the connection between the way of writing queries and their execution plans
    • Understand when and how to use Dynamic SQL
    • Know the non-relational data in SQL Server
    • To know the mechanism of work transactions, isolation levels and locks, and write code that minimizes blocking problems
    • Be able to implement proper error handling in SQL code
    • To know how to load data to be able to implement bulk load operations with minimal resources and locks
    • Plan and test your application and scripts
  • SQL Server and T-SQL Overview
  • The SELECT module
  • Joins and Subqueries
  • Introduction to Data Types, Tables and Constraints
  • Indexing Fundamentals
  • Foundations of Query Execution and Reading Query Plans
  • Dynamic SQL, specific constructs and their usage
  • T-SQL Programming Objects Fundamentals – Views, Stored Procedures, Triggers, Functions
  • Foundations of Data Modifications, Data Loading and Error Handling
  • Transactions and Lock Management
  • 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