Writing Basic SQL Queries¶ As part of this section we will primarily focus on writing basic queries. Standard Transformations Overview of Data Model Define Problem Statement – Daily Product Revenue Preparing Tables Selecting or Projecting Data Filtering Data Joining Tables – Inner Joining Tables – Outer Performing Aggregations Sorting Data Solution – Daily Product Revenue …
Overview of Transactions¶ Let us go through the details related to Transactions.* We typically perform operations such as COMMIT and ROLLBACK via the applications. COMMIT will persist the changes in the database. ROLLBACK will revert the uncommitted changes in the database. We typically rollback the uncommitted changes in a transaction if there is any exception …
Updating Data¶ Let us see how we can update data in the table. Typical syntax UPDATE <table_name> SET col1 = val1, col2 = val2 WHERE <condition> If WHERE condition is not specified all rows in the table will be updated. For now we will see basic examples for update. One need to have good knowledge …
Inserting Data¶ Let us see how to insert the data into the table. We need to use INSERT clause to insert the data. Here is the sample syntax. INSERT INTO <table_name> (col1, col2, col3) VALUES (val1, val2, val3) If we don’t pass columns after table name then we need to specify values for all the …
Creating Table¶ Before getting into action with respect to basic DML and queries or CRUD operations, we need to prepare tables.At this time we have not covered DDL yet. All database operations related to managing tables come under DDL. For now, let’s just create the table by copy pasting below CREATE TABLE statement. We will …
