Home / Collections / Community courses / Introduction to SQL Databases - M55352A

Introduction to SQL Databases - M55352A

Cursos de SQL Server
€695.00
| /

________________________________________________________________

Do you want to take this course remotely or in person?

Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices

________________________________________________________________

Course: Introduction to SQL Databases

This course is intended for individuals seeking to enter a professional position in databases or whose position is expanding to include database elements.

The course describes fundamental database concepts, including database types, languages, and designs.

SQL Databases Course Duration
SQL Databases Training
Access to the SQL Databases course
Introduction to SQL Databases

Introductory SQL - Databases - SQL Server for Beginners - Data Modeling - Database Design - Data Management

Addressed to

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

Training objectives

This course is designed to provide students with:

  • Fundamental knowledge of SQL Server databases.
  • Skills to administer a database infrastructure.
  • Useful training for those developing applications that interact with SQL Server databases.
  • Understanding key concepts such as: Database structure, Basic queries, Security and maintenance, Performance optimization.


Course Content Introduction to SQL Databases

Module 1: Introduction to databases

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

Lessons

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

Lab: SQL Server Queries

Module 2: Data Modeling

This module describes data modeling techniques.

Lessons

  • Data modeling
  • ANSI/SPARC Database Model
  • Entity relationship modeling

Lab: Modeling Entity Relationships

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 the types of relationships and their effects on database design.

Lessons

  • Schema mapping
  • Referential integrity

Lab: Relationship Design

Module 5: Performance

This module presents the effects of database design on performance.

Lessons

  • Indexing
  • Query performance
  • Concurrence

Lab: Query Performance

Module 6: Database Objects

This module presents the most commonly used database objects.

Lessons

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Lab: Using SQL Server in a Hybrid Cloud


Prerequisites

  • Basic computer skills.
  • Familiarity with general database concepts.
  • No prior experience with SQL Server is required, but an interest in learning about database administration and development is.


Language

  • Course: English

  • Labs: English

Information related to training

Soporte siempre a tu lado

Training support: Always by your side

Always by your side

Modalidades Formativas

Do you need another training modality?

Self Learning - Virtual - In-person - Telepresence

bonificaciones

Bonuses for companies

For companies

Invitaciones a eventos y actividades de Nanfor

Register here to receive invitations to events and other Nanfor activities