What Can SQL do?

• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop

As organizations embrace a data culture to drive business decisions, they need an enterprise business intelligence platform that can meet their sophisticated needs – from self-service BI to full enterprise governance, from paginated reports to full interactive data exploration, and from small data sets to petabytes of data.

In July, we laid out the roadmap for Power BI to help organizations unify modern and traditional BI on one enterprise platform, and empower business analysts by expanding self-service data prep for big data.  Since then, we’ve shipped a number of capabilities that deliver on this roadmap: Premium multi-geo allows customers to address data residency requirements, aggregations enable data analysis over petabyte sized datasets with trillions of rows of data, and the new Power BI Home landing page and dashboard commenting make it easier to get to your most important content and collaborate across the enterprise.

Today, we’re announcing the availability of several new capabilities that we laid out in our July roadmap.

Dataflows expand self-service data prep in Power BI

Power BI already includes robust self-service data preparation capabilities in Power BI Desktop through the familiar Power Query based experiences that are used by millions of users worldwide. We are excited to announce the public preview of dataflows in Power BI, taking self-service data preparation to the next level.

• Dataflows enable business analysts to create data preparation logic that can be reused across multiple Power BI reports and dashboards.
• Dataflows can be linked together to create sophisticated data transformation pipelines that enable business analysts to build on each other’s work. A new recalculation engine automatically tracks dependencies and recomputes data as new data is ingested.
• Dataflows can be configured to store the data in the customer’s Azure Data Lake Storage Gen2 instance, fueling collaboration across roles. Business analysts can seamlessly operate on data stored in Azure Data Lake Storage, taking advantage of its scale, performance, and security. Meanwhile, data engineers and data scientists can extend insights with advanced analytics and AI from complementary Azure Data Services like Azure Machine Learning, Azure Databricks, and Azure SQL Data Warehouse.
• Dataflows support the Microsoft Common Data Model, giving organizations the ability to leverage a standardized and extensible collection of data schemas (entities, attributes and relationships)
• https://powerbi.microsoft.com/en-us/

PEMAKLUMAN DARIPADA PENGURUSAN USHOP

TEMPAHAN BAJU KORPORAT UTM TERBAHARU

Assalamualaikum wrt. wbt. dan Salam Sejahtera kepada Warga UTM yang dihormati!

Sejajar dengan kempen penjenamaan semula UTM, baju korporat terbaharu telah dilancarkan dengan warna yang lebih menarik dan menepati warna korporat UTM. Baju ini didatangkan dengan saiz yang lebih pelbagai. Berikut adalah beberapa maklumat penting berkenaan tempahan baju korporat yang terbaharu ini:

• Terbuka untuk pra-tempahan (pre-order) bersama wang pendahuluan sahaja
• Tarikh tutup tempahan baju korporat UTM (kumpulan 3/round 3) adalah pada Rabu, 26 Disember 2018 di Kedai Universiti
• Deposit RM50akan dikenakan bagi setiap helai baju yang ditempah (untuk semua saiz)
• Tempahan dijangka siap pada pertengahan bulan Februari 2019
• Hari terakhir untuk membuat tempahan tailor-madeadalah pada hari ini, Selasa (18 Disember 2018) dari jam 11 pagi hingga 2.30 petang di Kedai Universiti (walk-in).

Sebarang pertanyaan, boleh berhubung terus dengan staf UTM Souvenir Shop di talian berikut:

Tel: 07-5566732 atau WhatsApp: 019-8737520 dan emel  :  shop@utm.my

Jangan ketinggalan untuk membuat tempahan dan memiliki baju korporat UTM yang terbaharu ini!

#iamutm

KERJA-KERJA MIGRASI GATEWAY RANGKAIAN DI PUSAT DATA BAHARU, UTM

 Assalamualaikum dan salam sejahtera,

Adalah dimaklumkan bahawa pihak CICT akan melaksanakan kerja-kerja migrasi gateway rangkaian  di Pusat Data Baharu, UTM pada :

Tarikh : 22hb Disember 2018 (Sabtu)

Masa :  9.00 malam – 12.00 tengah malam

Kerja-kerja permindahan ini akan menyebabkan gangguan capaian kepada kesemua sistem universiti yang beroperasi di Pusat Data UTM.

Segala kesulitan amat dikesali.

Harap maklum dan terima kasih.

Definition of a Relational Database
A relational database is a collection of
relations or two-dimensional tables.

Relational Database Properties
A relational database:
 Can be accessed and modified by executing
structured query language (SQL) statements
 Contains a collection of tables with no
physical pointers
 Uses a set of operators

FEATURES OF SQL
 It processes sets of data as groups
rather than as individual units.
 It provides automatic navigation to the
data.
 It uses statements that are complex and
powerful individually, and that therefore
stand alone.
 It is common language for all Relational
Database.