Introduction aux bases de données SQL Server 2016/2017

Reference : MS10985

3
jours - 1 815 € € HT Télécharger la fiche

Prochaines sessions

Introduction aux bases de données SQL Server 2016/2017

Objectifs

Découvrir les concepts clés de la base de données dans le contexte de SQL Server 2016
Comprendre les techniques de modélisation de données
Comprendre l’incidence de la conception de la base de données sur les performances
Connaitre les types de relations et ses effets dans la conception de base de données
Découvrir les objets de base de données couramment utilisés

Pré requis

Toute personne amenée à travailler sur les bases de données SQL Server

Modalités et délais d’accès

Bulletin d'inscription à retourner complété

Certification

Certifiante

Pré-inscription

Programmes de Introduction aux bases de données SQL Server 2016/2017

Introduction aux bases de données

Introduction aux bases de données relationnelles
Autres types de base de données
Analyse des données
Langage d’interrogation

Modélisation des données

Modélisation de données
Modèle de base de données ANSI/SPARC
Modèle Entité-Relation

Normalisation

Introduction
Forme normale
Niveaux de normalisation
Dénormalisation

Relations

Mappage de schéma
Intégrité référentielle

Performance

Indexation
Performances des requêtes
Accès concurrents

Objets des bases de données

Tables
Vues
Procédures stockées
Procédures stockées, déclencheurs et fonctions

Cookie	Durée	Description
hubspotutk	1 year 24 days	This cookie is used by HubSpot to keep track of the visitors to the website. This cookie is passed to Hubspot on form submission and used when deduplicating contacts.
_ga	2 years	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assign a randomly generated number to identify unique visitors.
_gat_UA-38783612-2	1 minute	This is a pattern type cookie set by Google Analytics, where the pattern element on the name contains the unique identity number of the account or website it relates to. It appears to be a variation of the _gat cookie which is used to limit the amount of data recorded by Google on high traffic volume websites.
_gcl_au	3 months	This cookie is used by Google Analytics to understand user interaction with the website.
_gid	1 day	This cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visted in an anonymous form.
_hjAbsoluteSessionInProgress	30 minutes	No description available.
_hjFirstSeen	30 minutes	This is set by Hotjar to identify a new user’s first session. It stores a true/false value, indicating whether this was the first time Hotjar saw this user. It is used by Recording filters to identify new user sessions.
_hjid	1 year	This cookie is set by Hotjar. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInPageviewSample	2 minutes	No description available.
_hjTLDTest	session	No description available.
__hstc	1 year 24 days	This cookie is set by Hubspot and is used for tracking visitors. It contains the domain, utk, initial timestamp (first visit), last timestamp (last visit), current timestamp (this visit), and session number (increments for each subsequent session).

Cookie	Durée	Description
cookielawinfo-checkbox-functional	1 year	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
S	1 hour	No description available.