Oracle 11g | 18c : Database Administration,Data Analysis

Focused View

Bluelime Learning Solutions

12:36:06

10 View

1 - Introduction

1 - Course Introduction.mp4

01:07

2 - What is Oracle database.html

3 - What is Oracle 18c.mp4

03:53

4 - What is SQL.mp4

04:32

5 - What is database administration.html

6 - Oracle DBA Responsibilities.mp4

03:56

7 - Oracle Database Developer Responsibilities.mp4

01:45

2 - Oracle Database Server Setup

8 - Oracle Database Hardware Preinstallation.html

9 - Oracle Database Software Preinstallation.html

10 - Oracle Database Download Link.html

11 - Download Oracle 11g.mp4

06:25

12 - Install Oracle 11g.mp4

05:48

13 - Unlock sample schema for Oracle 11g.mp4

03:30

14 - Install Oracle 18c.mp4

07:59

15 - What is SQLPlus.mp4

03:23

16 - Unlock sample schema for Oracle 18c.mp4

05:29

17 - Install Oracle Developer.mp4

05:49

18 - Connect to Oracle Database with SQL Developer.mp4

04:27

19 - Install TOAD.mp4

05:18

20 - Connect to Oracle Database with TOAD.mp4

08:11

3 - Oracle SQL Sub Languages

21 - Introduction.mp4

03:05

22 - What is CRUD.mp4

02:02

23 - DDL CREATE Part 1.mp4

08:50

24 - DDL CREATE Part 2.mp4

08:03

25 - Oracle SQL INSERT Statement.mp4

09:32

26 - DML SELECT.mp4

09:15

27 - DML UPDATE & DELETE.mp4

07:02

28 - DDL ALTER TRUNCATE DROP.mp4

08:39

4 - ORACLE SQL Data Analysis & Manipulation

29 - Oracle Data Types & Constraints.mp4

09:37

30 - Using the FROM Clause.mp4

02:52

31 - Using the WHERE clause.mp4

05:22

32 - Using ORDER BY Clause.mp4

05:48

33 - Limiting & sorting data.mp4

07:18

34 - Using ALiases.mp4

07:47

35 - Excluding duplicate records.mp4

05:53

36 - Null Values.mp4

07:51

37 - Analyse data using LIKE Operator.mp4

09:18

38 - Grouping Data.mp4

07:36

5 - Monitoring Oracle Database

39 - Introduction.mp4

00:53

40 - Monitor & view database sessions.mp4

05:11

41 - Monitor Top SQL Statements.mp4

05:51

42 - Monitor Long Operations.mp4

02:56

6 - Oracle Database Accounts & Security

43 - Types of Oracle Database Users.mp4

04:27

44 - How to create new user with DBA Access.mp4

07:37

45 - Predefined administrative accounts.mp4

03:10

46 - SysDBA Vs SysOPER.mp4

04:46

47 - Establishing database security policy.mp4

06:41

48 - Priviledges and Roles.mp4

10:26

49 - Managing Oracle Database Users.mp4

07:50

50 - Creating a new database user.mp4

06:39

51 - Auditing Database Activities.mp4

07:19

52 - Predefined Oracle Database Accounts.mp4

10:32

7 - Database Backup & Recovery

53 - Introduction.mp4

08:13

54 - Enable ARCHIVELOG Mode.mp4

09:23

55 - Backup Database.mp4

07:27

56 - Restore and Recover Database.mp4

06:12

57 - View and restore historical data.mp4

10:21

58 - Recover Dropped Deleted Tables.mp4

06:47

8 - Oracle Database Server Management

59 - How to shutdown oracle database server.mp4

06:46

60 - How to start Oracle database server.mp4

05:18

61 - Database Schema.mp4

05:12

62 - What is a Tablespace.mp4

05:58

63 - How to create a Tablespace Part 1.mp4

08:35

64 - How to create a Tablespace Part 2.mp4

06:31

9 - Managing UNDO Data

65 - What is UNDO Data.mp4

03:02

66 - UNDO Tablespace.mp4

04:30

67 - UNDO Retention.mp4

04:31

68 - Configure UNDO Retention.mp4

07:03

69 - What is a Transaction.mp4

07:10

70 - REDO Log Files.mp4

04:45

71 - UNDO vs REDO Data.mp4

01:36

10 - Building Web Apps with Oracle with APEX

72 - What is APEX.mp4

02:41

73 - Apps built with APEX.mp4

02:08

74 - How to login to APEX.mp4

03:32

75 - How to display Schema Objects.mp4

07:08

76 - Creating APEX Workspace.mp4

07:51

77 - What we will build.mp4

02:20

78 - Creating the CRUD App.mp4

10:51

79 - Modify the app view.mp4

04:34

80 - Create APEX User.mp4

07:27

81 - Publish App to end users.mp4

08:06

82 - Performing CRUD Operations.mp4

08:39

11 - Data Analysis with Oracle SQL Analytic Functions

83 - What are Analytic Functions.mp4

06:43

84 - Analytic Functions Syntax.mp4

04:07

85 - Partition By Clause.mp4

08:04

86 - Order By Clause.mp4

05:48

87 - Introduction to Windowing Clause.mp4

08:06

88 - Working with a default windowing clause.mp4

10:52

89 - Using Rows and a Windowing clause.mp4

11:25

90 - Using a Range with a windowing clause.mp4

07:36

91 - Using Between And in windowing clause.mp4

09:35

92 - Multiple windows into your data.mp4

05:22

93 - Row Number Functions.mp4

