In this 2-hour long project-based course, you will learn how to use SQL data definition statements for various data definition tasks and how to use SQL data manipulation statements for data manipulation tasks such as updating records in a table. In addition, you will learn how to upload a CSV file into a database using PostgreSQL.
Performing Data Definition and Manipulation in SQL
Performing Data Definition and Manipulation in SQL
Instructor: Arimoro Olayinka Imisioluwa
3,957 already enrolled
Included with 
Gain insight into a topic and learn the fundamentals.
4.6
(109 reviews)
Beginner level
Recommended experience
2 hours to complete
Flexible schedule
Learn at your own pace
What you'll learn
Learn how to use SQL data definition statements for various data definition tasks such as creating a database, table etc
Learn how to use SQL data manipulation statements for various data manipulation tasks such as updating records in a table, etc
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
2 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There is 1 module in this course
Welcome to this project-based course on Performing Data manipulation and definition in SQL. In this project, you will learn the first steps in SQL which is creating a database. In addition, you will learn how to create tables in a database by setting the correct constraints and datatypes. By the end of this 2-hour long project, you will have created a database, created database object (tables) in the database. After this, you will able to insert data into the tables created. By extension, you will learn how to import a CSV file into your database. Finally, given a table, you will be able to alter and update data in a table. Also, you will how to drop, truncate and delete from tables in relation to data manipulation in SQL and understand the difference between these statements.
What's included
2 readings2 assignments1 ungraded lab1 plugin
Instructor
Instructor ratings
4.6 (9 ratings)Offered by
Recommended if you're interested in Data Analysis
Coursera Project Network
University of Michigan
Fractal Analytics
Coursera Project Network
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.6
109 reviews
- 5 stars
76.14%
- 4 stars
15.59%
- 3 stars
6.42%
- 2 stars
0%
- 1 star
1.83%
Showing 3 of 109
YN
5
Reviewed on Aug 25, 2020
really appreciate the instructor who made it so easy to understand.
SA
5
Reviewed on Oct 19, 2020
A very good hands on course for learning DDL and DML in PostgreSQL.
S
5
Reviewed on Jul 10, 2020
i have a issue with third party rhyme,my work was loss at the middle however i learnt via instructor .
New to Data Analysis? Start here.
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.
More questions
Financial aid available,