Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Database Administration and SQL Language Basics

Video Introducing this tutorial

1. About the Author
2. Course Overview
3. Databases
4. Relational Database Management Systems (RDBMS)
5. MySQL Installation on CentOS
6. MySQL Installation on Ubuntu
7. Creating Databases
8. Creating Tables
9. Inserting, Viewing, and Deleting Data
10. Connectors and APIs
11. Constraints
12. Backups and Recovery
13. Numeric Types
14. Date and Time Types
15. String Types
16. Views
17. Triggers
18. Stored Routines
19. Events
20. Creating and Deleting Users
21. Granting Privileges
22. Creating and Assigning Roles
23. Creating a Table with Constraints
24. Inserting
25. Updating
26. Altering Tables Part 127. Altering Tables Part 2
28. Deleting
29. Dropping
30. Creating an Index
31. Selecting
32. Clauses and Operators
33. GROUP BY and ORDER BY
34. Unions
35. Joins
36. What's Next