Description
Grokking Relational Database Design, Video Edition. This course introduces the fundamentals of relational database design with an emphasis on practical implementation and use of the SQL language. The course serves as an illustrated, user-friendly guide to designing and building your first database, reinforcing concepts with exercises and concrete examples. A well-structured database makes it much easier to understand, query, manage, and develop applications as they grow. The course content covers design fundamentals such as table and field naming conventions, the correct location of data storage, eliminating redundancy, best practices for data collection and cleansing, and other essential topics. No computer science degree or specialized programming knowledge is required to benefit from this course, and its easy-to-understand examples and clear definitions make it ideal for beginners. Since nearly every business uses relational database systems, this knowledge is invaluable to software developers, analysts who produce reports and dashboards, and even business users who mine data. This course takes you from an introductory level to mastering the fundamentals of relational database design in a clear, easy-to-follow format.
What you will learn
- Query and create databases using Structured Query Language (SQL).
- Database design from scratch.
- Implementing and optimizing database designs.
- Using Generative AI when designing databases to simplify repetitive tasks.
- Definition of entities and their relationships.
- Minimize anomalies and data duplication.
- Use SQL to implement your designs.
- Database security, scalability, and performance.
This course is suitable for people who:
- Self-taught programmers.
- Software engineers.
- Data Scientists.
- Business data users.
- People who have no prior experience with relational databases.
Grokking Relational Database Design, Video Edition Course Details
- Publisher: Oreilly
- Lecturer: Qiang Hao , Michail Tsikerdekis
- Training level: Beginner to advanced
- Training duration: 5 hours and 5 minutes
Course headings
Course images
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: None
Quality: 720p
Download link
Downloadly
Rapidgator link
File(s) password: www.downloadly.ir
File size
655 MB
