Discover Classes. Earn 10% Rewards.
Database Training
Chicago
Learn the ins and outs of SQL and database management in Chicago with classes ranging from beginner-level introductions to advanced techniques for data manipulation and query optimization.
Follow
64 following
4 classes have spots left
MySQL Administration and Development Course
ONLC Training Centers @ 1800 Nations Dr, Chicago, IL
MySQL® is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database...
After Hours: MCSA SQL Certification Program
Overview Prepare for MCSA SQL Server or MCSA Windows Server certification outside of traditional office hours with ONLC's MCSA After Hours Certification Program. Our MCSA After Hours Certification Program is designed to help you attain a MCSA certification every step of the way—from training, to exam prep, to taking your test—we’ve got it covered. The program takes place over a three month period. It gives you time to learn the material so...
SQL Server 2014 Performance Tuning and Optimization
This 3-day course is designed to give the right amount of Internals knowledge and wealth of practical tuning & optimization techniques that they can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create...
Database Classes Gift Card
Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Explore Coding Private Group Events
Explore private group events and team building activities ranging from cooking to art, escape rooms, trivia, and more
Explore Coding Private Group Events
Managing SQL Business Intelligence Operations
ONLC Training Centers @ Two Mid America Plaza, Chicago, IL
This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources. Audience profile The primary audience for this course are business intelligence professionals. The secondary...
Intermediate SQL Bootcamp
General Assembly @ 150 N Wacker, Chicago, IL
This workshop will build upon the skills developed in the SQL Bootcamp. The program uses a combination of lecture and in-class exercises to ensure that students leave with a working grasp of the SQL skills covered in class. Students will immediately be able to apply their skills at work. The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19...
MySQL Querying Fundamentals
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau, or Crystal Reports. Analysts and Data Scientists can use SQL to select the data they need for additional analysis and reporting. This class, MySQL Querying: Fundamentals, provides an overview of the SQL statements that can be...
$695
Querying MySQL
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Explore the fundamentals and features of MySQL, including database management, SQL queries, stored routines, and more in this comprehensive course tailored for application and web developers.
SQL for Beginners
General Assembly @ 150 N Wacker, Chicago, IL
Looking to learn some basic SQL skills to filter, aggregate or produce reports from a database? Exporting data and using Excel instead of taking advantage of functionality your database already gives you? This class will give you the skills required to perform both basic and complex data manipulations with ease. This class will introduce students to SQL queries for data gathering and data analysis. We will cover enough query syntax and examples...
Writing Queries Using Microsoft SQL Server 2008
Learn how to use and execute the Transact-SQL language. Gain the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course that incorporates material from the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. Your course includes a twelve-month subscription to these exclusive benefits*: 12 months of anytime access to your course labs...
DB2 11 for z/OS Application Performance and Tuning
Global Knowledge @ 1500 McConnor Pkwy, Schaumburg, IL
This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content. What You'll Learn Design better indexes Determine...
SQL Server 2017 Reporting Services
Hands On Technology Transfer, Inc.
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing...
Microsoft SQL Server 2016 Administration
Hands On Technology Transfer, Inc.
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure. The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and...
Upgrade SQL Server2000 DBA Skills to MS SQL Server2008
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills. Please note that there is no certification exam related to this course. Audience Profile This course is intended for IT professionals who administer and maintain SQL Server databases. At Course Completion After completing this course, students will be able to:...
Maintaining a Microsoft SQL Server 2008 R2 Database
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database. Audience Profile The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop...
Writing Queries Using MS SQL Server 2008 Transact-SQL
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. Audience This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. At Course Completion After completing this course, students will be able to: • Describe the uses of and ways to execute the Transact-SQL...
Administering a SQL Database Infrastructure
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. Prerequisites: In addition to their professional experience, students who attend this training should already have the following technical knowledge:...
Oracle Database 12c: Administration Workshop
The overall objective of this class is threefold. First, this course instructs one in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the course modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single...
Updating SQL Server Skills to Microsoft SQL Server 2014
This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components. Audience Profile The primary audience for this course is database and business intelligence (BI) professionals who...
Oracle Database 11g: Administration II Course
The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise. Specific subjects to be considered are: • Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory...
Designing Database Solutions with Microsoft SQL Server
The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. Note This course is designed for customers who are interested...
Database Training in Chicago are rated 4.3 stars based on 2,663 verified reviews from actual CourseHorse.com purchasers.
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Coding
Made in NYC
© CourseHorse, Inc. 2024 Loading...
