SQL Training for Employees and Individuals in the Henderson area

Data Creative provides live, instructor-led SQL classes to help you learn SQL. Learning SQL can be beneficial for individuals who consistently work with data, such as data analysts, business intelligence professionals, database administrators, and software developers. SQL enables users to efficiently retrieve and organize large amounts of data, perform complex data analysis, and create custom reports. Our top-rated, expert instructors train thousands of employees each year to produce higher quality work in a shorter timeframe. Every class is live using hands-on exercises.

SQL Training for Private Groups in the Henderson area

Data Creative can deliver live, in-person SQL classes to your group at your location in the Henderson, Nevada area. Our instructors will go onsite to deliver standard or customized classes to meet your needs, schedule and budget. Contact Data Creative today to learn more about our private group training capabilities.

Request a private group training event here for your group in Henderson, Nevada or call 916-601-0992 for more information.

Henderson SQL Training Classes

SQL Querying Fundamentals Oct 17, 2024 – Oct 18, 2024 9:00 AM – 4:00 PM Pacific (Live, Instructor-led Online) $750.00
Register
SQL Querying Fundamentals Nov 18, 2024 – Nov 19, 2024 9:00 AM – 4:00 PM Pacific (Live, Instructor-led Online) $750.00
Register
SQL Querying Fundamentals Dec 16, 2024 – Dec 17, 2024 9:00 AM – 4:00 PM Pacific (Live, Instructor-led Online) $750.00
Register
New Class Schedule will Announce Soon.
Querying Data with Transact-SQL Dec 9, 2024 – Dec 13, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,995.00
Register
New Class Schedule will Announce Soon.
Introduction to SQL Databases Nov 13, 2024 – Nov 15, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,895.00
Register
Introduction to SQL Databases Dec 16, 2024 – Dec 18, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,895.00
Register
New Class Schedule will Announce Soon.
Writing Reports with Report Builder and SSRS Level 1 Oct 21, 2024 – Oct 22, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
Writing Reports with Report Builder and SSRS Level 1 Dec 12, 2024 – Dec 13, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
New Class Schedule will Announce Soon.
Writing Reports with Report Builder and SSRS Level 2 Oct 31, 2024 – Nov 1, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
Writing Reports with Report Builder and SSRS Level 2 Dec 19, 2024 – Dec 20, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
New Class Schedule will Announce Soon.
Administering Microsoft Azure SQL Solutions Oct 7, 2024 – Oct 10, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,495.00
Register
Administering Microsoft Azure SQL Solutions Dec 2, 2024 – Dec 5, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,495.00
Register
New Class Schedule will Announce Soon.
SQL Server Integration Services Dec 2, 2024 – Dec 6, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,995.00
Register
New Class Schedule will Announce Soon.
Administering a SQL Database Infrastructure Oct 14, 2024 – Oct 18, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,975.00
Register
Administering a SQL Database Infrastructure Dec 9, 2024 – Dec 13, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,975.00
Register
New Class Schedule will Announce Soon.

SQL Querying Fundamentals

Query Database Tables and Manipulate Results from a Variety of Databases — 2 Days

SQL Scripting is a two-day, instructor-led SQL class in Henderson that will give you the skills to write simple and complex queries using Structured Query Language (SQL) statements to retrieve results from a database. In the class you will learn how to query database tables and manipulate the results from a variety of databases like Microsoft Access, Oracle, SQL Server and MySQL.

  • What is SQL?
  • Selecting Data
  • Retrieving Data from Multiple Tables
  • Using Criteria in SQL Statements
  • Generating Totals Using SQL
  • Generating Calculated Fields Using SQL
  • Unions, Subqueries, and More Joins
  • Action Queries
  • Advanced SQL Functions
  • Conditional Queries
See Full Course Outline

Class Schedule

SQL Querying Fundamentals Oct 17, 2024 – Oct 18, 2024 9:00 AM – 4:00 PM Pacific (Live, Instructor-led Online) $750.00
Register
SQL Querying Fundamentals Nov 18, 2024 – Nov 19, 2024 9:00 AM – 4:00 PM Pacific (Live, Instructor-led Online) $750.00
Register
SQL Querying Fundamentals Dec 16, 2024 – Dec 17, 2024 9:00 AM – 4:00 PM Pacific (Live, Instructor-led Online) $750.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

Querying Data with Microsoft Transact-SQL (DP-080)

Querying and Modifying Data in Relational Databases — 2 Days

This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

  • 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
See Full Course Outline

Class Schedule

Querying Data with Microsoft Transact-SQL (DP-080) Nov 25, 2024 – Nov 26, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

Introduction to SQL Databases (55315)

Fundamental SQL Database Concepts and Techniques — 3 Days

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.

  • Database concepts in the context of SQL Server
  • Database languages used in SQL Server
  • Data modeling techniques
  • Normalization and denormalization techniques
  • Relationship types and effects in database design
  • Effects of database design on performance
  • Commonly used database objects
See Full Course Outline

Class Schedule

Introduction to SQL Databases Nov 13, 2024 – Nov 15, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,895.00
Register
Introduction to SQL Databases Dec 16, 2024 – Dec 18, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,895.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

Writing Reports with Report Builder and SSRS Level 1 (55123)

Report Writing with Microsoft SQL Server Report Builder and SSRS — 2 Days

