The PCSX2 or PS2 emulator project has been running for a little over four years now, and its reputation has grown steadily since its release.
The PCSX2 project tries to make PS2 code to be applied on your computer, so meaning you can set a PS2 DVD or CD into your computers drive, and boot it up.
Insert, Update and Delete ReviewA final set of quizzes to check you've understood the material on insert, update, delete, and truncate.Always want to play PlayStation 2 games on your computer? PCSX2 1.1.0 is known as a PlayStation 2 emulator for Windows and Linux. This class covers the differences between these operations and when you should use one or the other.
This module also covers the concept of a transaction: a single, logical unit of work.ĭelete and TruncateLearn how to remove data from your database using delete and truncate. Update and TransactionsMaster the basics of changing values in your tables with the update statement. And save and undo your changes with commit and rollback. Insert and CommitLearn how to use insert to loads data into your database tables. Select, Joins and Group By ReviewA chance to recap and catch up on modules 5-7 covering the basics of SQL queries: select, joins and group by. JoinsThis module teaches you about the different types SQL join: inner, left and right outer, full, and cross.Īggregates and Group ByThis class covers how you can summarize your data using aggregate functions and group by. And filter these data using a where clause. Select and WhereLearn how to use a select statement to get you rows from your database.
Tables, Columns and Modeling ReviewA series of quizzes to recap the material from modules 1-3. This class gives an overview of the things you need to consider when designing your tables. This class you about the common SQL data types and their uses.ĭata ModelingDeciding where to store what is one of the fundamental decisions you make when building a database. TablesLearn about the types of table available in Oracle Database, their uses, and how to use create table.Ĭolumns and Data TypesWhen defining columns in a table, you need to choose a data type for them.