MYSQL Tutorials Learning course with examples

Learning SQL will give you wings in any programming grounds. So learning the sql is very important in any type programming and language. This tutorials will give you a knowledge of basic sql and will help you understand the designing of database and knowledge. Tutorial have well structured curriculum with all the concepts covered.

mySQL Programming Tutorials Details :

Theory, Terminology and Concepts
1.Retriving data using the SQL select statement
2.Restricting and sorting data
3.Using single row function to customize output.
4.Reporting aggregated data using the grout function.
5.Displaying data from multiple tables –I
6.Displaying data from multiple tables-II
7.Using sub queries to solve problems
8.Using set operators
9.Manipulating data
10.Using DDL statements to create and manage tables
11.Creating other schema objects
12.Managing objects with data dictionary
13.Controlling User access
14.Managing schema objects
15.Manipulating large data sets
16.Generating report by grouping related data
17.Managing data in different time zones
18.Retrieving data using sub queries
19.Hierarchical retrieval
20.Regular expression support
21.Introduction
Data Definition using SQL
1.Declaring Variables
2.Writing Executable Statements
3.Interacting with Oracle Server
4.Writing Control Structures
5.Working with Composite Data Types
6.Writing Explicit Cursors
7.Writing Implicit Cursors
8.Handling Exceptions
9.Creating Procedures
10.Creating Functions
11.Managing Subprograms
12.Creating Packages
13.More Package concepts
14.Oracle supplied Packages
15.Manipulating Large Objects
16.Creating Database Triggers
17.More Trigger concepts
18.Managing Dependents
Basic Data Manipulation using SQL
1.Introduction
2.Installing the Oracle Database Structure
3.Creating an Oracle Instance
4.Managing the Oracle Instance
5.Managing Database Storage Structure
6.Oracle managed file(OMF)
7.Creating a table space
8.Administering security
9.Managing Schema Objects
10.Types of Indexes
11.Managing Data and Concurrency
12.Locking Mechanism
13.Managing Undo Data
14.Implementing Oracle Database Security
15.Configuring the Oracle Network environment
16.Proactive Maintenance
17.ADDM
18.Performance Management
19.Backup and Recovery Concept
20.Hot Backup
21.Cold Backup
22.Hands on practice
23.Performing Database Backups
24.Performing Database Recovery
25.Performing Flashback
26.Hands on practice
27.Flashback version query
28.Moving Data
29.Oracle Data pump
Transactions
1.Introduction
2.Oracle managed files
3.Configuring recovery manager
4.Using recovery manager
5.RMAN backup types
6.Hands on practice
7.Recovering from non critical loses
8.Database recovery
9.Types of incomplete recovery
10.Flashback
11.Dealing with database corruption
12.Hands on practice
13.Monitoring and managing memory
14.Automatic shared memory management
15.Automatic performance management
16.Automatic workload repository
17.Managed schema objects
18.Hands on practice
19.Clusters
20.Managing storage
21.Automatic storage management
22.ASM disk group
23.Portioning a disk
24.Managing resources
25.Automatic task with scheduler
26.Database security
27.Transparent data encryption
28.Using globalization support
29.Hands on practice
Import/Export
1.Introduction
2.Oracle managed files
3.Configuring recovery manager
4.Using recovery manager
5.RMAN backup types
6.Hands on practice
7.Recovering from non critical loses
8.Database recovery
9.Types of incomplete recovery
10.Flashback
11.Dealing with database corruption
12.Hands on practice
13.Monitoring and managing memory
14.Automatic shared memory management
15.Automatic performance management
16.Automatic workload repository
17.Managed schema objects
18.Hands on practice
19.Clusters
20.Managing storage
21.Automatic storage management
22.ASM disk group
23.Portioning a disk
24.Managing resources
25.Automatic task with scheduler
26.Database security
27.Transparent data encryption
28.Using globalization support
29.Hands on practice