Click a SQL course title below to view class details and dates:
- SQL Querying Fundamentals
- Querying Data with Microsoft Transact-SQL
- Introduction to SQL Databases
- Writing Reports with Report Builder and SSRS Level 1
- Writing Reports with Report Builder and SSRS Level 2
- Administering Microsoft Azure SQL Solutions
- SQL Server Integration Services
- Administering a SQL Database Infrastructure
SQL Training for Employees and Individuals Online
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 Online
Data Creative can deliver live, in-person SQL classes to your group. 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 online or call 916-601-0992 for more information.
Online SQL Classes
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 Sacramento 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
Class Schedule
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
Class Schedule
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
Class Schedule
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
Class Schedule
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
Class Schedule
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
Class Schedule
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
Class Schedule
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