55315 Introduction to SQL Databases
Expert Training
- Mission ready skills
- Real world application
- Online at your ocation
- Group rates available
Training for Individuals
$1695
- Live, Instructor-led training
- Expert instructors
- Hands-on instruction
- Remote Training - Local Support
Course Overview
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title.
Course Length: 3 Days
Audience: The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.
Prerequisites: This is a foundation level course and therefore only requires general computer literacy.
What You're Going To Learn
- Describe key database concepts in the context of SQL Server
- Describe database languages used in SQL Server
- Describe data modeling techniques
- Describe normalization and denormalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
Course Outline
1 – Introduction to databases
- Introduction to Relational Databases
- Other Databases and Storage
- Data Analysis
- SQL Server Database Languages
2 – Data Modeling
- Data Modelling
- Designing a Database
- Relationship Modeling
3 – Normalization
- Fundamentals of Normalization
- Normal Form
- Denormalization
4 – Relationships
- Introduction to Relationships
- Planning Referential Integrity
5 – Performance
- Indexing
- Query Performance
- Concurrency
6 – Database Objects
- Tables
- Views
- Stored Procedures, Triggers and Functions
What to Expect at LeapFox
Knowledgeable Instructors
Our instructors are certified professionals. They are trained on the latest features and how to get the most out of software programs.
Hands-on Labs
No boring lectures! Our courses are designed to give students lots of time to practice what they are learning with hands-on exercises and projects.
Certificate of Completion
Receive a certificate of completion at the end of every course.
Up-to-date Curriculum
Each course comes with a helpful and up-to-date ebook which will contain instruction and practice exercises.
Time Saving Tips N Tricks
In each course, your instructor will show you tips and tricks that will save you time and make you more efficient.
Friendly and Helpful Staff
Our staff is dedicated to your success. Each team member is trained to provide the absolute best customer service possible.
Satisfaction Guarantee
If you aren't 100% satisfied with your experience at LeapFox, simply let us know, and we will make it right.
Look who Else is Using LeapFox
