Numeric data types - Create, Read, Update and Delete (CRUD) Operations | Coursera

Numeric data types

video-placeholder

Loading...

Meta

Introduction to Databases

4.7 (435 ratings)

|

23K Students Enrolled

Course 1 of 9 in the Meta Database Engineer Professional Certificate

Enroll for Free

In this course, you will be introduced to databases and explore the modern ways in which they are used. Learn to distinguish between different types of database management systems then practice basic creation and data selection with the use of Structured Query Language (SQL) commands. By the end of this course, you’ll be able to: - Demonstrate a working knowledge of the concepts and principles that underpin how databases work - Identify and explain the different types of core technology and management systems used in databases - Identify and interpret basic SQL statements and commands - Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL - and plan and design a simple relational database system You’ll also gain experience with the following: • Fundamental concepts in database • Basic MySQL syntax and commands • Database management systems • MySQL software • Relational databases

Skills You'll Learn

Database (DBMS), MySQL, database administration

Reviews

4.7 (435 ratings)

5 stars
75.17%
4 stars
20.68%
3 stars
2.52%
2 stars
0.45%
1 star
1.14%

LP

Jan 5, 2023

Thank you so much for the opportunity to learn Introduction to Database learn New things with crisp and clearly Taught Menter and Meta and Coursera thanks for help me..

JA

Jan 8, 2023

This is has is really detailed and the tutor made too easy to understand. It has encourage me to learn and also venture into the area of Database Management.

From the lesson

Create, Read, Update and Delete (CRUD) Operations

In this module, you’ll explore CRUD, or Create, Read Update and Delete operations. You’ll begin with an exploration of SQL data types and learn how to differentiate between numeric data, string data and default values. You’ll also embark upon several exercises in which you’ll learn how to utilize these different data types within your database projects. You’ll then move on to learn how to Create and Read data within a database. You’ll discover how to create databases and tables and populate them with data using SQL statements. Lastly, you’ll explore the SQL statements used for updating and deleting data in a database. And to demonstrate your ability with CRUD operations, you’ll complete exercises that will task you with creating and managing data.

Numeric data types3:20

String data types3:55

Default values4:21

Taught By

Taught by Meta Staff

Try the Course for Free

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.