Hi All,

I am the CEO here at Kudrant Academy and have over 10 years oracle DBA experience. I’m thrilled to be your guide throughout this course.

In this course, I will teach you the strategies and principles of database design and modelling you will use to design a small database.

These fundamental concepts are necessary for the design, use, and implementation of relational database systems such as the Oracle database management system (DBMS)

Throughout the course you will develop skills for database creation, query formulation, and database development.

By the end of this course, you'll be ready for the oracle database administration course and to start your journey towards a challenging and rewarding career as an oracle database administrator.

It will be up to you to “take action” by completing all the course assignments and lab exercises.

Ready?

Let’s get started!

Imgard Ekokobe
CEO/Database Engineer
Kudrant Academy

Next

This course provides the basic foundation for the other Database administration courses which we will cover later in this program.

A basic foundation in database management is necessary to master details about database administration and this, relational Database concepts course provides a unified and comprehensive foundation.

You'll first learn about the database characteristics and features of database management systems.

• You will focus on skills for database definition – identifying, defining and creating the tables.
• Query formulation – formulate business queries using SQL.
• Data modeling – by creating ERD to represent business requirements and then converting the ERD to a table design.
• You will also learn how to refine/enhance the database designs through conversion and analysis of unwanted redundancy(unnecessary data).

Through mastery of basic database concepts and skills, you should be able to reflect on guidelines and goals for query formation, redundancy elimination and data modeling.

A basic knowledge in computing concepts is required and we will go over some of these concepts during the course.

No computer programming experience is required.

As long as you have a willingness to learn and complete your weekly assignments, you will do well.

This course provides essential background on database management concepts and skills, for  database administration.

You will develop skills for database creation, query formulation, and database development.

These skills will be extended in other courses of the program.

This course provides a foundation for the start of your journey towards a challenging and rewarding career as an oracle database administrator.

Next

This unit provides an overview of the Relational Database Concepts course assignments,  assessments, and software requirements.

This unit reviews the course assignments, assessments and the software requirements for the course.

In  part 1 of this course, you will learn about data modeling, an important skill to develop a business database. You learn the notation of the entity relationship diagram.

In part 2 of this course, you will create and refine an entity relationship diagram into a table design with little or no redundancy.

In part 3 of this course, you will create tables in a relational database and define integrity rules for these tables.

In part 4 of the course, you will write statements in a database language to retrieve data from a relational database.

You will learn to apply the query formulation process to transform an unstructured problem statement into a database language statement.

The course is organized into modules with typically two to three modules per major topic.

Given that this course involves a lot of problem solving and hands-on exercises, the major assessments will come from problem sets.

For most modules, you will have graded quizzes and problems that involve the concepts and skills discussed in the module.

A peer assessment will be used to evaluate your performance on each set of graded problems.

To prepare you for the graded problems, most modules will have ungraded practice problems. You'll have the opportunity to work practice problems, and then review solutions and comments about the solutions.

Most of your learning in this course will come through your work on problem sets, both ungraded and graded and hands on lab exercises.

You will see problem sets involving table creation using the SQL Create Table statement, query formulation using SQL select statements, data modeling using entity relationship diagrams, and table design using conversion rows, and column constraints.

For problem sets involving the Structured Query Language, SQL, you need to use a relational database management system.

You will be use the Oracle Software, which is the leading commercial DBMS product. You will download both a client and a server component for Oracle.

You will use the Oracle client and Oracle SQL developer to connect to your database.

The links to download the Oracle Database server and clients will be provided in Module 2 Unit 2.

We will also provide access to the remote Oracle Database Server for you to complete you Lab assignments.

For the data modeling part of the course,  you will you use the ER Assistant tool (this is a free tool) to create entity relationship diagrams.

The links to access and download The ER Assistant is provided in Module 2 Unit 2 and it is easy to install and use.

Next

This course does have a lab where you’ll be working with Oracle Database Server.

