Description
Query and modify relational data with SQL and MySQL. The curriculum continues into stored procedures, transactions, database design, indexing and security.
The archive covers single-table and multi-table queries, aggregation, complex queries and MySQL functions. Views, triggers, concurrency, data types and performance-oriented indexing have dedicated sections.
This available collection was added to MEGA on 10 October 2021. It contains the named course version and curriculum; a recent update or complete current provider catalogue has not been verified.
What you will learn
- Retrieve and combine data from multiple tables.
- Insert, update and delete records.
- Write aggregations, complex queries and stored procedures.
- Use transactions and design relational schemas.
- Improve query performance with indexes and database security.
Course specifications
- Publisher
- CodeWithMosh
- Instructors
- Mosh Hamedani
- Video Files
- 153
- Total Files
- 218
- Subtitle Files
- 54
- Collection Added
- 2021-10-10
- Language
- English
- Duration
- 11 hours (official listing)
- Level
- Beginner to Pro
Course topics
- 1. Getting Started
- 2. Retrieving Data From a Single Table
- 3. Retrieving Data From Multiple Tables
- 4. Inserting, Updating, and Deleting Data
- 5. Summarizing Data
- 6. Writing Complex Query
- 7. Essential MySQL Functions
- 8. Views
- 9. Stored Procedures
- 10. Triggers and Events
- 11. Transactions and Concurrency
- 12. Data Types
- 13. Designing Databases
- 14. Indexing for High Performance
- 15. Securing Databases
Pictures
AI Feders artworkIntroduction video
How to open the files
Open this course’s MEGA folder using the download link. Select the files or folders you need in MEGA; the course files are stored there.
The collection may contain video recordings, matching subtitles, exercises and project archives. Keep associated subtitles beside the video files.
Download resources
Choose one edition and keep its parts together. Alternate providers are available when listed.
Size
13.97 GiB
Leave a Reply
Signed-in member comments appear immediately.