Originally Aired - Saturday, October 12 • 8:00 AM - 5:00 PM CT
Create or Log in to My Show Planner to see Videos and Resources.
You do not have access to Session Resources.
{{chatBodyContent}}
Be sure to come back after the session starts to have access to session resources.
Location: Marriott Riverwalk - Ballroom Level - Travis
Title: Academy - All UG/Universal: SQL Query Fundamentals I (Day 1) & SQL Writing Queries and Views (Day 2)
Session Description:
*** This course requires a separate registration from the Conference *** This is a two-day Academy course. Registration for individual class days is available. Day 2 can be added to your show planner here. Learning Objectives: 1. Understand what SQL is and how it is used Program Level: Beginner Delivery Method: Group Live CPE Credits: 8 for one day/16 for both days Prerequisites: None Advance Preparation: Laptop Computer: Power Supply, WiFi and Mouse (optional), Software: Microsoft SQL Server Management Studio v19.3+ (WINDOWS) Or Azure Data Studio v1.46.1 (MAC or WINDOWS) Supplies: Pen If you are the person that needs to write reports, extract data or get information from the Dynamics GP system, YOU NEED TO BE HERE! The class is intended to teach you and develop real world SQL queries against the Dynamics GP database. Learning Objectives: 1. Learn where and how to find the Dynamics GP Data quickly and simply Program Level: Intermediate Delivery Method: Group Live CPE Credits: 8 for one day/16 for both days Prerequisites: SQL Writing Queries and Views is designed for the Microsoft SQL user with some experience in writing SQL queries. Having taken the SQL Query Fundamentals class over the last 10 years or have written SQL queries at the office will be all that is require Advance Preparation: Laptop Computer: Power Supply, WiFi and Mouse (optional), Software: Microsoft SQL Server Management Studio v19.3+ (WINDOWS) Or Azure Data Studio v1.46.1 (MAC or WINDOWS) Supplies: Pen DCI is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org. By submitting your registration, you are confirming you have read and agree to Dynamic Communities’ Policy, regarding registration, refunds, and cancellations. For more information regarding refund, complaint, and/or program cancellation policies, please contact us at summitna@dynamiccommunities.com. Registration for this course is closed.
Price: $1000 for single day/$1500 for both days
Day 1
SQL Query Fundamentals I, is an introduction into Microsoft SQL Queries. It is intended to teach the basic concepts of Structured Query Language (SQL), and provide a solid working knowledge through the many examples provided, and by active participation in the classroom lessons and labs. By design, this course has been developed to maximize your abilities to retrieve and display data for your reporting and analytics information needs. Although the SQL Query Fundamentals I was developed for the beginner student with no SQL experience, there are still many things that even an experienced SQL user will discover they may not know, and new tips and tricks will be acquired that will make your SQL life better. By the end of this course, you will be given a solid working knowledge of Microsoft SQL. This knowledge will allow you to become a SQL ROCK STAR for your company. You will be a SQL HERO!
In this very full 1 day course, you will learn how to:
- Understand Relational Database Structures
- Use Microsoft SQL Server Management Studio
- Employ various Best Practices for formatting T-SQL code
- Build a Basic Query
- Develop Conditional Searches
- Work with Aggregate Functions
- Organize Data with Sort, Group, and Filters
- Develop Nested SQL Statements (Sub-Queries)
- Use Data from multiple tables with Joins and Unions
- Create and Use Views
- Understand the CASE and IN Statements
2. Understand how to write basic SQL Queries
3. Learn many of the basic filters, conditions and aggregate functions in SQL
Day 2
These queries and views can then be used as the bases for any reporting you want to develop using other tools like PowerBI, SSRS, Excel Refreshable, Excel Pivot and many more.
By developing these complex queries and views you allow for a common one stop view that can be used by many different reports. You will learn how to find and connect your Dynamics GP data and how 3rd party ISV products can affect this.
If you are not a Dynamics GP person, but are using SWQL, you will still benefit from the deep query building and view building that is taught in this class, only the data names have been changed... to protect the innocent. :-)
2. Develop real world, take home queries and views for many modules
3. Understand how 3rd party products effect the Dynamics GP data
Type: Academy
Ability Level: 101 - New To
Primary Product: All User Groups
Primary Track: Data
Track: Data
Learning Objective 1: -
Learning Objective 2: -
Learning Objective 3: -
Cost: 1000 one day/1500 both days
Session Objective for Attendee: New To,Optimizing
Create or Log in to My Show Planner to add notes.