You will use a data modelling tool called ER Assistant to design a small database (about 5 tables) by developing an Entity Relationship Diagram (ERD).

ERD is a graphical way of presenting the database that’s going to be developed.  Once you design the ERD you’re going to translate that into DDL - data definition language, so you’ll be going from the graphical representation to actually defining tables and columns

You will use this DDL statements to create your database objects by running them against your database.

Once you have created your database objects, you can load some data into the tables, you can create views (also called virtual tables).

You will be able to retrieve the data you loaded into your data after loading by using simple SQL select statements.

This is the fundamental level of database design and development.

In order to do the lab work you’ll need to have access to an Oracle database engine.

You will learn how to install oracle on your personal laptop and you will also have access to our database server running on Linux.

Next

For this course, you will be using the Oracle software as your choice for Database Management Software.

For Oracle, I suggest that you use a 32 or 64 bit operating system (windows)  with at least 4G memory.

For this course, we encourage you to download the Oracle 11g R2 Enterprise DBMS.

• You will install and configure and Oracle database 11g R2 Enterprise edition
• You will install and configure the Oracle Client software and SQL developer
• You will setup a connection from the client to the server.

Glossary:

Download: To copy or transfer data from one computer system to another, typically over the internet

Install: Create all the necessary files to run a software program on a computer.

Next

• Follow the link to download Oracle 11g R2  Oracle Technology Network.
• You will be required to create an account with oracle before you can download the software. You account is free (Oracle has made the software available to individuals for free for learning purposes but businesses are required to pay a licensing fee in order to get support).
• You need to install both an Oracle database Enterprise Edition and the Oracle client.
• I recommend that you install the Oracle SQL Developer client as well.

For the Oracle server, I recommend the Oracle 11g R2  Enterprise Edition. Oracle  supports 32 bit and 64 bit versions of Oracle 11g. Check if your windows computer is a 32 bit or 64 bit .

Note :A 64-bit windows operating system can support either a 32-bit database or a 64-bit database. A 32-bit operating system cannot support a 64-bit database. So, version identification of the OS is necessary prior to install oracle.

The biggest difference between 32-bit and 64-bit OSes is that the 32-bit version can only address a bit less than 4GB of memory, in total, for the entire system.

Steps  To Check if   Your Windows 8 & 10 OS is 64 bit or 32 bit

1. Right-click on your mouse and select Control Panel to launch the control panel. You can also select Run and type control in the text box which pops up to launch the control panel.
   
2. Click on the System and Security link.
3. Click on the System link.
   
4. You will see basic information about your computer on the Systems Page. Look for the system type to check if your computer is running a 32 bit or 64 bit operating system.

Installation involves the normal tasks of downloading, copying files, setting up registry items, and so on. The last part of the installation is configuration of a default local database.

Next

What is a query?

A query is a request for data to answer a question.

For example, you may want to know students with GPA above 3.5 in a particular program for a particular year/semester of a university, or the names of the managers in a particular department in a company.

Non-procedural access allows users with little computing skills to submit queries. The user specifies the part of a database to retrieve, with little or no knowledge of what happens behind the scenes when the query is submitted.

Most importantly, users do not need to write complex code.

Non-procedural database languages do not have looping statements such as the statements for, while, and so on, because only the parts of the database to retrieve are specified.

Non-procedural access can reduce the number of lines of code greatly as compared to procedural access.

Most DBMSs provide more than one tool for non-procedural access.

The SELECT statement of the structural query language, SQL, is a non-procedural way to access a database.

There are also many graphical tools you can use to access database such as TOAD, SQL developer, Oracle Enterprise Manager Cloud Control (OEM).

DBMSs support non-procedural access through the database language SQL, graphical tools or query development, form and report development tools, and interfaces in computer programming languages.

Query formulation is a fundamental skill for DBAs.

Question:

List five types of application development tools that use non-procedural access, and explain the relationship of the tools and non-procedural access.

Next