DB-101 : Relational Database Design
- 15Training hours
- 5Lectures
- 5Assistant hours
- 350Egyptian pounds
- 10Students maximum
- Master the shaping and structuring of data, and design databases that are both efficient and dependable.
- Be able to analyse data and build very large databases for use in large-scale applications.
What the training programme covers
- What Data Is ?
- Data and information
- Storing Data
- The different ways to store data
- The different types of databases
- Database System Concepts and Architecture
- Using databases in programming projects
- Designing Relational Databases
- Entities & Attributes
- Relations (Tables)
- Keys concept
- Relationships
- Functional dependency
- Modification anomalies
- Normal Forms (6 Normal forms)
- Normalization
- Denormalization
- Using functional dependency to build relations (tables)
- Data integration & Performance
- Database Diagrams
- Entity-Relationship model (ERD)
- System object model (SOM)
- Appling Database Design
- Overview of Microsoft SQL server
- Building tables and relationships in SQL server
- Standard SQL language
- Overview of transact SQL (T-SQL)
Who this course is for
- Computer science students.
- Information systems staff and managers.
- Anyone about to start learning a programming language.
- Anyone interested in working in software.
Job title
Professional database designer
Important notes
This training programme gives no detailed instruction in any database management product. It concentrates solely on designing the database itself, a design you can then apply in whichever database package you use.
Meet the instructors on this course
Chief Executive Officer and database developer
Waleed started out in computer science and programming at around the age of eleven, on the old Q-Basic language, and has worked with a long list of technologies across programming, databases and computer systems in general ever since. He is now chief executive of the software house Code-Times, Ltd, specialising in systems analysis, MS SQL Server database development, and building large-scale applications on MS .NET for both the web and Windows. Alongside that, Waleed runs the training departments at 7dash and designs and delivers a range of specialist computer-science programmes on a model of his own: training material as close as possible to the day-to-day reality of a working software company, rather than an academic syllabus with no regard for how the content is actually applied.
A message for the trainer? Send it from here.A message for the trainer? Send it from here.
The questions we are asked most about this training programme
- Which database management system does this course use?
- This course is about designing relational databases, and a design of that kind can afterwards be implemented on any database management system you choose.
- Do I need to know anything about databases before starting this course?
- No. You need no knowledge of database systems, database types, or even the idea of a database before you start. The course was built to cover exactly those fundamentals and to begin from nothing in the subject.
- What level does this course aim to reach in the end?
- The course is meant to take you to a professional level in relational database design. Even so, it starts from scratch and grounds the basic concepts of the subject, concepts that matter a great deal and that are usually skipped over when databases are taught.
- What is the next step after this course?
- This course is designed to teach you how to plan and design a database "on paper". The next thing you will need is to pick a database management system and implement your designs on it.
- Why doesn't the course also explain one particular database system in detail?
- There are many database management systems on the market, and one person will prefer one over another depending on the nature of their work and what they need. All of them, though, share the same underlying concepts, and it is those concepts this course sets out, so that afterwards you can carry on with whichever database management system you prefer without being tied to one product's material.
Are you following a particular learning path?
Here is where this course sits in every learning path that runs through it
What else comes with this course
-
Sit the course again, free of charge -
Drinks cafeteria -
A comfortable place to study -
Ongoing support -
Private assistance hours
Reserve your seat on this course
Enter your details now and we will call you to fix a date and take you through the booking.
Have a question ?
We are glad to help you get a better grasp of things, so do not hesitate to contact us if you have any questions at all.