The primary audience for this two-day course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.

  • Create table reports
  • Format reports
  • Create basic and complex expressions
  • Group report data
  • Create matrix reports
  • Sort and filter data
  • Summarize data with charts
  • Print and export reports
See Full Course Outline

Class Schedule

Writing Reports with Report Builder and SSRS Level 1 Oct 21, 2024 – Oct 22, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
Writing Reports with Report Builder and SSRS Level 1 Dec 12, 2024 – Dec 13, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

Writing Reports with Report Builder and SSRS Level 2 (55128)

Creating Reports by Connecting to a Database and Manipulating the Data — 2 Days

After completing this two-day course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators.

  • Parameter reports
  • List data regions
  • Enhancing reports with complex expressions
  • Enhance reports with image and subreports
  • Drilldown and drillthrough reports
  • Sparklines, data bars, and indicators
See Full Course Outline

Class Schedule

Writing Reports with Report Builder and SSRS Level 2 Oct 31, 2024 – Nov 1, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
Writing Reports with Report Builder and SSRS Level 2 Dec 19, 2024 – Dec 20, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $1,295.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

Administering Microsoft Azure SQL Solutions (DP-300)

Plan, Deploy and Configure Azure SQL offerings — 4 Days

This four-day course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

  • Introduction to Azure database Administration
  • Plan and Implement Data Platform Resources
  • Implement a Secure Environment for a Database Service
  • Monitor and Optimize Operational Resources
  • Optimize Query Performance
  • Automate database tasks
  • Plan and Implement a High Availability and Disaster Recovery Solution
See Full Course Outline

Class Schedule

Administering Microsoft Azure SQL Solutions (DP-300) Oct 7, 2024 – Oct 10, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,495.00
Register
Administering Microsoft Azure SQL Solutions (DP-300) Dec 2, 2024 – Dec 5, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,495.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

SQL Server Integration Services (55321)

Build, Deploy, Maintain, and Secure Integration Services Projects using SSIS — 5 Days

This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

  • Create sophisticated SSIS packages for extracting, transforming, and loading data
  • Use containers to efficiently control repetitive tasks and transactions
  • Configure packages to dynamically adapt to environment changes
  • Use Data Quality Services to cleanse data
  • Successfully troubleshoot packages
  • Create and Manage the SSIS Catalog
  • Deploy, configure, and schedule packages
  • Secure the SSIS Catalog
See Full Course Outline

Class Schedule

SQL Server Integration Services Dec 2, 2024 – Dec 6, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,995.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

Administering a SQL Database Infrastructure (55353)

SQL Server Database Administration and Maintenance — 5 Days

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
See Full Course Outline

Class Schedule

Administering a SQL Database Infrastructure Oct 14, 2024 – Oct 18, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,975.00
Register
Administering a SQL Database Infrastructure Dec 9, 2024 – Dec 13, 2024 6:00 AM – 2:00 PM Pacific (Live, Instructor-led Online) $2,975.00
Register
New Class Schedule will Announce Soon.
Scroll to see more Dates »

What People Are Saying About Us

Vanessa Boston

Really good progression on Excel Levels 1-3. Was able to take a decent survey of the capability of Excel and work on target areas like V-LookUp which were of special importance to me. You can save the Manuals Work Books for reviewing and recreating lessons as practice

Ashley Lackey

Carolyn did a great job at teaching the class and making all of the information feel manageable and easy to understand. Although the class was small and quiet she stayed engaging and thorough the entire time. I would definitely recommend this class to others!

Marissa Hogan

Carolyn was a phenomenal teacher! I learned many new things from the Excel 3 course that I took; I can’t wait to take other courses that Data Creative offers.

Mariya Petrovska

I absolutely loved the trainings I have taken with Data Creative. The instructors are very professional, easy to follow, knowledgeable and friendly. The groups are relatively small, so you get personal attention. I highly recommend them for everyone that wants to learn new skills or improve their performance.

Tony Wilson

Awesome training at a very good pace. Trainers were very open to example scenarios and unique questions. Highly recommend!

John Andrew Kenyon

Today I was took the excel level 2 class with Data Creative. The instructor was very professional and knowledgeable. He presented everything available to the lesson and more. I will definitely be taking the 3rd lesson through Data Creative.

Alejandra Cabrera

I completed the level 1 and level 2 PowerPoint training with Damian and I learned so much! I’ve been using PowerPoint for a while and had no idea that there was so much you could do with it. Damian was very easy to follow, friendly, and willing to answer any and all questions. I would definitely recommend this course for anyone looking to fine tune their skills in PowerPoint.

Antoinette Medina

Excellent communication and class setup. Classes are well structured, not too fast-paced. Nice materials, easy to review and follow even if you do not have two screens!

Robert Chalmers

Trish was an excellent facilitator and very personable. The class, Excel Level 4, was easy to follow and she encourage us all day to ask questions! She supplied us with a lot of useful information and “extras”. I learned what I was hoping to learn and had fun doing it.

Jody Old

I took the Excel Level 1, 2, 3, and the Power Point class. I have worked with Excel for over 20 years and I am blown away on how much I thought I knew, but really didn’t know. I would recommend Data Creative to anyone who would want to learn more about what different programs can do. I will be looking forward to any other class my place of employment will want me to take through this company