IFB130 Lecture Notes - Lecture 6: Relational Database Management System, Sql Server Management Studio, Data Manipulation Language
19 Oct 2018
School
Department
Course
Professor
Document Summary
Database languages: data definition language (ddl, used to specify the database schema, data manipulation language (dml, used to both read and update the database. The part of the dml that involves data retrieval is called a query language. Special-purpose language designed for managing data held in a relational database management system (rdbms: based upon relational algebra and tuple relational calculus, both a ddl and a dml, declarative language (4gl) You could use: enter sql in workbench, use workbench menus, command line, other ways too; such as sql server management studio. No right or wrong method: depends on database engine & personal preference, create database, command to create a new database, you must specify, the db name. It"s also useful to check if it is pre-existing: create a database object, create database database_name; Create database if not exists database_name: other helpful commands, list databases. Create table table_name ( column_1 datatype, column_2 datatype, column_3 datatype): populate the tables with data.
