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
-
1.2 Download & Installation of MySQL
-
1.3 The Workbench Overview
-
1.4 The SELECT Statement
-
1.5 The Select Clause
-
1.6 The WHERE Clause
-
1.7 The ORDER BY Clause
-
1.8 The LIMIT Clause
-
1.9 The AND, OR and NOT Operator
-
1.10 The IN Operators
-
1.11 The BETWEEN Operator
-
1.12 The LIKE Operator
-
1.13 The REGEXP Operator
-
1.14 The NULL Operator
-
1.15 Inner Join
-
1.16 Joining Across Database
-
1.17 Self Join
-
1.18 Joining Multiple Tables
-
1.19 Outer joins
-
1.20 Outer Joins Between Multiple Tables
-
1.21 Self Outer Join
-
1.22 The USING Clause
-
1.23 Natural and Cross Joins
-
1.24 Unions
-
1.25 Inserting a Single Row(Column Attributes)
-
1.26 Inserting a Multiple Rows
-
1.27 Create a Copy of a Table
-
1.28 Updating a Single Row
-
1.29 Updating a Multiple Rows
-
1.30 Exporting Query Output
-
2.31 Creating a Database and Table
-
2.32 Importing Excel file to MySQL Database
-
2.33 SubQueries in MySQL
-
2.34 SubQuery across tables
-
2.35 VIEWS in MySQL Part 1
-
2.36 VIEWS in MySQL Part 2
-
2.37 Stored Procedure 1
-
2.38 Stored Procedure 2
-
2.39 Stored Procedure 3
-
2.40 Trigger in MySQL
-
2.41 Introduction to Function in MySQL
-
2.42 String Functions in MySQL
-
2.43 The Number Function in MySQL
-
2.44 The Date Functions in MySQL
-
2.45 Aggregate Function in MySQL
-
Course Review and Further Learning
04:00
