0(0)

Structured Query Language (SQL)

Description

In this tutorial, you will be introduced to SQL and learn how to perform various database operations, specifically using a MySQL database.

SQL is a programming language designed to manage data stored in a relational database
management system (RDBMS). SQL was one of the commercial database languages in the 70s, since then different database vendors have implemented SQL in their products with some variations for example MySQL, Microsoft SQL Server, SQLite etc. In this tutorial we’ll be using MySQL database which is a SQL database used for websites and applications. SQL stores data in tables using rows and columns. You can think of a SQL table like an excel spreadsheet with data that can be queried with a programming language.

What Will I Learn?

  • MySQL keywords and functions so as to perform simple to complex database operations eg CRUD
  • Understand how databases work in the application domain
  • How to export data from databases to CSV
  • How to design databases for specific applications
  • Create databases from existing ones
  • Create tables and databases
  • Insert data into a table

Topics for this course

10h

Introduction to MySQL?

This topic introduces the learner to MySQL database and it's uses e.g as a database for websites. We will also download and install MySQL database.

About the instructors

0 (0 ratings)

2 Courses

22 students

SQL cloud serverd
Free

Requirements

  • A computer

Target Audience

  • Database administrators
  • Database designers
  • Application developers
  • Web developers