Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Grinds required for Databases for Business.

  • 28-03-2012 3:38pm
    #1
    geekfromduleek
    Registered Users, Registered Users 2 Posts: 4 ✭


    Hi,

    Mods please feel free to move this thread if its in the wrong location?
    I am currently studying Databases for Business in college and am struggling to understand concepts/theories.
    I require some expert tutorials and would appreciate any boards members assistance.
    Will to pay for 1 or 2 hours grinds.
    Please PM me if anyone can assist. (I am located in Dublin)

    Please find syllabus covered in topic below:

    General Introduction to Database Systems

    Basic Concepts, Database Approach, History of Database Systems and
    Approaches, Relationships, Database Models - Hierarchical, Network,
    Relational, Object-Oriented.


    Database Management Systems
    Data Independence, Integrity and Redundancy, Data Definition Language,
    Data Manipulation Language, Data Dictionaries, Data Users,
    Data Administrator

    Database Analysis
    Requirements Collection, Data Analysis and Design, Data Representation


    Database Design (Entity Relationship Modelling)
    ER Modelling, Conceptual Data Model, Logical Data Model, Physical Data Model,
    Normalisation, Identifiers, Simple and Complex Relationships, Participation
    Conditions, Transformation of Conceptual Model to Relational Model, Database
    Schemas, Constructing a Data Dictionary.


    Client Server Databases
    ER Modelling, Conceptual Data Model, Logical Data Model, Physical Data Model,
    Normalisation, Identifiers, Simple and Complex Relationships, Participation
    Conditions, Transformation of Conceptual Model to Relational Model, Database
    Schemas, Constructing a Data Dictionary.
    CS Theory, CS versus Stand Alone Databases, Performance Issues,
    2-Tier..N-Tier Architecture


    Database Integrity
    Database transactions - ACID Properties, Lost Updates, Locking,
    Transaction Logs.


    Data Warehousing
    Theory of Data Warehousing, Re-Introducing Redundancy,
    Extract, Transform and Load Processes,
    3-Dimensional Data, Projection, Hot-Keys, Data Cubes
    Database Programming
    Limitations of SQL, Embedded SQL, 4GL’s

    SQL
    Advantages of SQL,
    Syntax of SQL Statements, Relational Databases,
    Key, Attribute, Check Constraints
    Database Tables, Forms, Macros and Reports.
    Tables, Forms,Macros, Reports


Advertisement