Database Design and SQL
The most important aspect of database-driven web publishing is the database itself. Poorly designed and constructed databases often lead to additional, expensive and unnecessary development (usually requiring extra scripting and retrospective fixes) in order to produce a functioning web application. Netskills can help you develop the skills to be able to produce an efficient, scalable and optimised SQL database for use with your web solutions.
This practical workshop will demonstrate how to develop an initial database design and turn it into a cost-effective, working solution.
Topics:
- Identifying data relationships from a real-life scenarios
- Creating a conceptual database model
- Use of Entity Relationship Diagrams (ERDs) to produce a scalable and efficient database design
- Nomalisation of a conceptual database design
- Mapping a conceptual design to a physical database structure
- Using SQL to create a database structure
- Populating a database using SQL
- Writing simple SQL queries to interrogate a database
Who is it for?
This workshop will be of benefit to anyone who needs to develop database systems using SQL, particularly for use with web-applications. The standard techniques covered can be applied to a wide range of database systems.
To be able to gain the most from this workshop, participants need to have basic computer skills and be comfortable with the concept of using the World Wide Web to access database-driven web sites. A basic awareness and understanding of relational database systems would be advantageous. This workshop would make an ideal companion to Databases on the Web.
By the end of the workshop participants will have:
- Examined real-life business scenarios
- Developed a normalised, conceptual database model
- Produced a physical database structure from a normalised ERD
- Created and populated a physical database using SQL
- Used SQL to query the final database
Scheduled workshops
No workshops scheduled at this time.
