Содержание
- 2. What is database ?
- 3. Files (txt, excel and etc.)
- 5. Table
- 6. MySQL MySQL Community Server http://dev.mysql.com/downloads/mysql/ MySQL Workbench http://dev.mysql.com/downloads/workbench/
- 7. MySQL Create Database Command Example:
- 9. Create table syntax
- 10. User table example
- 11. INSERT INTO Statement OR
- 12. Insert example
- 13. UPDATE Statement
- 14. Update example 1
- 15. Update example 2
- 16. DELETE Syntax
- 17. Delete example
- 18. Is your brain still with you ?
- 19. SELECT Statement
- 21. And now ?
- 22. Library database
- 23. Authors - Countries Author Id Name Country_id Country Id Name one to many relationship many to
- 24. Create Table Country
- 25. Add countries
- 26. Create Table Authors
- 27. Add authors
- 28. Inner join
- 29. Show all authors and their countries
- 30. Bu ha ha ha …
- 31. Table books Book Id Name ISBN Release_date But Book can have many authors
- 32. Add books
- 33. Many to many
- 34. Solving many to many relationship
- 35. Final Query
- 37. Скачать презентацию