Database programming with T-SQL
The reliability, accuracy, continuity, and quick accessibility of data for the necessary parties, the prevention of additional costs through the selection of the right technology, minimizing human error through task automation, the creation of backup procedures to prevent data loss, the scalability of technology during growth, and the ability to migrate data at any time are crucial topics in Data Management. This training program will teach you fundamental concepts, advanced techniques, and practical applications in Database Management with ease. After the training, you will possess the essential technical knowledge to work as a database and data warehouse consultant, data engineer, BI developer, data analyst, data architect, or database administrator. This training will serve as the perfect starting point for joining the ranks of valuable and highly sought-after engineers who contribute to the magical world of Database Management.
Training table
Information about the training
In the era of rapidly growing Data Analytics and Artificial Intelligence, companies that do not have proper Data Management and place it as a secondary priority have experienced significant losses. Nowadays, most companies are starting to fully understand the importance of data management. Data Management ensures accurate, fast, secure, cost-effective, and reliable access to data. Without these, there can be no talk of analytics or artificial intelligence. In the Data Management training program, you will learn the fundamental concepts of Database Management using Microsoft SQL Server technology. Participants will learn to create procedures and functions, manage database errors, and optimize database performance using T-SQL. The training will cover important topics such as creating triggers and transactions, scheduling SQL tasks, index design, and scalability. This hands-on approach will transform participants into professionals in SQL Server Database Management and help them build a successful career in a short period of time.
Who is this training for?
- Data leaders
- Data analysts
- Data engineers
- Programmers
- Data science specialists
- Students
Certificate
It provides a certificate to those who complete the training as Certified Data Scientist and others. You can see a sample certificate on the right.
Introduction to T SQL
Introduction to T SQL
utorialsPoint
T SQL(Transact SQL) is an extension of SQL used in Microsoft SQL Server and Sybase ASE databases.
Syllabus
Session 1
Creating Procedures
What is T-SQL?
Defining Variables
Creating, Executing, Modifying, and Deleting Procedures
Using Parameters in Procedures: Input, Output, and Other Parameters
Error Handling in Procedures
Case Study 1
Creating Procedures and Implementing Error Handling in a Financial Database
Session 2
Functions & Triggers
Creating Functions
System vs. User-Defined Functions
Table & Single-Value Functions
Dynamic SQL
Introduction to Triggers, Constraints vs. Triggers
Creating, Modifying, and Deleting Triggers
For, After, Instead Of Triggers
Creating DML Triggers
Creating DDL and Database Event Triggers
Managing Triggers
Case Study 2
Creating Functions, Triggers, and Constraints in an E-commerce Database
Session 3
Transactions and Jobs
Introduction to Transactions
Isolation Levels in Transactions
Error Handling in Transactions
Locks and Deadlocks in Transactions
Commit, Rollback, Savepoint
Creating and Scheduling Jobs
Creating and Managing Daily Database Maintenance Jobs
Database Notifications
Case Study 3
Improving Efficiency and Reliability in an E-commerce Database using Transactions and Automated Jobs
Session 4
Database Performance Tuning
Basic SQL Tuning Rules
Database Performance Monitoring and Troubleshooting
Introduction to Indexes
Index Design
Reviewing SQL Server Execution Plans
Case Study 4
Performance Optimization of a Hospital Database using Basic SQL Tuning, Troubleshooting, Index Design, and Other Methods
Session 5
Advanced Database Techniques and Optimization
SQL Server Physical Joins (Nested Loop, Merge Join, Hash Join)
SQL Server Database Statistics
Table Partitioning (Range, List, Hash, or Composite Partitioning)
Parameter Sniffing
Data Loading Optimization
Scalability and High Availability
Case Study 5
Improving Database Performance in an Online Retail Database by Applying Physical Joins, Table Partitioning, and Parameter Sniffing
Trainers
Bahruz Gasimov
EXPERT FOR DATA QUALITY AND ASSURANCE MANAGEMENT, PASHA BANKOur professional trainer Bahruz Gasimov currently works as an “Expert in Data Quality and Assurance Management” at Pasha Bank. He has also worked in the data field at companies such as TuranBank OJSC, Yapı Kredi Bank Azerbaijan, and Unibank, and has over 14 years of professional work experience.