Developing SQL Databases
Design and build SQL Server 2025 database objects, including tables, constraints, indexes, views, stored procedures, functions and triggers.
$1,995.00
Design and build SQL Server 2025 database objects, including tables, constraints, indexes, views, stored procedures, functions and triggers.
$1,995.00
Design and build SQL Server 2025 database objects, including tables, constraints, indexes, views, stored procedures, functions and triggers.
This course teaches you to build the objects that make a database work, rather than only query it. The course name comes from a retired Microsoft course built on SQL Server 2016, so you learn and practice on the current version, SQL Server 2025. You design tables and constraints, plan indexes, write views, stored procedures, functions and triggers, and finish by building a small database that passes a provided test script.
This course is for application developers, report developers and analysts who need to create and maintain database objects. It also suits technical staff moving from writing queries to building the databases behind them.
Comfort writing SELECT, INSERT, UPDATE and DELETE statements and basic joins
Completion of a SQL querying course or equivalent experience
Requires a Windows PC
SQL Server 2025 Developer edition, which Microsoft provides free for development and training
SQL Server Management Studio 21 or later
Schemas, Choosing data types, Primary and foreign keys, The native JSON type, Altering tables safely.
Primary key constraints, Foreign key constraints, Unique constraints, Check and default constraints.
Heaps and clustered indexes, Nonclustered indexes, Covering and filtered indexes, Reading an execution plan, Columnstore overview.
Creating views, Securing data with views, Maintaining views.
Parameterized stored procedures, Error handling with TRY and CATCH, Scalar functions, Table-valued functions.
AFTER triggers, INSTEAD OF triggers, Explicit transactions, Isolation levels and blocking.
Schema build script, Constraints, indexes and views together, Procedures and triggers together, Running a test script.
One-on-one or small-group coaching, scheduled with your coach.
On-demand asynchronous training with online support, plus 2 hours of coaching.
Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.
Developing SQL Databases
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.
TechCred's maximum is $1,000 per person, per credential, toward this price.
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.
