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

For corporate groups, we can organize this training as an on-site private group.

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

Leading UK-based global training provider since 1995.

Experience Introduction to SQL Databases in Global through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
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 professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from Global or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Introduction to SQL Databases through face-to-face Classroom Based training in Global. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Introduction to SQL Databases in Global as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Arrange the training in Global or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.

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.

Introduction to SQL Databases Training in Global

Target Audience

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Introduction to SQL Databases Training Course in Global Schedule

Blog posts related to Introduction to SQL Databases Training Course in Global

Introduction to SQL Databases Training in Global

Target Audience

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Online Instructor-Led Training

Classroom Based Training

Onsite Training

Training Reviews

Introduction to SQL Databases Training Course in Global Schedule

Blog posts related to Introduction to SQL Databases Training Course in Global

WHAT IS SQL DATA WAREHOUSE?

SQL VS NOSQL