IT SQL Server Essentials

Course Code: SQLS2ESS

Book

Duration

2 Day(s)

Course Type

Public or Private

Max Delegates

12

Delivery Style

Classroom

Essentially, it's about SQL Server

This course is designed as an introduction to the important features of relational databases and specifically Microsoft SQL Server, and it is suitable for all versions of SQL Server.

Book Your Course

Start Date

Venue

Availability

Cost

10/10/2024

WR1 - Worcester, WR1 3EE

Available

£590*

Course confirmed - Guaranteed to run
Course Full/Limited availability
Price shown excluding VAT.

Book a Private Event

If you require the content of this event tailored or have around 7 or more people to train it maybe better for you to host a Private Event, please get in touch to discuss this.

Get in touch

Description

Who is this course for

Personnel who need to understand the basic concepts of SQL Server, from an administration, support, querying or development viewpoint. The course is also suitable for application developers (Visual Basic, C#, etc.) who need a solid grounding in SQL Server.

Purpose of the course

The course covers a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including the Management Studio; and database implementation basics, with an introduction to T-SQL and data integrity. Exercises are included to consolidate the skills taught.

You will learn how to

Understand entity relationship diagrams
Write basic Transact SQL queries
Create databases and tables
Understand the role of transaction logs
Use primary and foreign keys

Prerequisites

Delegates should have a working knowledge of Windows. No previous experience of SQL Server or relational databases is required.

Benefits for you as an individual

Many roles now require knowledge of SQL Server. This course will equip you with the essential skills to use SQL Server whatever your role with SQL Server. It will give you the skills needed for further SQL Server training.

Benefits for your organisation

SQL Server has become a popular choice for enterprise wide applications. This course will begin the process of raising the level of knowledge of SQL Server in your organisation. It will help to create a level playing field of SQL Server knowledge in your organisation.

 

Relational Database Concepts

  • What is a Database?
  • Logical and Physical Design
  • The Relational Database
  • Primary Keys & Foreign Keys
  • Entity Relationship Diagrams
  • Design Normalisation

Relational Database Architecture

  • The RDBMS
  • Structured Query Language - SQL
  • Stored Queries
  • Indexes
  • Transactions and Log Files
  • Client-Server and Middleware Architectures

SQL Server and Architecture

  • Overview of SQL Server
  • Server Fundamentals
  • Users and Security
  • Networked Architecture

SQL Server Tools

  • SQL Management Studio
  • SQL Server Configuration Tool
  • SQL Server Documentation
  • SQL Server Profiler
  • Database Engine Tuning Advisor
  • Performance Monitor

Viewing Data

  • Accessing Data within Database Tables
  • The SELECT Statement
  • Manipulating Data
  • Selecting Rows
  • Sorting Data
  • Aggregate Functions
  • Querying Multiple Tables Using Joins

Database and Table Structures

  • Creating Databases using SQL Server and T-SQL
  • Creating Tables in SQL Server
  • Entering and Editing Data
  • Creating Tables and Columns in T-SQL
  • Modifying Tables and Columns
  • Computed Columns
  • Database Diagrams
  • Creating Database Diagrams

Manipulating Data

  • Modifying Data in Tables
  • INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement

Enforcing Data Integrity

  • Types of Data Integrity
  • Constraints
  • Ensuring Integrity with Triggers

Improving Data Access

  • Using Views
  • Speeding up Data Access with Indexes
  • Application Development Environment

Get Started

Forget trawling through endless course catalogues – Find the training that’s right for you

Learn More

Latest from our blog

Kanban and Agile: Bridging the Gap

Kanban and Agile: Bridging the Gap Quanta’s Kanban University Certified Trainer Steve Church explores the way in which Agile and…
Read More

How a Ballerina could move into Cybersecurity

Jason Ford, Quanta Cybersecurity and IT Trainer talks about the limitations in Cybersecurity Training courses. Jason discusses a safe and…
Read More

Boost Team Performance and Productivity: Unlocking the Advantages of Emotionally Intelligent Leadership

Quanta People Development and Leadership Trainer, Giles Collins outlines the key elements of Emotionally Intelligent Leadership and how it impacts…
Read More