Curriculum
1 Section
126 Lessons
4 Weeks
Expand all sections
Collapse all sections
SQL Basics
126
2.1
Retriving data using the SQL select statement
2.2
Restricting and sorting data
2.3
Using single row function to customize output.
2.4
Reporting aggregated data using the grout function.
2.5
Displaying data from multiple tables –I
2.6
Displaying data from multiple tables-II
2.7
Using sub queries to solve problems
2.8
Using set operators
2.9
Manipulating data
2.10
Using DDL statements to create and manage tables
2.11
Creating other schema objects
2.12
Managing objects with data dictionary
2.13
Controlling User access
2.14
Managing schema objects
2.15
Manipulating large data sets
2.16
Generating report by grouping related data
2.17
Managing data in different time zones
2.18
Retrieving data using sub queries
2.19
Hierarchical retrieval
2.20
Regular expression support
2.21
Introduction
2.22
Declaring Variables
2.23
Writing Executable Statements
2.24
Interacting with Oracle Server
2.25
Writing Control Structures
2.26
Working with Composite Data Types
2.27
Writing Explicit Cursors
2.28
Writing Implicit Cursors
2.29
Handling Exceptions
2.30
Creating Procedures
2.31
Creating Functions
2.32
Managing Subprograms
2.33
Creating Packages
2.34
More Package concepts
2.35
Oracle supplied Packages
2.36
Manipulating Large Objects
2.37
Creating Database Triggers
2.38
More Trigger concepts
2.39
Managing Dependents
2.40
Introduction
2.41
Installing the Oracle Database Structure
2.42
Creating an Oracle Instance
2.43
Managing the Oracle Instance
2.44
Managing Database Storage Structure
2.45
Oracle managed file(OMF)
2.46
Creating a table space
2.47
Administering security
2.48
Managing Schema Objects
2.49
Types of Indexes
2.50
Managing Data and Concurrency
2.51
Locking Mechanism
2.52
Managing Undo Data
2.53
Implementing Oracle Database Security
2.54
Configuring the Oracle Network environment
2.55
Proactive Maintenance
2.56
ADDM
2.57
Performance Management
2.58
Backup and Recovery Concept
2.59
Hot Backup
2.60
Cold Backup
2.61
Hands on practice
2.62
Performing Database Backups
2.63
Performing Database Recovery
2.64
Performing Flashback
2.65
Hands on practice
2.66
Flashback version query
2.67
Moving Data
2.68
Oracle Data pump
2.69
Introduction
2.70
Oracle managed files
2.71
Configuring recovery manager
2.72
Using recovery manager
2.73
RMAN backup types
2.74
Hands on practice
2.75
Recovering from non critical loses
2.76
Database recovery
2.77
Types of incomplete recovery
2.78
Flashback
2.79
Dealing with database corruption
2.80
Hands on practice
2.81
Monitoring and managing memory
2.82
Automatic shared memory management
2.83
Automatic performance management
2.84
Automatic workload repository
2.85
Managed schema objects
2.86
Hands on practice
2.87
Clusters
2.88
Managing storage
2.89
Automatic storage management
2.90
ASM disk group
2.91
Portioning a disk
2.92
Managing resources
2.93
Automatic task with scheduler
2.94
Database security
2.95
Transparent data encryption
2.96
Using globalization support
2.97
Hands on practice
2.98
Introduction
2.99
Oracle managed files
2.100
Configuring recovery manager
2.101
Using recovery manager
2.102
RMAN backup types
2.103
Hands on practice
2.104
Recovering from non critical loses
2.105
Database recovery
2.106
Types of incomplete recovery
2.107
Flashback
2.108
Dealing with database corruption
2.109
Hands on practice
2.110
Monitoring and managing memory
2.111
Automatic shared memory management
2.112
Automatic performance management
2.113
Automatic workload repository
2.114
Managed schema objects
2.115
Hands on practice
2.116
Clusters
2.117
Automatic storage management
2.118
Managing storage
2.119
ASM disk group
2.120
Portioning a disk
2.121
Managing resources
2.122
Automatic task with scheduler
2.123
Database security
2.124
Transparent data encryption
2.125
Using globalization support
2.126
Hands on practice
MySQL Programming
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your Website
Modal title
Main Content
