The NetForum Enterprise Data Model class will cover database basics, NetForum database principles, and exercises using SQL (Structured Query Language) which is used to communicate with the database. This one-day class is designed to help you find and extract the data you need from NetForum Enterprise.

The morning of the class will be spent on an overview of general netFORUM database principles, mixed in with beginner SQL principles. The afternoon will have a greater focus on the netFORUM database, taking a closer look at the specific tables. Learn Transact SQL basics, gain a thorough understanding on the netFORUM database architecture, and take a close look at netFORUM’s core modules, table by table. Students will write a series of SQL queries to learn more about netFORUM’s database tables to help you find and extract the data you need.

Class Prerequisites: Understanding of relational database management systems and Transact SQL language is required. If you are not familiar with relational databases and if you do not have a working knowledge of Transact SQL, then you will not get the full benefits from this course.

If you are not familiar with SQL, then we encourage you to take an SQL course first.

If you are not handy with Transact SQL, but you understand relational databases in general, you can still take the course and it will greatly improve your overall knowledge of how netFORUM is put together. You can skip the hands-on exercises and just listen and learn.

If you want to get an idea of the kind of SQL skills this course assumes you have, see this course at SQL Programming Language: A Comprehensive Hands-On Introduction at https://www.learningtree.com/. If you can do what's described in this course, then you will have the background to get the most out of Data Model Training.

Note: We do not do database design in this course; we only query the database, but it helps to know how a database is put together.

Class is held from 9:00 am - 5:00 pm.

This two-day course teaches the student the basics of the NetForum's Developer Toolkit. Working your way through a series of hands-on exercises, you will build NetForum Objects, Forms, and eWeb pages. You will create new database tables and extender columns.

Students will both build new functionality and learn best practices on how to modify and extend baseline functionality. The instructor will explain and perform each step, and you will follow along and do the work yourself, on your own set of tables.

Please Note: this class does NOT cover new 2017 MVC features.

Prerequisites: Data Model Training is co-requisite for this course. If you take Toolkit Training, then you should take Data Model Training as well. It does not matter which order you take the courses in.

Understanding of relational databases is needed.

Understanding of Transact SQL is helpful but not absolutely essential.

You will write some basic T-SQL Select statements in this training. The more you know about NetForum from the user perspective, the better, but even a NetForum beginner can still take this course. HTML knowledge is helpful but not essential.

Class is held from 9:00 am - 5:00 pm.

This one day course is intended for students that have previously taken NetForum Toolkit training and will introduce the basics of the new NetForum UI designer. It coves basic foundational concepts and students will perform hands-on exercises to build a new profile form, add different types of widgets to the profile form, interacting with classic pop-up forms, and switching between classic and new UI.

Course Level: Advanced
Instructional Method: Group Live
Duration: One-Day Class

Prerequisites:

• NFE101 - NetForum Enterprise Data Model and NFE102 - NetForum Enterprise Developer Toolkit are prerequisites for this course.
• Understanding of relational databases is needed.
• Understanding of toolkit (façade object, classic form designer, child forms, profile forms, etc.) is essential.

• Understanding of Transact SQL is helpful but not absolutely essential.
• C# programming is not required, but helpful.

Class is held from 9:00 am - 5:00 pm.

In this one-day course you will learn the introductory concepts of report design and using stored procedures that extract NetForum data.

This course covers basic formatting, grouping, expression-building, and various aspects of Microsoft SQL Reporting Services that are pertinent to operation of the formats from NetForum. Students will also learn how to set up reports in NetForum, including instruction on dropdown lists for prompted parameters.

Prerequisites:
In order to benefit from this course, the student should have previously taken NetForum Data Model Training and also have a working knowledge of Transact SQL.

Class is held from 9:00 am - 5:00 pm.