Thankfully we have 2 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
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. Audience Profile This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes...
Apr 25th
9am–3:45pm CDT
Meets 2 Times
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Unlock the power of SQL to access and analyze data in large databases with this course from ONLC Training Centers. Learn how to execute queries, perform searches, use functions, organize data, and retrieve information from multiple tables. Perfect for individuals with basic computer skills and a desire to enhance their data analysis abilities.
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.
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 fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines. This course covers MySQL 8.0.
Audience Profile
Application and web developers.
Prerequisites
Course Outline
An introduction to relational databases and SQL
How to use MySQL Workbench and other development tools
How to retrieve data from a single table
How to retrieve data from two or more tables
How to insert, update, and delete data
How to code summary queries
How to code subqueries
How to work with data types
How to use functions
How to create databases, tables, and indexes
How to create views
Language skills for writing stored programs
How to use transactions and locking
How to create stored procedures and functions
How to code stored procedures
Cancellation / Reschedule by Student
Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.
Please note the following policies:
Substitutions
Make-up Policy
Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.
Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.
In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.
People who viewed this class also viewed the following classes
ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.
Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...
Read more about ONLC Training Centers
This school has been carefully vetted by CourseHorse and is a verified Chicago educator.
ONLC Training Centers
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173 Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
Booking this class for a group? Find great private group events
Or see all Professional Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Microsoft Servers
Made in NYC
© CourseHorse, Inc. 2024
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.
CourseHorse Gift Card
