Cermi Review UTS MT325 – Ranty Irawati

Cermi Review UTS MT325 – Ranty Irawati

Assalamu’alaikum warrahmatullahi wabarakatuh

Good morning or afternoon or evening everbody (depend on the time when you read the resume ^^) ! In Advanced Database as learning subject, we are worked in team. There are 3 students of magister which the major is Business Intelligence. Well, let me introduce our team, we have Mas Zaenal or Mr Zae …he.he.he. Well, I can say Mas Zae is our leader in this team because his knowledge and skill lead us to finish the assignment. We have also Ibu Arum, great expert of weather in Indonesia. Ask anything about climate, she can answer greatly. Can you answer climate of people’s feeling, Ibu Arum ? he.he.he.. .  So, who is third member. Write it my name well… 🙂 My name is Ranty Irawati as you can see ini head of title. I am International Relations scholar graduated who is studying Bussiness Inteliigence. Nice to see you, all. So, here the resume of our assignment from 7 times learning via online. It’s also learning via online with each team. Are you ready !

First Session: Introducing Database & SQL

A database allows you to store information related to a specific topic in an organised way. It’s great when you need to store a searchable collection of data/information in a computer system. Databases are used in a lot of systems today. Almost every web shop has a database with their products, almost every site with a lot of users uses a database to store user information. A blog usually has a database containing all blog articles. All your contacts in your phone are probably saved in a database in your phone. A relational database is a database that presents information in tables with rows and columns, and that’s what we will focus on in this article. Most databases contain one or more tables which may each include several different fields. Tables are uniquely identified by their names and each table is made up of rows and columns, like a grid (as in an excel sheet).

Second Session: Database Table and Data Type

Third Session: Creating Table

Tables are used to store data in the database. Tables are uniquely named within a database and schema. Each table contains one or more columns. And each column has an associated data type that defines the kind of data it can store e.g., numbers, strings, or temporal data.

Example:

CREATE TABLE [database_name.][schema_name.]table_name ( pk_column data_type PRIMARY KEY, column_1 data_type NOT NULL, column_2 data_type, …, table_constraints );

Fouth Session: Inserting Data into Database

You need to know the SQL UPDATE, INSERT, and DELETE commands to modify data in your tables. These are the basics that will allow you to work with tables. As you probably know, SELECT allows you to retrieve data from a database, filter it, and perform computations on it. INSERT, UPDATE, and DELETE allow you to modify data in tables. INSERT adds new rows to a table, UPDATE modifies existing data in a table, and DELETE removes rows from a table.

In computer programming, we use the acronym CRUD—create, retrieve, update, and delete—to describe the four basic operations you can do on data. The four SQL commands SELECT, INSERT, UPDATE, and DELETE allow you to perform these four basic data operations in SQL databases.

Fith & Sixth Session: In, Not In, Like and Between

Some SQL keywords that help you build complex statements include IN, NOT, and LIKE. LIKE uses wildcards, which are used to query similar values, but IN and NOT … difference between the OR and AND operators and using these with the NOT … The % character can be placed at the beginning, end or within your string

Seventh Session: Modyfying Table Part 1

As your data changes over time, SQL provides a way for you to update your corresponding tables and database schemas by using the ALTER TABLE statement to add, remove, or modify columns and table constraints.

Thank you for reading. Have a great day !

ranty

When you know WHY, you’ll find WAY