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
In this module, you will learn to use the MySQL DBMS to build, modify and query relational databases with SQL.
In this module you'll learn how update databases and work with views.
In this third module, you'll explore different types of functions and learn how to work with MySQL stored procedures.
In this module, you’ll have an opportunity to recap what you learned and identify your strengths as well as target topics that you would like to revisit in this course.
Some points apply to every course of this kind; see how we rank.
Meta is in Tier 2: excellent universities and the companies that build the technology of our institution ranking (84/100).
This is CS50W, CS50's Web Programming with Python and JavaScript. Register for free at https://cs50.edx.org/web. Slides and source code at https://cs50.harvard.edu/web. This course picks up where Harvard University’s CS50 leaves off, diving more deeply into the design and implementation of web apps…
An introduction to cybersecurity for technical and non-technical audiences alike. Learn how to secure your accounts, data, systems, and software against today’s threats and how to recognize and evaluate tomorrow’s as well, both at home and at work. Learn how to preserve your own privacy. Learn to v…
Learning objectives This course picks up where Harvard University's CS50 leaves off, diving more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Flask, Django, and Bootstrap. Topics include database design, scalability, security, and user…
Harvard University · edX
Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML.
Harvard University · edX
Learn the concepts and techniques that make up the foundation of data science and machine learning.
Harvard University · edX
An introduction to the intellectual enterprises of computer science and the art of programming.
