SQL Server Essentials
The course is designed as an introduction to the important features of relational databases and specifically Microsoft SQL Server. This course uses SQL Server 2017 but is equally suitable for SQL Server 2016 and other previous versions. This course will help delegates prepare for the Microsoft Technology Associate: SQL Server Database Fundamentals certification (Exam 98-364).
Book your team training at your premises
- More info
- Date and time to suit you
- VenueWe will train your team
at your offices
- CostContact us for price
- Fill in the form and we'll be in touch
within 15 minutes (Mon-Fri 9-5)
Book your place
- 07 Jan 2019
- Book Now
- 09 May 2019
- Book Now
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.
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.
- Understand entity relationship diagrams
- Write basic Transact SQL queries
- Create databases and tables
- Understand the role of transaction logs
- Use primary and foreign keys
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.
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.
What is a Database?
Logical and Physical Design
The Relational Database
Primary Keys & Foreign Keys
Entity Relationship Diagrams
Structured Query Language - SQL
Transactions and Log Files
Client-Server and Middleware Architectures
Overview of SQL Server
Users and Security
SQL Management Studio
SQL Server Configuration Tool
SQL Server Documentation
SQL Server Profiler
Database Engine Tuning Advisor
Accessing Data within Database Tables
The SELECT Statement
Querying Multiple Tables Using Joins
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
Creating Database Diagrams
Modifying Data in Tables
The DELETE Statement
The UPDATE Statement
Types of Data Integrity
Ensuring Integrity with Triggers
Speeding up Data Access with Indexes
Application Development Environment
Delegates should have a working knowledge of Windows. No previous experience of SQL Server or relational databases is required.