Diploma in RDBMS (VB/SQL/Oracle/D2K)

ALMA offers many job oriented computer courses.”Diploma in RDBMS” is one of the ALMA approved course.The detailed contents of this course is in the attachment.
COURSE CODE : DP-08
ELIGIBILITY : 10th
DURATION : 10 Months
SYLLABUS
MS Access
MS Access
- Introduction , Different Between DBMS /RDBMS , Hierarchy , Database File , How to Start work , Create database using wizard , Create blank Database
Data base object
- Table , Primary key , Manipulate data , Field properties , Relationships , Forms , Sub forms , Queries , Operators , Calculations , Update Query , Reports , Macro , Import data
MS Visual Basic
- Computer programming , Introduction to Programming languages , Low level languages , Assembly language , Machine languages , Language Processors
Introduction to Visual Basic
- Introduction to programming , Advantages& Disadvantages , Features , Edition
Building a VB Application
- Project , Forms , Controls , Properties , Event procedures , Modules , VB Operate Modes , Setting Properties , Writing codes
Controls
- VB standard controls
Data types
- Types declaration character , Variables , Variable declaration , Default variant , Implicit , Explicit , Procedure level , Form level , Global level
Message Box
Operator in Visual basic
- Introduction to operator , Arithmetic operator , Relational operator , Logical operator
Conditional branching
- The if statement & select statement , Simple if statement , If else statement , Nested if statement , If else ladder , The select statement
Special Events
- Change event , Key down , Key press , Lost focus
System built in Function
- Data type functions , Math’s functions , String function , Conversion function , Date function , Input box function
Loops
- For loops , For each loops , While loops , Do while loops , With ….end with
Procedure & Modules
- Introduction to procedure & function , Sub procedure , Function procedure , Property procedure , Let method , Get method , Set method , Modules
Menu editor
- Introduction to menu editor , document interface , MDI form , Popup menus
Special controls
- Toolbar control , Status bar , Calendar control , Date picker , Ms tabbed dialog control
Error in Debugging
- Introduction to errors , Kinds of errors , Debugging , Handling run time error
Common Dialog Controls
- Introduction to common dialog control , Open dialog control , Save dialog control , Font dialog control , Print dialog control
File System Object Component
Visual basic and data base
- Introduction to data base , Data control , Database engine , ADO data control , Data control properties , Data bound control , ADO data control methods
Programming with ADO
- Connection object , Command object , Recordset object , Cursor type , ADO library
ADO Data Environment
Ms Hierarchical flex grid control
Data Report
- Introduction to data report , Report section , Other report section
Component Basic
- Introduction to com , Active X EXE , Active X DLL , Active X Control , Check the control , Creating active XDDL , Creating active X control , Package & Development Wizard
RDBMS Concepts , Oracle , SQL
- Oracle Product details , Different data base model , RDBMS components –Kernel , Data dictionary , client /server computing and oracle , Overview of oracle architecture –oracle files , system and user process , Oracle memory , system data base object , protecting data.Oracle data type , working with tables , data Constraints , column level & table level constraints , defining different constraints on the table defining integrity constraints in the ALTER TABLE command , Select Command , logical operator , Range Searching , Pattern Matching , Oracle Function , Grouping data from table in SQL , Manipulation Data in SQL Joining Multiple Tables(Equi joins ) , Joining a Table to self (Self joins) , Sub queries Union , intersect & Minus clause , creating view Renaming the column of a view , granting permissions –updating , Selection , Destroying view.
Developer 2000
- Identifying the Components of Oracle Developer 2000 , Forms 5.0 , Data Manipulation in Forms , Reports 3.0 and Graphics 3.0 , Creating a Basic Form Module , Exploring the Components and Wizards of the Form Builder , Blocks and Frames , Creating a Simple Form Module , Creating a Master-Detail Form Module , Creating Input and Non-Input Items in a Form Module , Creating Text Items and Display Items , Create List Items and Checkboxes , Creating a Radio Group , Form Triggers and Built-Ins , Describing the Scope of Form Triggers , Types of Form Triggers , Forms Built-Ins , Debugging Form Triggers , Creating Windows, Canvases, and Menus , Creating Windows in a Form Module , Creating Various Types of Canvases , Creating Menus and Popup Menus , List of Values , Record Groups , Editor
Editor's Desk
Fundamental Success scripts being true to your word is easy
Say you’re going to do something and then do it. If you make plans to meet your friend, don’t ditch him for some random date. Likewise, if you commit to go on a date with someone, don’t back out at the last minute for no good reason. If you don’t want to commit, don’t commit. If you’re not sure whether you can, check and see. If circumstances change and you have to adapt or postpone the arrangement, that’s fine too. If someone doesn’t want to make an appointment and then realize he’d rather chill instead. He doesn’t want to give ... Read More
- Fundamental Success scripts being true to your word is easy
- Stand up for your beliefs and be stronger to face the Situations
- How Much Faster Can You Learn?
- Never quit – there's always a silver lining
- Stop Saying No I cannot do …!
- You are better able to perform and focus at work
- The Power of Concentration to accomplish great things
- Body Signals Pave Emotional Mastery
- Wishing Happy New Year to be Energetic and Be Confident..!
- What Advice would we have given our self !
- The battle is won or lost in the mind
- Thoughts are Supreme and Create Your Life from Within
- Success means Satisfaction and failures mean pain
- Awaken the Inner Child of yourself
- Fear can stop you from progressing
Share On