Database Programming with SQL

---

Database Programming With SQL Is a Three days Workshop Organized for III year CSE students in Anurag University.

This workshop engaged  students to implement database models by creating physical databases using SQL. Students will learn basic SQL syntax and the rules for constructing valid SQL statements to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts

Contents Covered in the Workshop :

Day1       

Introduction • Oracle Application Express • Relational Database Technology • Anatomy of a SQL Statement SELECT and WHERE • Columns, Characters, and Rows • Limit Rows Selected • Comparison Operators WHERE, ORDER BY, and Intro to Functions • Logical Comparisons and Precedence Rules • Sorting Rows • Introduction to Functions Single Row Functions Part I • Case and Character Manipulation • Number Functions • Date Functions Single Row Functions Part II • Conversion Functions • NULL Functions • Conditional Expressions.

Day 2

JOINs Part I • Cross Joins and Natural Joins • Join Clauses • Inner versus Outer Joins • Self-Joins and Hierarchical Queries JOINs Part II • Oracle Equijoin and Cartesian Product • Oracle Nonequijoins and Outer Joins Group Functions Part I • Group Functions • COUNT, DISTINCT, NVL Group Functions Part II • Using Group By and Having Clauses • Using Rollup and Cube Operations, and Grouping Sets • Using Set Operators Subqueries • Fundamentals of Subqueries • Single-Row Subqueries • Multiple-Row Subqueries • Correlated Subqueries Ensuring Quality Queries Part I • Ensuring Quality Query Results DML • INSERT Statements • Updating Column Values and Deleting Rows • DEFAULT Values, MERGE, and Multi-Table Inserts DDL • Creating Tables • Using Data Types • Modifying a Table.

Day 3

Constraints • Intro to Constraints; NOT NULL and UNIQUE Constraints •PRIMARY KEY, FOREIGN KEY, and CHECK Constraints • ManagingConstraints Views • Creating Views • DML Operations and Views •Managing Views Sequences and Synonyms • Working With Sequences • Indexes and Synonyms Privileges and Regular Expressions • Controlling User Access • Creating and Revoking Object Privileges • Regular Expressions TCL • Database Transactions.

 

 

 

         

---

---

---

---

Group_photo

5.11 MiB

---