Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL.
This course is designed to teach the fundamentals of the open source MySQL database structure. Learn MySQL essentials and the basics of MySQL querying structure. In this course, you will work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. You will use various SQL commands, indexes, and views, you can work with and modify data efficiently within a database.
Who Should Attend
This course is designed for people who wish to acquire competency in performing basic database operations and administration using the MySQL
Attend and You Will Receive
Participants who successfully complete this course will receive a certificate of completion from NC State University.
You should have some familiarity with the Microsoft Windows environment, Microsoft Office applications, or similar office productivity applications.
Attend and You Will Learn / Expected Outcome
Upon completion of this course you will be able to identify the fundamental concepts of databases. You will know how to create a preliminary database design. You will know how to use various SQL commands, indexes, and views, you can work with and modify data efficiently within a database
Attend And You Will Learn
Setting Up the Local Server and Introduction to MySQL
- Installing XAMPP server and MySQL
- Introduction to SQL for Web developers using MySQL
- Installing MySQL
- Database design, development, administration
- What are database, table basics, relational database concepts
Type of MySQL Statements - DDL, DML and DCL
- Comments in MySQL
- SELECT statement
- MySQL tutorial - data types
- Numeric data types, date and time types, string types
- SQL functions and expressions
- Inserting, updating, deleting
- SQL Joins
- SQL subqueries inner, outer, right
Advanced SQL Manipulations
- Create database
- Create table