Udemy - Oracle - The Complete SQL Guide (includes SQL Certification)
Free- Lectures 57
- Length 4.5 hours
- Skill Levels Beginner Levels
- Languages English
- Published 9/2017
Udemy Coupon Code : couponcode
Description
Welcome to my new course, 'Oracle - The Complete SQL Guide (includes SQL Certification)'.
This course starts from scratch, you neither need to know any pre-requisite database knowledge nor any programming expertise.
From the environment Setup to Development, this course covers almost each and every concept required to become an expert SQL certified developer.
Having a deep-dive of the concepts in this course, you'll learn all about:
- Setup Development Environment Setup
- Relational database fundamentals
- Fundamentals of Database
- Table creation and insertion of data
- Data Retrieval Languages (DQL/ DRL)
- Single Rows Function
- Multiple Rows Function
- Integrity Constraints
- Pseudo Columns
- Displaying Data from Multiple Tables i.e. JOINS
- Query types
- SET Operators usage
- Controlling User Access and Database Security
- Oracle Database Administration
- Database objects (Views, Indexes, Sequence, Synonyms)
- OLAP Features in Oracle
- Table Locks
- Data Manipulation Language (DML)
- Transaction Control Language (TCL)
- Data Definition Language (DDL)
- Test driven approach by Integrating Oracle Database with Spring and Hibernate
- Course Roundup and many more...
This course will assist:
- in becoming an proficient 'Oracle SQL Developer' and
- to pass 'Oracle SQL Certification' examination.
Why SQL?
SQL the language is a structured query language designed for managing data in relational database management systems (RDBMS). Relational database management systems are often called SQL databases since they use the SQL language. SQL features provided are:
- Rely on relational tables
- Utilize defined data schema
- Reduce redundancy through normalization
- Support JOIN functionality
- Engineered for data integrity
- Traditionally scale up, not out
- Rely on a simple, standardized query language
- Near universal in adoption
Why Oracle?
Oracle database (Oracle DB) is a relational database management system (RDBMS) from the Oracle Corporation.The system is built around a relational database framework in which data objects may be directly accessed by users (or an application front end) through structured query language (SQL). Database features provided by Oracle are:
- Scalability and Performance Features
- Manageability Features
- Database Backup and Recovery Features
- High Availability Features
- Business Intelligence Features
- Content Management Features
- Security Features
- Data Integrity and Triggers
- Information Integration Features
