Introduction to SQL

Formation inter-entreprise

Niveau atteint

Débutant

Durée

 3,00 jour(s)

Langue(s) de prestation

EN FR RO

Prochaine session

Qui organise cette formation ?

Uprise Development is a seasoned IT service provider catering to diverse business sectors, boasting over 20 years of experience. Our comprehensive offerings include tailored IT solutions, consulting, and services aimed at delivering unparalleled value and excellence to meet your business needs. In addition to our IT expertise, we are committed to empowering organizations and companies to unleash their full potential through dedicated software solutions and transformative training programs. Our vision is to emerge as the premier IT service provider in Luxembourg, seamlessly translating your business goals into innovative software solutions, while also offering extensive training opportunities to foster professional and personal growth.

À qui s'adresse la formation?

The SQL course caters to individuals at a beginner level or possessing a foundational understanding, making it suitable for adults seeking to transition into the IT field, as well as students and high school teenagers.

Prérequis

No prerequisites are necessary for enrollment.

Objectifs

The key topics covered include:

  • Querying Data: Emphasizing the essential skill of extracting and comprehending data in a relational format through SQL queries, covering clauses such as select, from, where, order by, group by, and having.
  • Data Manipulation: Exploring the insertion, modification, and deletion of data within relational databases, involving SQL instructions such as insert, update, and delete.
  • Database Structure and Constraints: Instructing students on creating and modifying table structures, including constraints such as primary key, unique, check, and foreign key for ensuring data integrity and consistency.
  • Advanced Topics: Extending the course to encompass additional database objects like views, sequences, and synonyms, alongside an introduction to programming extensions of SQL such as PL SQL for Oracle and Transact SQL for SQL Server.
  • Importance of Database Knowledge: Highlighting the necessity for understanding both SQL and its extensions, particularly for individuals involved in database programming roles, while acknowledging that proficiency in SQL alone may suffice for certain roles such as analysts or testers.

Contenu

This three-day instructor-led course caters to individuals aspiring to assume a database professional role or broaden their current job scope to include database-related functions. The course delves into fundamental database concepts, covering database types, languages, and designs.

Module 1: Introduction to Databases

This module provides an overview of key database concepts within the context of SQL Server 2016.

Module 2: Data Modeling

Participants will explore data modeling techniques in this module.

Module 3: Normalization

This module delves into normalization and denormalization techniques.

Module 4: Relationships

Participants will learn about relationship types and their effects on database design in this module.

Module 5: Performance

This module examines the impact of database design on system performance.

Module 6: Database Objects

Participants will be introduced to commonly used database objects in this module.

Certificat, diplôme

SQL Basic Certificate