inflearn logo

(2027 Prep) Information Processing Engineer Practical Exam SQL and Coding Problems: If You’re Getting Them Wrong by Guessing—18 Hours of Hands-On Practice with Recent Question Types, Led by a Working DBA Team Lead

We work through SQL, DB, C, Java, and Python problems for the Information Processing Engineer practical exam by hand, then run them and grade them. The course includes 91 lessons (about 18 hours), 1,176 original variations on exam questions, five mock exams, and execution results for every answer.

1 learners are taking this course

Level Basic

Course period Unlimited

Python
Python
Java
Java
C
C
SQL
SQL
MySQL
MySQL
Python
Python
Java
Java
C
C
SQL
SQL
MySQL
MySQL

What you will gain after the course

  • I can predict the number of rows and output values in SQL results using the rules for joins, NULLs, aggregates, and subqueries, and explain why.

  • You can fill in the blanks in DML, DDL, DCL, TCL, view, and trigger exercises and verify your answers by running them.

  • You can apply database theory concepts such as normal forms, relational algebra, keys, and integrity constraints to actual tables and determine their properties.

  • You can use variable tables to trace C code involving pointers, arrays, recursion, and bitwise operations and predict its output.

  • You can solve Java problems involving overriding, constructor call order, static, and reference passing with a call stack table.

  • I can accurately trace output questions involving Python lists, slicing, dictionaries, closures, and generators.

  • The five modified mock exams let you check your time management and catch answer-marking mistakes.

The goal of this course: to be able to give a reasoned answer to, “What will this SQL or code actually output when run?”

We trace SQL, DB, C, Java, and Python questions from the Information Processing Engineer practical exam by hand, then run them and grade them. The course includes 91 lessons totaling about 18 hours, 1,176 original variant questions, five mock exams, and execution results for every answer.

This is not a course that simply walks you through the original past exam questions. It covers all the SQL and coding question types from 22 exam sittings, based on reconstructed materials, as well as the types expected under the exam standards, spread across the lessons. For each type, you’ll get a modified problem with different values and structure. For every problem, you’ll first fill in a trace table by hand, then run it in a practice environment and check your answer. Every result shown on screen is the actual output from running the code. SQL and databases are covered in depth across 42 lessons, and wherever the exam’s standard SQL answer differs from the result in MySQL, we show them separately.

After completing this course, you will be able to

  • Using the rules for joins, NULLs, aggregation, and subqueries, you can predict the number of rows and output values in SQL results and explain why.

  • You can fill in the blanks in DML, DDL, DCL, TCL, view, and trigger problems and verify the results by running them.

  • You can apply DB theory concepts such as normal forms, relational algebra, keys, and integrity constraints to actual tables and determine whether they hold.

  • You can trace C pointer, array, recursion, and bitwise operation code using a variable table to determine the output.

  • You can solve problems involving Java method overriding, constructor call order, static members, and passing references using a call stack table.

  • You can accurately trace output problems involving Python lists, slicing, dictionaries, closures, and generators.

  • You can check your time management and answer-formatting mistakes with five full-length practice exams.

Recommended for these people

  • Test takers preparing for the Information Processing Engineer practical exam who are losing points on SQL and coding questions

  • Retakers, non-majors, and job seekers.

  • Those who want to firmly master the SQL and coding sections through hands-on execution while taking another practical exam course.

