Ravindra BagaleCourses & study guides

4. Connecting to Databases: SQL Server, MySQL, DirectQuery and Live Connection

By Last updated:

Mitrano, company madhe bahutek data database madhe asto – SQL Server kiwa MySQL. Ya module madhe aapan database la connect kasa karaycha, native SQL kasa lihaycha, query folding (काम स्रोत डेटाबेसकडे सोपवणे) kay aahe, aani Import, DirectQuery (डेटा स्रोतातच राहतो, प्रत्येक क्लिकला थेट क्वेरी) aani Live connection madhla farak ekdum clear karu. Interview madhe he khup vicharla jaata, mhanun lakshpurvak vacha.

What you will learn in this module

  • Database words every analyst must know: server, database, schema, table, view
  • Connecting to Microsoft SQL Server step by step: authentication, Navigator, native SQL queries
  • Query folding with databases and View Native Query
  • Connecting to MySQL, including the driver install and common errors
  • Import vs DirectQuery vs Live connection, explained clearly
  • The on-premises data gateway, data source settings and privacy levels

In real companies, quick-commerce orders are stored in databases, not Excel files. The store app writes each order into tables, and analysts connect Power BI to those tables. This module uses a fictional practice database called QuickCommerceDB, with the same tables as our sample data (Module 1.7).

Concepts in this chapter

  1. 4.1Database Terms in Simple Words
  2. 4.2Connecting to Microsoft SQL Server
  3. 4.3Advanced Options and Native SQL Queries
  4. 4.4Query Folding with Databases and View Native Query
  5. 4.5Connecting to MySQL
  6. 4.6DirectQuery in Practice
  7. 4.7Import vs DirectQuery vs Live Connection – Clearly Explained
  8. 4.8The On-premises Data Gateway
  9. 4.9Data Source Settings, Changing Sources and Privacy Levels

The chapter recap is at the end of the last concept page.