Programming Hub

METADATA - GENDER REPRESENTATION IN VIDEO GAMES INTRODUCTION This dataset contains information on several video games released between 2012 and 2022. The games were chosen based on a series of criteria detailed later in this document. The goal of this dataset is to compile information on the games and their characters to analyze how genders are represented. GAME SELECTION CRITERIA 1. The games must have a storyline. To analyze the paper of each character is essential that games had a plot where characters had a role assigned (even if this role might change based on the player's choices). This excludes games like: - Puzzle games: Tetris, Candy Crush, Minesweepers, etc. - Racing games: Gran Turismo, Formula 1, Mario Kart, etc. - Social Simulators: Animal Crossing, The Sims, etc. - MMORPGs, where the storyline lived by the player, might considerably differ from other players, such as World of Warcraft. - Shooters with no story mode: Fornite, Valorant - Other popular games with no stor

                                                        SQL  Short  Notes What is SQL? • sql is stand for structured query language. • This database language is mainly designed for maintaining the data in relational database management systems. • sql is standard language for accessing and manipulating database. Types of SQL Commands : DDL COMMANDS: • DTM (Data Defined Languages ) used to change the structure of the table Like creating the table, altering the table & Deleting the table. • All the commands in the DDL are auto Committed that means it permanently save all the changes in the database. 1. CREATE : This command is used to create a new database or table. Syntax: CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, Example: CREATE TABLE Employee EmployeelD int;  FirstName varchar(255),  LastName varchar(255),  AddressLine varchar(255),  City varchar(255) );   2. UPDATE : The UPDATE statement is used to modify the existing records in a