Manipulating Data with SQL by Coursera Project Network

You will learn how to write SQL code to modify data in a relational database table in this course. You'll start by entering data into the table. Because a database and its tables are designed to be data repositories, getting the data into the tables is a crucial step in creating a functional database.

When it comes to designing a new house, the real test comes when the furniture and family arrive. It's the same with database tables: once you've designed and built them, the real test begins when you load data into them and start using them.

You'll become familiar with SQLiteStudio, the database management system utilized in the course, as you work through and complete hands-on assignments. You'll get a firsthand look at how data types and constraints affect table data manipulation. You'll appreciate the added protection offered by the main key constraint as you enter new data into a table, for example. It will not allow you to put two identical rows into a table.

You'll develop SQL code to edit existing data values and delete rows of data in addition to adding data to the tables. SQL's core functions are data management and manipulation, and SQL coding will be a valuable addition to your toolkit.

• Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
  

This course offers:

• Flexible Schedule: Set and maintain flexible deadlines.
  
• Certificate : Earn a Certificate upon completion
  
• 100% online
  
• Beginner Level
  
• Approx. 50 minutes
  
• Subtitles: English

Coursera Rating: 4.6/5
Enroll here: https://www.coursera.org/projects/manipulating-data-with-sql