09:26

94 - Rank Functions.mp4

06:04

95 - Dense Rank Function.mp4

05:57

96 - LEAD Function.mp4

06:44

97 - Lag Function.mp4

03:37

98 - First and Last Functions.mp4

08:56

99 - ListAgg Function.mp4

06:14

12 - Data Analysis with Oracle SQL Logical Operators

100 - What are Logical Operators.mp4

00:41

101 - Data Analysis with ALL Operator.mp4

04:02

102 - Data Analysis with ANY Operator.mp4

04:01

103 - Data Analysis with IN Operator.mp4

04:48

104 - Data Analysis with AND Operator.mp4

04:46

105 - Data Analysis with OR Operator.mp4

04:12

106 - Data Analysis with IS NULL Operator.mp4

02:43

107 - Data Analysis with NOT Operator.mp4

02:49

13 - Data Analysis with Oracle SQL SET Operators

108 - What are SET Operators.mp4

04:36

109 - Data Analysis with INTERSECT SET Operators.mp4

02:50

110 - Data Analysis with UNION SET Operator.mp4

05:23

111 - Data Analysis with MINUS SET Operator.mp4

01:48

14 - Analysing Data from multiple tables with Oracle SQL

112 - Introduction to Table Joins.mp4

04:11

113 - Analysing data with SELF Joins.mp4

09:53

114 - Analysing data with OUTER Joins.mp4

08:14

115 - Analysing data with CARTESIAN Join.mp4

06:19

116 - Analysing dat with EQUI Join.mp4

07:46

117 - Analysing data with NON EQUI Join.mp4

07:26

15 - Data Analysis with SQL Aggregate Functions

118 - What are Aggregate Functions.mp4

01:38

119 - Analysing data with AVG Aggregate Functions.mp4

03:21

120 - Analysing data with COUNT Aggregate Functions.mp4

04:40

121 - Analysing data with MIN Aggregate Functions.mp4

02:48

122 - Analysing data with MAX Aggregate Functions.mp4

03:13

123 - Analysing data with SUM Aggregate Functions.mp4

07:17

16 - Practical Real World Oracle SQL Examples

124 - Determine total employees with SQL.mp4

03:27

125 - Update employees salaries with SQL.mp4

11:07

126 - Create employee salary report with SQL.mp4

06:24

127 - Add new record into database with SQL.mp4

09:12

128 - Create s new table with SQL.mp4

07:42

129 - Delete record from database.mp4

05:12

130 - Produce a report of hire date for employees.mp4

12:44

Description

Learn Oracle SQL, Database Administration , Data Analysis, Oracle web application development

What You'll Learn?

Installing Oracle Database 11g & 18c
Installing TOAD & Oracle Developer
Unlock Sample Schema
Perform CRUD Operations
Data Analysis & Manipulation
Monitoring Oracle Database
Oracle Database Accounts & Security
Oracle Database Backup & Recovery
Oracle Database Server Management
Build Web Apps using Oracle Apex
Data Analysis with Oracle SQL Analytic Functions
Data Analysis with Oracle SQL SET Operators
Data Analysis with Oracle SQL Logical Operators
Data Analysis with Oracle SQL Aggregate Functions
Practical Real World Oracle SQL Examples

Who is this for?

Beginner Database Administrator

Beginner Data Analyst

Beginner Data Scientist

Beginner Data Engineer

What You Need to Know?

Computer and internet access required

More details

Description
Oracle Database Administrator's are in constant demand in the IT industry.
TheÂ rapid growth of data has fueled the demand for database administrator's in general.Â We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook,Instagram Whatsapp ,Twitter and may more data rich applications.
This course is designed for beginners who are considering a career as a database administrator. It will guide you through some of the tasks that an Oracle database administrator has to perform.
Oracle DBA Responsibilities includes:
Installing new versions of the Oracle database and its tools
Installing toolsÂ required to access the Oracle database.
Shutting down and Starting the database
Backing up and Recovering Data
Exporting and Importing Data
Managing Users
Managing security of the database
Monitoring the database
Creating database objects like databases, tables and views
Create new database users as required.
Upgrading the database
Plans and implements backup and recovery of the Oracle database.
Assists with impact analysis of any changes made to the database objects.
Provides technical support to application development teams
Enforces and maintains database constraints to ensure integrity of the database.
Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
TroubleshootingÂ problems regarding the databases, applications and development tools.

What is Oracle APEX?
Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere.
Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.

SQL is everywhere, and I'm not saying that because I want you to use it. It's just a fact. I bet you have some in your pocket right now. All Android Phones and iPhones.Â SQL for several years and currently is the most in demand IT Skill requested by recruiters and employers. It is used anywhere there is a database present.Â It runs banks, hospitals, universities, governments, small businesses, large ones, just about every computer and every person on the planet eventually touches something running SQL.
SQL is an incredibly successful and solid technology that has been around for years and will be here for a long time to come.
By learning SQL, you actually will learn important theoretical and practical concepts that apply to nearly every data storage system past and present .
SQL Skills will greatly improve your job prospects either as a contractor or full time employment. It is a useful skill that is always in demand due to its usefulness. Itâ€™s everywhere there is a database. The skills you learn on this course will be enough to confidently work as an SQL professional.
The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw dataâ€”from electronic medical records to customer transaction historiesâ€”lives in organized collections of tables called relational databases. To be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL . This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle.
Who this course is for:
Beginner Database Administrator
Beginner Data Analyst
Beginner Data Scientist
Beginner Data Engineer

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.