SQL Programming
This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects.
Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Database Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement
How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data
Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions
Date and Time Functions
Text Functions
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions
Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling