This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Target Audience

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

This course provides an in-depth understanding of the design and structure of SQL databases and database objects. Delegates who are looking for a more practical course with a focus on searching and managing data in SQL databases are advised to look at our QATSQL 'Querying SQL Databases using T-SQL' and 'Advanced Querying SQL Databases using T-SQL' QATSQLPLUS or Microsoft official curriculum M20761 'Querying Data with Transact-SQL' courses

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

This is a foundation level course and therefore only requires general computer literacy.

What You Will Learn

After completing this course, students will be able to:

Describe key database concepts in the context of SQL Server 2016
Describe database languages used in SQL Server 2016
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects

Training Outline

Module 1: Introduction to databases

This module introduces key database concepts in the context of SQL Server 2016.

Lessons

Introduction to relational databases
Other types of database
Data analysis
Database languages

Lab : Querying SQL Server

Module 2: Data Modelling

This module describes data modelling techniques.

Lessons

Data modelling
ANSI/SPARC database model
Entity relationship modelling

Lab : Entity relationship modelling

Module 3: Normalization

This module describes normalization and denormalization techniques.

Lessons

Why normalize data?
Normalization terms
Levels of normalization
Denormalization

Lab : Normalizing raw data

Module 4: Relationships

This module describes relationship types and effects in database design.

Lessons

Schema mapping
Referential integrity

Lab : Designing relationships

Module 5: Performance

This module introduces the effects of database design on performance.

Lessons

Indexing
Query performance
Concurrency

Lab : Query performance

Module 6: Database Objects

This module introduces commonly used database objects.

Lessons

Tables
Views
Stored procedures
Other database objects

Lab : Using SQL Server in a hybrid cloud

Why Choose Us

Experience Introduction to SQL Databases through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.

Live Instructor-Led Sessions: Join scheduled training sessions with your instructor and fellow delegates in real time.
Interactive Learning Experience: Take part in discussions, practical exercises, group activities, and Q&A sessions throughout the course.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's long-standing experience in delivering professional training since 1995.
Flexible and Scalable Delivery: Access live virtual classrooms worldwide with flexible planning options for individual and corporate training needs.

Experience Introduction to SQL Databases in a focused classroom environment designed for high engagement and effective learning. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.

Experienced Trainers: Learn from specialists with extensive field experience and real-world knowledge.
Professional Training Venues: Attend courses in comfortable, well-equipped classrooms designed to support effective learning.
Focused Classroom Experience: Benefit from limited class sizes that encourage discussion, interaction, and personalized support.
Quality-Driven Learning: Develop practical skills through structured, up-to-date, and professionally designed training content.

Meet your team's training needs with Bilginç IT Academy's onsite Introduction to SQL Databases solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.

Tailored Course Content: Adapt the training program to your organization's projects, team structure, and specific business requirements.
Time and Cost Efficiency: Reduce travel, accommodation, and operational costs while maximizing the value of your training investment.
Team-Focused Learning: Help your employees develop around the same knowledge base and strengthen collaboration across your organization.
Simplified Planning and Tracking: Manage the training process, participant development, and organizational requirements with greater control.

I. T. - masak / AgeSA Hayat ve Emeklilik A.Ş.

It was excellent that the instructor answered all our questions and provided detailed and satisfactory answers while explaining the topics. Thank you.

N. O. - müdür / AgeSA Hayat ve Emeklilik A.Ş.

Thank you to the instructor for the wonderful training; it's the first time I've learned so much so quickly about a subject I knew nothing about.

G. G. - Kıdemli Uzman / AgeSA Hayat ve Emeklilik A.Ş.

Both the training and the instructor were very knowledgeable and active; thank you for this wonderful experience.

O. T. - KIDEMLİ ANALİZ TEST UZMANI / AgeSA Hayat ve Emeklilik A.Ş.

Our professor, in particular, has an exceptional command of the subject. I thank him very much.

S. Y. - Risk Değerlendirme Uzmanı / AgeSA Hayat ve Emeklilik A.Ş.

Thank you. The training was quite good.

A. A. - Kıdemli Uzman - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

B. B. - Mevzuat Yönetmeni - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

A. T. - Kıdemli uzman - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

E. E. - Teknik Raporlama - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

E. A. - Kıdemli Uzman - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

G. S. Y. - Kıdemli Uzman - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

U. S. - BES Mevzuat Uyarlama, Gözetim ve Raporlama Kıdemli Uzman - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

A. Ö. - KIDEMLİ UZMAN - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

E. B. - Operasyon Kıdemli Uzman - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

H. B. D. - Fon Yönetimi Yönetmen - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

K. G. - Hazine ve Nakit Yönetimi Müdür - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

O. Y. - Süreç Uyum ve Test - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

A. K. - Test Analisti - AgeSA Hayat ve Emeklilik A.Ş.

Rated the training 5 stars.

A. N. Ü. - Yetkili - ANADOLU HAYAT EMEKLİLİK

Rated the training 5 stars.

B. E. - II.Müdür - ANADOLU HAYAT EMEKLİLİK

Rated the training 5 stars.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Introduction to SQL Databases Training

Target Audience

Prerequisites

What You Will Learn

Training Outline

Why Choose Us