170 likes | 174 Vues
Aims:<br>Examine the purpose and structure of data storage in relational database management systems <br>Design a relational database solution to meet client requirements <br>Develop a relational database solution to meet client requirements.<br>
E N D
Relational Databases By: Atheer Mahir
First / Second Year • Level 3 (BTEC Extended Diploma in Computing) • Max: 24 students Audience
Learning aims • Examine the purpose and structure of data storage in relational database management systems • Design a relational database solution to meet client requirements • Develop a relational database solution to meet client requirements.
A1 Relational database management systems • A2 Manipulating data structures and data in relational databases • A3 Normalisation A - Examine the purpose and structure of data storage in relational database management systems
B1 Relational database design techniques and processes • B2 Design documentation • B3 Reviewing and refining designs B - Design a relational database solution to meet client requirements
C1 Producing a database solution • C2 Testing the database solution • C3 Reviewing the database solution • C4 Optimising the database solution • C5 Reviewing own skills, knowledge and behaviours C - Develop a relational database solution to meet client requirements
Relational databases are the most popular way of managing information for a number of reasons. • They store data efficiently. • They allow you to retrieve information quickly. • And they're unbelievably flexible. Relational Databases Organise data with the relational model
Government agencies, programmers, gamers, and businesses large and small all over the world rely on relational database's for every day operations. I'm going to show you the things that you need to know in order to build one for yourself. Relational Databases Organise data with the relational model
Hi, my name is Atheer Mahir. It's pretty save to say that without relational database's our world would function very differently. I'm excited to show you why they're so popular. Relational Databases Organise data with the relational model
What you think about databases? You have 5 minutes Quick Q Discuss
Have a need to organize data: To get the most out of this course, you should have a need to organize some data, but that's about it. Relational Databases What you should know
No prior database Knowledge required: This course is aimed at people that are brand new to relational databases, so no prior knowledge is expected. Relational Databases What you should know
Course is not aimed at a specific database platform: it doesn't matter if you plan on creating a database with • SQL Server or • MySQL or • PostgreS or • Microsoft Access, or if you don't even know what any of those are, that's fine, too. • All you need to do is bring a little curiosity about how relational databases work and be ready to apply what you learn to your own data needs. Relational Databases What you should know
Have a need to organize data • No prior database Knowledge required • Course is not aimed at a specific database platform Relational Databases What you should know
5 mins Attendance + Introduction 5 mins objectives - Learning aims - discussing 40 mins Get to know Relational Databases 30 mins Lorem ipsum dolor sit amet, consectetur adipiscing elit 10 mins Lorem ipsum dolor sit amet, consectetur adipiscing elit
Homework Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua • Incididunt ut labore et dolore • Consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua