This module introduces databases and tables, methods of using them to track relevant data, and common issues you might experience when working with them. You’ll explore the inner workings of relational databases, including how to use primary and foreign keys and write basic yet effective queries for a SQL Server database using SQL.

Lessons

  • Introduction to relational databases
  • Retrieve data from a relational database by using SQL

Lab 1: Use the SELECT statement to retrieve data from a database

  • Use the SELECT statement to retrieve data from a database
After completing this module, students will be able to:
  • Develop tables with primary and foreign keys
  • Interact with a relational database
  • Compare and contrast types of SQL commands
  • Retrieve data with the SELECT statement
  • Select individual columns in queries
  • Refine a SQL SELECT statement with the WHERE clause

To create databases that are effective, usable, and more secure, it’s necessary for you to choose the types of data, properties, and constraints you implement in your database tables. This module covers why it’s essential to use schemas and views to improve organization and security as you grow your database.

Lessons

  • Identify and use Microsoft SQL Server data types
  • Create tables with SQL
  • Altering and dropping a table
  • Collect information from multiple tables by using joins and views

Lab 1: Create and alter a table in Microsoft SQL Server

  • Create and alter a table in Microsoft SQL Server
  • Create and retrieve a view that uses the JOIN statement in Microsoft SQL Server

Lab 2: Create and alter a table in Microsoft SQL Server

  • Create and alter a table in Microsoft SQL Server

Lab 3: Create and retrieve a view that uses the JOIN statement in Microsoft SQL Server

  • Create and retrieve a view that uses the JOIN statement in Microsoft SQL Server
After completing this module, students will be able to:
  • Data types in Microsoft SQL Server
  • Choose the correct data type
  • NULL values
  • Create a table with SQL
  • Control values allowed in columns using constraints
  • Create a surrogate primary key by using the IDENTITY property
  • Group tables by using a schema
  • Add a column to a table using the ALTER TABLE statement
  • Change a column using the ALTER TABLE statement
  • Drop a column using the ALTER TABLE statement
  • Remove a table using the DROP TABLE statement
  • Describe the key features, editions, and hardware requirements of Windows 7.
  • Use JOIN to obtain data from multiple tables
  • JOIN statement types
  • Create views

This module covers using statements to add, alter, and remove rows in a table. It also covers creating stored procedures and using input parameters in stored procedures.

Lessons

  • Insert, update, and delete information

Lab 1: Add and change data in SQL Server

  • Add and change data in SQL Server

Lab 2: Create and use stored procedures in Microsoft SQL Server

  • Create and use stored procedures in Microsoft SQL Server
After completing this module, students will be able to:
  • Add information to a table using the INSERT keyword
  • Add multiple rows to a table at once
  • Update values in a table
  • Use DELETE to delete rows in a table
  • Define a stored procedure
  • Use multiple statements in a stored procedure
  • Use input parameters in a stored procedure
  • Describe the uses of stored procedures

This module covers entities and the relationships between them. It also discusses using the various types of referential integrity.

Lessons

  • Model entity relationships
  • Design for referential integrity What is referential integrity?

Lab 1: Create an entity relationship diagram in Microsoft SQL Server Management Studio

  • Create an entity relationship diagram in Microsoft SQL Server Management Studio
After completing this module, students will be able to:
  • What is an entity?
  • Entity keys
  • Candidate keys
  • Entity relationships and cardinality
  • Join tables
  • Compare optional and mandatory relationships
  • Entity relationship modeling
  • Ensure declarative referential integrity by using key constraints
  • Ensure procedural referential integrity by using triggers
  • Cascading referential integrity

This module covers normalization and denormalization in a database, their benefits, and when each should be used.

Lessons

  • Normalization
  • Denormalization

Lab 1: Denormalize a table by adding a redundant column of computed data

  • Denormalize a table by adding a redundant column of computed data
After completing this module, students will be able to:
  • What is normalization?
  • First normal form
  • Second normal form
  • Third normal form
  • Defining denormalization
  • Adding redundant columns
  • Saving computed data
  • Potential issues

This module covers writing effective and performant queries and using clustered and non-clustered indexes. It also discusses concurrency issues and the transactions and isolation levels you can use to address them.

Lessons

  • Indexes
  • Write performant SQL code
  • Concurrency

Lab 1: Create indexes and consult execution plans in Microsoft SQL Server Management Studio

  • Create indexes and consult execution plans in Microsoft SQL Server Management Studio
After completing this module, students will be able to:
  • Clustered indexes
  • Nonclustered indexes
  • Indexes and performance
  • Limit data referenced and returned
  • Use indexes
  • Use SARGable queries
  • What is concurrency?
  • Problems caused by concurrency
  • Isolating transactions
  • Limiting concurrency

O tym kursie

This course examines the services and features of Microsoft SQL from 2012 to 2022, including lessons and lab exercises on key attributes you’ll need on the job. It’s designed for novices and professionals who are interested in interacting with databases using Structured Query Language (SQL) and seek foundational knowledge and skills. This audience typically includes people who are moving into a database role or expect their role to require interacting with a database server that uses SQL.

Profil odbiorcy

This course is intended for people with varied computer knowledge. As an introductory course, it does not require any previous knowledge of SQL, databases, or information technologies. As an introductory path, this course is ideal for those who haven’t previously interacted with databases or those who have previous experience with databases and languages distinct from SQL.

Czego się nauczysz?

  • Conceptualize data organization in a database.
  • Identify various types of databases.
  • Retrieve information from a database using SQL, Transact-SQL (T-SQL), and other languages.
  • Normalize and denormalize data stored in a database.
  • Certyfikat Microsoft
  • Autoryzowane materiały szkoleniowe w formie elektronicznej (Skillpipe)
  • Gwarancja jakości szkolenia
  • Notatnik, długopis (w przypadku szkoleń stacjonarnych)
  • Kontakt z trenerem po szkoleniu
  • Kawa, herbata, słodki poczęstunek (w przypadku szkoleń stacjonarnych)
  • Obiad (w przypadku szkoleń stacjonarnych)

Firma jest Autoryzowanym Ośrodkiem Szkoleniowym MICROSOFT Silver Learning
Możesz u nas podejść do egzaminu
Pearson VUE

Spółka posiada wpis do ewidencji placówek niepublicznych   Nr ew. ES.VIII.4320-6/p.n./2003 wydany z upoważnienia Prezydenta Miasta Łodzi

 

 

 

Zachęcamy firmy do uzyskania możliwości dofinansowania na szkolenia oferowane przez naszą firmę. W obecnej chwili istnieją dwa sposoby dzięki którym możesz uzyskać dofinansowanie.

  • Szkolenia dofinansowane do 80% z funduszy europejskich  - Baza Usług Rozwojowych (BUR). Dofinansowanie dostępne jest dla wszystkich firm zatrudniających średniorocznie do 250 pracowników (maksymalnie średnie przedsiębiorstwo)
  • Szkolenia dofinansowane z Krajowego Funduszu Szkoleniowego  - dofinansowanie do 100%. Niezależnie od wielkości przedsiębiorstwa oraz kapitału.

Nasi pracownicy pomogą uzyskać dla Twojej firmy dofinansowanie. To naprawdę nie jest trudne. Jeżeli masz pytania  napisz lub zadzwoń do nas.

Zapraszamy!

 

Opinie
  • Brak dodanych opinii
Dodaj opinie
Cena netto
2300.00 zł
Czas trwania (dni / godziny dydaktyczne): 2 d,16 h
Poziom trudności
Język Polski,
Język materiałów Angielski,
Prowadzący Autoryzowany Trener Microsoft,
Możliwe opcje szkolenia