Fundamentals of SQL Querying
Write SQL queries that filter, calculate, group, join and rank data, then check AI-written SQL and produce a verified report.
$995.00
Write SQL queries that filter, calculate, group, join and rank data, then check AI-written SQL and produce a verified report.
$995.00
Write SQL queries that filter, calculate, group, join and rank data, then check AI-written SQL and produce a verified report.
This course covers querying in SQL from your first SELECT statement to window functions. You connect to a sample database, filter and calculate data, summarize it with aggregates and grouping, combine tables with joins, and break harder questions into subqueries and common table expressions. You then use AI to draft SQL, test every AI-written query against your own results before you trust it, and turn the verified queries into a short report.
This course is for business users, analysts and new technical staff who need to pull and summarize their own data. It also suits report writers who want to read and check the SQL that others or AI tools write.
Basic computer skills and some familiarity with database terms such as table, row and column
No prior SQL experience is needed
Works on Windows or Mac
SQL Server 2025 Developer or Express edition (free); on a Mac you run SQL Server in a Docker container or use a cloud database
SQL Server Management Studio 21 or later on Windows, or Visual Studio Code with the SQL extension on Windows or Mac
Access to a generative AI assistant your employer approves, for the AI-assisted querying module
Connecting to a sample database, SELECT and FROM, Choosing columns, Sorting with ORDER BY and TOP, Saving and rerunning queries.
WHERE with comparison operators, AND, OR and NOT, BETWEEN and IN, LIKE patterns, NULL handling.
Calculated columns, Column aliases, String functions, Date functions, CAST and number and date formatting.
COUNT, SUM, AVG, MIN and MAX, GROUP BY, HAVING, Counting distinct values.
Inner joins, Left and right joins, Full joins, Joining three or more tables, UNION.
Subqueries in WHERE, Subqueries in FROM, EXISTS and NOT EXISTS, Common table expressions, Breaking a question into steps.
OVER and PARTITION BY, ROW_NUMBER, RANK and DENSE_RANK, Running totals, LAG and LEAD, Top N per group.
Describing a question to an AI assistant, Reading AI-written SQL, Testing against known results, Common AI query errors, Exporting results to CSV.
One-on-one or small-group coaching, scheduled with your coach.
On-demand asynchronous training with online support, plus 1 hour of coaching.
Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.
Fundamentals of SQL Querying
Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.
Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.
This price is within TechCred's maximum of $1,000 per person, per credential.
The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.
Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.
For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.
Pricing is the same for all customers, whether or not you use TechCred.
We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.
Choose the number of seats, add the course to your cart and check out.
Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.
We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.
