SQL Server Introduction: Introduction to SQL

Course Code: ITDS | Duration: 1 Day | Level: Introduction

This course gives you an introduction to the SQL language covering how to create tables and create a relational database. We explore the tools and methods available within the SQL DBMS (Database Management System) that will allow you to create powerful and high end database structures.

Course Requirements

No previous experience of Microsoft SQL Server is required however the delegate should have knowledge in basic computer skills.


Course Content

• Overview Of SQL Server (Exploring The Components Of SQL Server)
• Designing Databases (Creating, Managing And Setup Options)
• Creating Tables (Inserting Data / Selecting Data)
• Understanding Data Structure (Using Primary And Foreign Keys)
• Creating Views (Using Primary And Foreign Keys)
• Formatting Objects (Borders / Fill Colour / Shadows / Corner Rounding)
• Database Management Tools (MS Access Project Files)
• Advanced Query Writing (Inner Joins / Outer Joins / Cross Joins)
• Triggers
• Stored Procedures (Parameters / Transact - SQL / Cursors)
• System Security (Connectivity Issues - ODBC Access / Web / Crystal Reports)
• Optimising (Efficient Query Writing / Indexes / Relationships)
• Problem Solving Workshops
• Question and Answers