Java MTA - Introduction to Programming Using Java 98-388

Master if statements and else if logic to control which commands run based on boolean conditions, and explore simple conditional decision flows.

Learn how arrays store a fixed-size collection of elements of the same type, using zero-based indexing and contiguous memory. Declare, initialize, and access a single-dimensional array in Java.

Explore how two dimensional arrays differ from one dimensional arrays using class and school examples, and learn how to size and index multi dimensional data.

Explore two-dimensional arrays by indexing rows and columns, learn zero-based indexing, declare and initialize a three by four rating matrix, and compute a row average while handling out-of-bounds errors.

Explore objects and classes in Java, learning how objects have states and behaviors, how classes serve as templates, and how constructors, instantiation, and static variables enable object creation and access.

Explore encapsulation, binding data and methods together, and data hiding through public and private access, with getters and setters as safeguards.

Explore polymorphism as subtyping in inheritance, enabling a common interface for shapes such as circle and square, each with its own draw and area implementation, and dog and cat sounds.

Create students table by defining id as integer primary key, name as varchar(30) not null, age as integer not null, and grade as decimal, using create table statements and debugging.

Drop tables in a database by using the drop table statement, execute the query, and refresh results; then use insert into to add new rows.

Learn how to create a new table from an existing one using select statements, copying all data with an asterisk from the source table, and understand result sets.

Understand the basic select statement syntax to fetch all or specific columns from a table, for example select * from students or select name, AIDS from students.

Master the where clause in SQL to filter records with conditions, using quotes for strings and applying it in select, update, and delete operations.

Explore the like operator in a where clause, using % and _ wildcards for pattern matching in sql. Find names starting with mal, containing mal, or ending with sequences.

Learn to limit data across MySQL, MSSQL, and Oracle using limit, top, and rownum syntax with practical examples. Apply the same approach to retrieve a specific number of rows.

Learn how to use the distinct keyword with select statements to return only unique records and eliminate duplicates in a data table.

Truncate the table to delete all data in the students table. See how to connect sql with your application to store, manipulate, and query data.