Lectures related to Data definition language

DDL, DML, Views

Covers SQL data definition, manipulation, and views in databases.

SQL: Data Manipulation and Views

Covers SQL data manipulation language, including DDL and DML commands.

Data Definition and Manipulation Languages: Views

Covers creating, modifying, and deleting tables, inserting, updating, and deleting data, and briefly discusses views.

Data Definition and Manipulation Languages

Covers the creation, modification, and deletion of tables, data manipulation, and views.

SQL Basics: Select Queries

Covers the basic principles of the SQL language and select queries.

Database Management Systems: Fundamentals

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.

Totalitarian Logic in 1984

Explores the totalitarian logic in George Orwell's 1984, emphasizing language manipulation and social control mechanisms.

Relational Algebra and SQL: Foundations of Database Management

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Data Wrangling with Hive: Managing Big Data Efficiently

Covers data wrangling techniques using Apache Hive for efficient big data management.

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Managing Columns in Professor Recruitment List

Explains how to manage columns in a professor recruitment list effectively.

Data formats and data wrangling with Hadoop

Explores Apache Hive for data warehousing, data formats, and partitioning, with practical exercises in querying and connecting to Hive.

Transactions and Concurrency Control

Explores transactions, concurrency control, conflict resolution, and snapshot isolation in databases, emphasizing consistency and performance.

Adsorption at Interfaces: Gibbs, Langmuir, and BET Models

Covers the fundamental concepts of adsorption at interfaces, focusing on the Gibbs, Langmuir, and BET models.

Data Wrangling with Hadoop: Storage Formats and Hive

Explores data wrangling with Hadoop, emphasizing storage formats and Hive for big data processing.