SQL Training, APC Learning Solutions

Oracle SQL &amp PL/SQL Syllabus
Introduction to DBMS
● Approach to Data Management
● Introduction to prerequisites
● File and Filesystem
● Disadvantages of file
● Review of Database Management Terminology
● Database Models
● Hierarchal Model
● Network Model
● Relational Model
Introduction to RDBMS
● Feature of RDBMS
● Advantages of RDBMS over FMS ad DBMS
● Need for Database Design
● Support of Normalization Process for Data Management
● Client-Server Technology
Sub Language Commands
● Data Definition Language  (DDL)
● Data Manipulation Language (DML)
Introduction to SQL Database Object
● Pre Defined Datatypes
● DDL Commands
● Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop
● DML-Insert, update, delete
● DQL-SELECT Statements using WHERE clause
● Comparison and Conditional Operators
● Arithmetic and Logical Operators
● Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
● Special Operators – IN (NOT IN), BETWEEN (NOT BETWEEN), LIKE (NOT LIKE), IS NULL (IS NOT NULL)
Built-in Functions
● Arithmetic Functions, Character Functions, Date Functions, Conversion Functions
● Aggregate Functions, OLAP Functions & General Functions 
Grouping the Result of a Query
#sql #python #javascript #java #sqlserver #html #programming #developer #css #database #programmer #coding #software #audiomobil #php #webdeveloper #spl #sq #mysql #code #datascience #webdevelopment #machinelearning #backend #dataanalytics #caraudio
#linux #sqldeveloper #worldcode #codinglife #development #coder #web #csharp #computerscience #microsoft #programador #it #developers #programmerslife #modifikasiaudiomobil #sqldatabase #technology #backenddeveloper #palembang #modifikasiaudio #c #programminglife #soundsystempalembang #modifikasiaudiomobilpalembang #modifikasipalembang #audiomobilpalembang #caraudiopalembang #audiomodification #palembangup #palembangkece #modifikasimobilpalembang #palembanginsta #palembangterhits
● Using Group by and Having Clause of DRL Statement
● Using Order by clause 

Working with Integrity Constraints
● Importance of Data Integrity
● Support of Integrity Constraints for Relating Table in RDBMS
● NOT NULL constraint
● UNIQUE constraint
● PRIMARY KEY constraint
● FOREIGN KEY constraint
● CHECK constraint
● Working with different types of Integrity Constraints 
Querying Multiple Tables (Joins)
● Equi Join/Inner Join/Simple Join
● Cartesian Join
● Non-Equi Join
● Outer Joins
● Self Join
Working with Sub Queries
● Understanding the practical approach to Sub Queries/Nested Select/Sub Select/Inner Select/Outer
Select
● What is the purpose of a Sub Query?
● Sub Query Principle and Usage
● Type of Sub Queries
● Single Row
● Multiple Row
● Multiple Column
● Applying Group Functions in Sub Queries
● The impact of Having Clause in Sub Queries
Maintaining Database Objects
VIEWS in Oracle
● Understanding the Standards of VIEWS in Oracle
● Types of VIEWS
● Relational Views
● Object Views
● Prerequisites to work with views
● Practical approach of SIMPLE VIEWS and COMPLEX VIEWS
● Column definitions in VIEWS
● Using VIEWS for DML Operations