Database Structures and Management with MySQL
Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. By the end of this course, you’ll be able to:
- Utilize the MySQL DBMS to build and modify relational databases with SQL
- Add records to a MySQL database
- Perform intricate queries on database records with filters and groupings
- Create …
Database Structures and Management with MySQL
Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. By the end of this course, you’ll be able to:
- Utilize the MySQL DBMS to build and modify relational databases with SQL
- Add records to a MySQL database
- Perform intricate queries on database records with filters and groupings
- Create simple joins and unions within a database
- Create relationships between tables using primary and foreign keys
- Demonstrate the ability to complete a database normalization project
You’ll gain experience with the following tools and software:
- MySQL DBMS
- Joins and Unions
- SQL statements, clauses and data types
- Primary and foreign keys
- Database normalization
Utilize the MySQL DBMS to build and modify relational databases with SQL.
Create relationships between tables using primary and foreign keys .
Syllabus
Syllabus - What you will learn from this course
Week 1
Intro to MySQL
Week 2
Updating databases and working with views
Week 3
Functions and MySQL stored procedures
Week 4
Graded assessment
FAQ
When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Reviews
