Course Description
Oracle and Sql is nothing but a Database. In this course participants you can learn the concepts of Relational Databases (RDBMS).
This course provides all the SQL skills that allow developers to write queries on a single and multiple tables, it manipulates data in tables, and create database objects. Students can learn to control its privileges at the object and system level.
This course also covers the creating indexes and constraints, and altering existing schema objects. Participants also learn how to create and query external tables.contributer learn how to use the advanced features of SQL in order of query and manipulate data within the database, use the dictionary for views to retrieve metadata(i.e. Data about the data) and create it also creates a reports about their schema objects. Participants can also learn some of the date-time functions which is available in the Oracle-Database. This course discusses how to use the regular expression which support in SQL.
In this course, Participants use Oracle SQL Developer as the main development tool. SQLPlus is introduced as an alternative development tool.
This course counts towards the Hands of on course requirements for the Oracle Database 11g Administrator Certification. Structured Query Language (SQL) is the set of statements on which all programs can run and users can access data in an Oracle database. Application programs and Oracle tools also allows the users to access the database without using SQL, but these applications in turn must use SQL when executes the user’s request.
This topic give you the idea about the Oracle and Sql database and using this databases you can insert, update, delete, search data from the table and much more on tables.
Course Goal and Objectives:
- Main goal of this course understand the Sql and Oracle then practice examples on that concepts so the student can use the query more correctly in a database means it can perform the operation on a table very well. It helps while accessing the data and modifying and manipulating the data.
- To generate and retrieve customized data using SQL Functions
- To display data from multiple tables using examples of the oracle
- We can create reports of aggregated data
- With the help of Oracle and Sql you can write SELECT statements which includes queries retrieve row and column data from tables with the SELECT statement
- Run data and manipulation statements (DML) to update the data in Oracle Database 11g
- Create tables to store data and use views to display and retrieve data from table
- Control database access to specific objects and manage schema objects
- Using the Manage objects with data dictionary views you can write multiple-column, queries, sub-queries.
- You can use the regular expression which supports in SQL statements or SQL queies.
Target Audience:
- Application Developers which want training on Oracle and Sql.
- Developer requires training on Oracle and Sql.
- PL/SQL Developer, System Analysts, etc. which want to study on oracle and sql they can join the classes by online and study on home so, he/she can save the time also.
- Students which want to study oracle and sql they can also learn by online so they can also saves the time and learn oracle. and the queries which she/he have he/she can directly post on website and our technical team can solve that problem.
- Professionals, IT Students, Developers can see the do the oracle and sql training.
Pre-requisites:
- To Familiarize with data processing concepts and techniques.
- Basic Knowledge of computer with internet is required.
- Interest in Oracle and SQL.
- If you want to study Oracle database then this prerequisites is important – oracle is basically used to maintain a record in a database. it is totally a different domain and it is compare to c or C++. these are mostly commands which you have to execute like create a table, update a table entries. for simple ex, In an organisation employee details will be saved into a database. the table employee will have columns like this namely name, age, designation, qualification, basic pay etc. you need to add new entries to table, delete a entry, update entry,search perticular student by using Id which has assingned in the database. compare to sql oracle is goood database.
How to access:-
Step 1 - eduCBA sends the redemption coupon along with the registration link.
Step 2 - Student will register with his register email id and coupon
Step 3 - Student receive the course access and password on his/her email id
Step 4 - Login using your email id and password and start learning
Benefits of online course:
1. High Quality Content
2. Learn Anywhere Anytime & at Your Pace
3. 24X7 Customer Support
4. Complete Student Support throughout the Program
5. Online Video Training Material
6. Lifetime course access
For any query call/miss call-
Mob-+918587999769/9818826705
Curriculum
Section 1: Oracle SQL 11g
1 Introduction and Objectives
2 SELECT Statement Retrieving Data
3 Retrieve Data From Database
4 Retrieve Data Continues
5 SQL Functions
6 SQL Functions Demo
7 Introduction to sql session7
8 Introduction to sql session8
9 CharacterManipulation Functions Number function MOD function
10 DATE Functions
11 DATE Functions Continues
12 General Functions
13 NVL Function
14 NVL2 Function
15 NULLIF COALESCE CASE DECODE Functions
Section 2: Reporting Aggregated Data Using Group Function
16 Group Functions
17 AVG SUM MIN MAX COUNT DISTINCT GROUP BY Functions
18 Illegal Queries HAVING Nesting Group Functions
Section 3: Using set operators
19 Using set operators
Section 4: Displaying data from Multiple Tables
20 Obtaining Data from Multiple Tables Joins
21 Joins and Types of Joins
22 Displaying data from Multiple Tables Demo Continues
23 Outer Joins and Natural Joins
24 SQL Statement for OUTER JOINS
25 NATURAL JOINS
Section 5: Oracle Architecture
26 Oracle Architecture
27 Oracle Archicture Part2
28 Oracle Archicture Part3
Section 6: Creating Sample Tables
29 Constraints
30 Sample Tables Course Table
31 FACULTY Table Batches Table
32 Primary Key Constraints Foreign Key Constraints
33 Creating Sample Tables
34 Creating Sample Tables Continues
Section 7: Changing Structure and Data
35 ALTER TABLE
36 Modifying Attributes of Existing Columns
37 Manipulating Data
38 Changing Structure and Data Part 4
Section 8: Grouping Data
39 Group By clause
40 GROUP BY and WHERE clause
41 HAVING Clause
42 ROLLUP and CUBE
Section 9: Joining Tables
43 Joining Tables
44 Joins and Alias
45 Self Joins
46 Join Tables
47 Joining Tables Continues
Section 10: Schema Objects Views Sequence synonyms
48 Database Objects
49 Advantages of Views
50 Creating a View
51 Creating a Complex View
52 Sequences
53 Sequences Index
Section 11: Using Subqueries to Solve Queries
54 Using Subquery to solve a Problem
55 Multiple Row Subqueries
Section 12: Managing Objects with Data Dictionary Views
56 Data Dictionary Structures
57 Column Information
