Database Management with MySQL – Internship Inclusive

About Course
Here are the learning objectives for the Database Management with MySQL – Internship Inclusive course:
- Understand the Basics of Relational Databases and MySQL
- Grasp fundamental database concepts, MySQL architecture, and the principles of relational database management.
- Design and Structure Efficient Databases
- Learn to create and organize databases, defining tables, columns, primary keys, and relationships according to best practices.
- Write SQL Queries for Data Manipulation and Retrieval
- Develop proficiency in SQL, mastering commands for SELECT, INSERT, UPDATE, DELETE, and JOIN operations.
- Implement Data Validation and Integrity Constraints
- Apply data validation techniques and constraints to ensure data accuracy and maintain high quality within the database.
- Utilize Views and Stored Procedures for Optimization
- Create and manage views and stored procedures to simplify complex queries and enhance overall database performance.
- Monitor Database Performance and Troubleshoot Issues
- Learn how to monitor the health of databases, diagnose performance problems, and resolve common issues effectively.
- Apply Database Normalization and Data Modeling Techniques
- Master normalization principles and data modeling strategies to design efficient and scalable databases.
- Gain Practical Experience through an Internship
- Apply your knowledge and skills in a real-world internship setting, working on actual projects that prepare you for a successful career in database management.
These objectives will provide you with a comprehensive understanding of database management using MySQL, along with the hands-on experience necessary to excel in the industry!
Course Content
Database Management with MySQL
-
1.1 Course Introduction
05:00 -
1.2 Download & Installation of MySQL
07:00 -
1.3 The Workbench Overview
10:00 -
1.4 The SELECT Statement
09:00 -
1.5 The Select Clause
11:00 -
1.6 The WHERE Clause
08:00 -
1.7 The ORDER BY Clause
07:00 -
1.8 The LIMIT Clause
04:00 -
1.9 The AND, OR and NOT Operator
07:00 -
1.10 The IN Operators
05:00 -
1.11 The BETWEEN Operator
03:00 -
1.12 The LIKE Operator
13:00 -
1.13 The REGEXP Operator
15:00 -
1.14 The NULL Operator
04:00 -
1.15 Inner Join
15:00 -
1.16 Joining Across Database
07:00 -
1.17 Self Join
07:00 -
1.18 Joining Multiple Tables
15:00 -
1.19 Outer joins
10:00 -
1.20 Outer Joins Between Multiple Tables
11:00 -
1.21 Self Outer Join
03:00 -
1.22 The USING Clause
10:00 -
1.23 Natural and Cross Joins
08:00 -
1.24 Unions
14:00 -
1.25 Inserting a Single Row(Column Attributes)
17:00 -
1.26 Inserting a Multiple Rows
07:00 -
1.27 Create a Copy of a Table
09:00 -
1.28 Updating a Single Row
08:00 -
1.29 Updating a Multiple Rows
06:00 -
1.30 Exporting Query Output
12:00 -
2.31 Creating a Database and Table
16:00 -
2.32 Importing Excel file to MySQL Database
11:00 -
2.33 SubQueries in MySQL
08:00 -
2.34 SubQuery across tables
10:00 -
2.35 VIEWS in MySQL Part 1
12:00 -
2.36 VIEWS in MySQL Part 2
12:00 -
2.37 Stored Procedure 1
07:00 -
2.38 Stored Procedure 2
06:00 -
2.39 Stored Procedure 3
10:00 -
2.40 Trigger in MySQL
10:00 -
2.41 Introduction to Function in MySQL
07:00 -
2.42 String Functions in MySQL
14:00 -
2.43 The Number Function in MySQL
06:00 -
2.44 The Date Functions in MySQL
08:00 -
2.45 Aggregate Function in MySQL
05:00 -
Course Review and Further Learning
04:00
Database Management Internship with SQL
Student Ratings & Reviews
No Review Yet