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.
4 classes have spots left
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...
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...
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...
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 private group events and team building activities ranging from cooking to art, escape rooms, trivia, and more
Explore Coding Private Group EventsONLC 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...
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...
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...
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.
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...
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...
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...
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...
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...
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:...
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...
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...
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:...
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...
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...
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...
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...
Try removing some filters.
Database Training in Chicago are rated 4.3 stars based on 2,663 verified reviews from actual CourseHorse.com purchasers.
More in Coding
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.