Dec 07, 2022  
Ledet Training 2019 Course Catalog 
  
Ledet Training 2019 Course Catalog
Add to Wishlist (opens a new window)

SQL Server 101 - Introduction to SQL Databases

Class Description
In our 3-day Introduction to SQL Databases class, Participants will learn fundamental database concepts including database types, database languages, and database designs. This course will empower Participants with the skills necessary to move into a database role. The course is also helpful if Participants job role is expanding to encompass database elements. Our instructors are industry professionals and will not only teach Participants SQL Database fundamentals but will also show Participants pitfalls, best practices, and shortcuts.  They are well versed in database administration and SQL and will teach Participants how to increase Participants expertise Participants need to take Participants skills to the next level!

Schedule and Pricing
Schedule of upcoming SQL training classes.

Course Benefits

  • Understand key database concepts in the context of SQL Server
  • Master languages used in SQL Server
  • Describe data modelling techniques
  • Develop normalization and denormalization techniques
  • Explain relationship types and effects in database design
  • Determine the effects of database design on performance
  • Define commonly used database objects

Suggested Prerequisites
Basic computer skills.

Related Classes

We suggest having a look at the following related classes:

 


How to Enroll

Please see our Enrollment Page (http://www.ledet.com/enroll) for our enrollment form.

  
Course Outline
  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization
  • Schema mapping
  • Referential integrity
  • Indexing
  • Query performance
  • Concurrency
  • Tables
  • Views
  • Stored procedures
  • Other database objects

Our goal is to make sure your class meets your objectives, not ours. Therefore, all of our outlines are treated as guides to help steer the workshop. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.

 

Available Delivery Methods
ILT
Locations

We have training centers in Atlanta, Houston, Chicago, Denver, San Diego and Washington DC. We also have the option of live instructor lead online offerings for our courses. Our network of rental facilities is also an option for most of our high demand classes. If coming to a rental facility, please double-check the location of your class with our office to make sure you get to the right location.

As an option for customers needing completely customizable training we offer private onsite training and Individual instructor consulting sessions. To inquire about custom training please fill out our private training request form.

  



Add to Wishlist (opens a new window)