Upcoming Dates
Train your team with Quanta. Private course delivery available. Contact us to discuss your options.
Essentially, it's about SQL Server
Descriptions
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 diagramsWrite basic Transact SQL queries
Create databases and tables
Understand the role of transaction logs
Use primary and foreign keys
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.
Prerequisites
Delegates should have a working knowledge of Windows. No previous experience of SQL Server or relational databases is required.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
Book Your Course
Start Date
Venue
Availability
Cost
Course confirmed - Guaranteed to run
Course Full/Limited availability
Price shown excluding VAT.
Get Started
Forget trawling through endless course catalogues – Find the training that’s right for you
Learn MoreLatest News from Quanta
Service Management State of Play: All talks available to watch now.
Following the recent Service Management State of Play event in collaboration with PeopleCert, we are pleased to share the presentations…
Read More
Quanta Achieves FTG Gold Partner Status
We’re thrilled to share that Quanta Training has been awarded FTG Gold Partner status at this year’s FTG (Forces Transition…
Read More
ITIL Version 5: Bringing Clarity, Confidence & Connection to the Digital Age
With the launch of ITIL Version 5, Quanta’s head of portfolio for IT Service Management and ITIL Master, Adam White-Bower…
Read More