Curriculum (8 sections · 91 lessons · approximately 1,085 minutes)

  • Section 1. Getting Started: How to Evaluate by Running Code — Run a problem and evaluate it, map out question types, and set up the practice environment

  • Section 2. SQL ① Writing Queries and Evaluating Results — Writing SELECT·WHERE queries: IN·BETWEEN·LIKE, AND·OR precedence and COUNT, NULL comparisons and the IS NULL·NOT IN pitfalls, row counts with COUNT(*)·COUNT(column)·COUNT(DISTINCT), aggregate functions and NULL: SUM·AVG·MAX·MIN, writing GROUP BY·HAVING·aliases, evaluating ORDER BY·LIKE sorting, inner joins and filling in JOIN ON, CROSS JOIN Cartesian products and self-joins, OUTER JOIN row counts: LEFT·RIGHT·FULL, subqueries: single-row and multiple-row IN·ANY·ALL, correlated subqueries and EXISTS·NOT EXISTS, set operations UNION·UNION ALL·INTERSECT·EXCEPT, single-row functions and CASE, window functions and aggregate functions

  • Section 3. SQL ② DML·DDL·DCL·TCL·Procedural SQL — DML writing: INSERT·UPDATE·DELETE, writing a complete CREATE TABLE statement, ALTER TABLE and DROP·TRUNCATE·DELETE, foreign key and CHECK constraints with ON DELETE CASCADE·SET NULL, CREATE INDEX and index types, writing a VIEW, its pros and cons, and DROP VIEW options, GRANT·REVOKE and privilege propagation, TCL: COMMIT·ROLLBACK·SAVEPOINT, Procedural SQL ①: stored procedures·user-defined functions·error handling, Procedural SQL ②: triggers·events, SQL Injection and bind variables

  • Section 4. Short-Answer and Calculation Questions on Database Theory — Data model and relational model terminology, three-schema architecture and system catalog, database design stages and E-R diagrams, types of keys and integrity constraints, relational algebra ①: symbols, selection, projection, and types of joins, relational algebra ②: union, difference, Cartesian product, and division, and relational calculus, anomalies and functional dependencies, determining normal forms: 1NF–3NF, BCNF, 4NF, and 5NF, and denormalization, transaction ACID properties and states, concurrency control: locking, two-phase locking, and timestamps, recovery techniques: REDO, UNDO, immediate/deferred updates, and checkpoints, physical design: file organization, index access, and partitioning, distributed databases, replication, backup, and RTO/RPO, access control, optimizer, and execution plans, CRUD matrix, data conversion (ETL), and ORM

  • Section 5. Tracing C Code — Drawing C variable tables: increments, integer division, type conversion, ASCII; C loops, accumulation, and modulo-based index cycling; C number algorithms: perfect numbers, primes, prime factors, digits, and number bases; C sorting algorithms: bubble, selection, insertion, and merge sort; C arrays and equivalent array/pointer notation, two-dimensional arrays; C strings, pointers, and string library; C arrays of pointers, double pointers, and function pointers; C structs, struct pointers, and typedef; C linked lists; C stacks and circular queues; C recursion and tree traversal; C pitfalls: switch, static, passing by value and by address, global variables; C bitwise operations, shifts, precedence, and ternary operator; Less common C syntax: union, enum, #define, malloc, sizeof, printf format specifiers; C intensive practice: 14 problems on pointers, structs, and linked lists

  • Section 6. Java Code Tracing — Fill-in-the-blanks on Java arrays, loops, and number-base conversion, Java switch and operator precedence, Java constructor call order and this/super, Java upcasting, overriding, and dynamic binding, Java field static binding and hiding, Java static sharing, hiding, and singleton, Java overload resolution, Java abstract classes, interfaces, access modifiers, and final, Java reference passing, array sharing, == and equals, Java string methods, split, StringBuilder, and collections, Java exception flow: try, catch, finally, and throw, Java recursion and algorithm tracing, Java generics, lambdas, and functional interfaces, Java enums, threads, and inner classes, Java focused problems: 14 problems on constructors, overriding, and binding

  • Section 7. Python Code Tracing — Python Operators and Data Types, Python Slicing and Indexing, Python String Methods and Output Formatting, Python Lists: Nested Indexing, Methods, and Shallow Copies, Python Tuples, Dictionaries, and enumerate, Python Set Operations and Comprehensions, Python Functions: Default Arguments, Variable Scope, and Generators, Python lambda, map, filter, reduce, sorted, and zip, Python Classes, Inheritance, Class Methods, and Exceptions, Python Tree and Data Structure Implementation, Python Focus Problems: 12 Questions Based on Recent Exams

  • Section 8. Practice: 5 Modified Mock Exams and Writing Answers — Modified Mock Exam 1: 12 SQL and Coding Practice Questions, Modified Mock Exam 2: 12 SQL and Coding Practice Questions, Modified Mock Exam 3: 12 SQL and Coding Practice Questions, Modified Mock Exam 4: 12 SQL and Coding Practice Questions, Modified Mock Exam 5: 12 SQL and Coding Practice Questions, Wrap-up: Answer-Writing Rules and Time Management

Practice Environment

With just Docker on your laptop, you can launch a MySQL practice database and environments for running C, Java, and Python. There’s no need to install compilers or a database separately. Run SQL files with `./sql.sh` and C, Java, and Python files with `./run.sh`. All data is fictional academic and employee data, and every result shown in the course videos is the verbatim output from actually running these scripts. You’ll receive 843 questions from the videos, 333 workbook questions not covered in the videos, and the execution results, trace tables, and answer sheet templates for all solutions as practice materials in a ZIP file.

Prerequisites

  • You only need to have seen SELECT statements and simple loops at least once.

  • A PC that can run Docker (Mac or Windows; 8 GB or more of memory recommended)

What This Course Does Not Cover

  • Software engineering, networking, security, and operating systems theory (this course covers only SQL, databases, and code)

  • Collection of Original Past Exam Questions and Reconstructed Questions

  • An introductory course on C, Java, and Python syntax from the ground up.

Guide

The lecture narration uses synthesized speech. All data is simulated for educational purposes, and the numbers may vary depending on the execution environment.

Recommended for
these people

Who is this course right for?

  • Test takers preparing for the practical Information Processing Engineer exam who are losing points on SQL and coding questions

  • Those retaking the exam, non-majors, and job seekers.

  • For those taking another hands-on course who want to solidify their SQL and coding skills through practice.

Need to know before starting?

  • It’s enough if you’ve seen a SELECT statement and a simple loop at least once.

  • A computer capable of running Docker (Mac or Windows; 8 GB of memory or more recommended)

Hello
This is dorian05202988

Career Verified

A data craftsman with over 20 years of experience in databases and IT. As a DBA and manager of a DB Platform team, I work with database platforms and specialize in MySQL, PostgreSQL, Oracle, MongoDB, SQL tuning, AWS, Terraform, and Python. Drawing on experience in the gaming, finance, and IT services industries, I explain database and cloud architecture. I have published 『Oracle Practical Tuning: Learning SQL Patterns』 and 『Oracle Pro*C Practical Project Guide』, and have presented on serverless architectures, database selection, and multi-database strategies at AWS Summit 2018 and 2019 and DataYa Nolja 2020. Recently, I have been working on slow-query analysis and tuning recommendations using Bedrock LLM, automated DB specification sizing, and query workflows through a DB metadata MCP server and Slack bot. I explain database automation for developers and AI applications for non-developers through hands-on exercises tailored to the audience and objectives of each course. Rather than applying AI suggestions as-is, I teach a decision-making framework that verifies result equivalence, execution plans, and observability conditions, and defers action when the supporting evidence is insufficient. Company operational data and credentials are not included in the course materials.

More

Curriculum

All

91 lectures ∙ (18hr 5min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

dorian05202988's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal

$41,250.00

25%

$42.90