Loading...

Course Description

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.

Related Courses

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.

Prerequisites

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

Expected Outcomes

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
  • LABS

SQL Manipulations

  • Inserting, updating, deleting
  • SQL Joins
  • SQL subqueries inner, outer, right
  • LABS

Advanced SQL Manipulations

  • Create database
  • Create table
  • REGEXP
  • LABS
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.