– Embracing the information age...–
Click here to see all courses...
SQL is the starting point in learning about database. This is because SQL is the toolset for processing/managing database data. Although Oracle will be used for delivering this course, trainees will be able to apply the skills learnt on the course, to Mysql, SQLite, SQL Server and other relational database systems.
Amongst other things, candidates will learn the fundamentals of SQL. This includes creating tables and transaction management.
The following are some of the jobs the course is needed for: journalism, clerical/administrative, accountancy, software testing, data analysis, and database development. Also, anyone aspiring to become database literate or anyone that wishes to upgrade their general IT knowledge will benefit from attending this course.
The maximum number of students per course is 10.
If the scheduled time/date is not convenient, please send your preferred date to leave your message at https://fujimitsu.com/contactUsForm.php
You will need a computer, good internet connection and a headphone/microphone for this online course. Also, you will need to install Oracle Database Express Edition 11g Release 2
COURSE DESCRIPTION - INTRODUCTION TO SQL/Oracle/DATABASE
This Oracle SQL course is for improvers. Its a live online training that is trainer-led (not a video). Also, it is substantially hands on.SQL is the starting point in learning about database. This is because SQL is the toolset for processing/managing database data. Although Oracle will be used for delivering this course, trainees will be able to apply the skills learnt on the course, to Mysql, SQLite, SQL Server and other relational database systems.
Amongst other things, candidates will learn the fundamentals of SQL. This includes creating tables and transaction management.
The following are some of the jobs the course is needed for: journalism, clerical/administrative, accountancy, software testing, data analysis, and database development. Also, anyone aspiring to become database literate or anyone that wishes to upgrade their general IT knowledge will benefit from attending this course.
The maximum number of students per course is 10.
If the scheduled time/date is not convenient, please send your preferred date to leave your message at https://fujimitsu.com/contactUsForm.php
You will need a computer, good internet connection and a headphone/microphone for this online course. Also, you will need to install Oracle Database Express Edition 11g Release 2
Course Content
Sub Queries
- Basic sub queries - List all students that scored more than the average mark
- Correlated sub queries
Creating database tables
- Data Types
- Primary Keys
- Foreign Keys
- Creating tables
- Altering tables
- Dropping tables
- Querying the Data Dictionary
- Other table constraints - NOT , UNIQUE
- Default data
Types of SQL
- Data Manipulation Language
- Data Definition Language
Transaction and Concurrency
- Commit and Rollback
- What is a transaction?
- Importance of a transaction
- Managing concurrent transactions
Miscellaneous
- Running SQL Scripts
- Outputting results to a file
- Data Dictionary - Information Schema
- Spooling off
Applied SQL II
- Demo of a data model
- How to create Excel files without using Excel
- How to use SQL for creating Excel files
- Demo of how SQL is used for retrieving data in a Java web app
- Demo of how SQL is used for retrieving data in an Android phone app
Click here to see all courses...
ENTRY REQUIREMENT
-
Must be computer literate.
-
Ability to do basic division, multiplication, addition and subtraction. e.g. 7 X 4 and 15 + 79
-
Good knowledge of the topics of this course: BEGINNER - INTRODUCTION TO SQL/Oracle/DATABASE
-
Good knowledge of the topics of this course: BEGINNER - INTRODUCTION TO SQL/MySQL/DATABASE
COURSE OBJECTIVES
-
Learn the fundamentals of SQL.
-
Learn how to create database objects, such as tables.
| Click here to see all courses... |