Creating Database Tables with SQL

5.0 /5

(1 Rating)

Offered byCoursera

Creating Database Tables with SQL
at
Coursera
Overview

Experience the process of defining, creating, and managing relational database tables using the SQL language

Duration	1 hour
Total fee	₹729
Mode of learning	Online
Schedule type	Self paced
Difficulty level	Intermediate
Credential	Certificate

Creating Database Tables with SQL
at
Coursera
Highlights

Students can download their created material for free
Students can access their cloud desktop across six different sessions
Get instant access to the necessary software packages through Rhyme
Get all learning materials, including the interactive workspace and final quiz
Learn from a split-screen video walkthrough of each step, from a subject-matter expert

Creating Database Tables with SQL
at
Coursera
Course details

Skills you will learn

Database management

Who should do this course?

For learners who are based in the North America region

What are the course deliverables?

Create a relational table with SQL code.
Alter the structure of an existing table with SQL code.
Identify the attributes of a relational table
Database (DBMS)
Sql Commands

More about this course

Throughout the course, students will be exposed to guidelines and rules that database designers use to make sure that the tables will keep the data as safe and accurate as possible
They will learn to use SQL code to incorporate the constraints that help the database management enforce those rules.
As they work through and complete hands-on tasks, they'll become familiar with SQLiteStudio, the database management system used in the course
Tables that are well-designed and created correctly improve data integrity and make data retrieval easier

Creating Database Tables with SQL
at
Coursera
Curriculum

The CREATE TABLE Command

Rules for Relational Tables

Adding Constraints

The ALTER Command

Build a Database with a Script

Creating Database Tables with SQL
at
Coursera
Faculty details

Judy Richardson

Judy Richardson has a background in Information Technology and Education, and has been teaching college-level database, programming, and web development courses for over 20 years. Currently Judy is part owner of a small consulting business providing programming, web development, instructional design and online curriculum development services