Free SQL Server + Python + Power BI Training for Analyst &BI

Learn how servers store multiple databases, each containing multiple tables; access via Windows authentication or SQL Server authentication, and create or activate databases with queries.

this lecture defines table, record, and field, and demonstrates creating a table with columns and data types via a query or GUI, clarifying rows, columns, and records in a dataset.

Learn to create a sql table and define its columns, rows and data types, such as int, varchar, date, and bigint, then insert and query employee data.

Learn to insert data into the employee table using insert into, including single and multiple row inserts, inserting into all columns or specific columns. Verify results with select.

Learn to write select statements in SQL Server to view all data or select specific columns, and handle spaces in column names using square brackets.

Explore Power BI data extraction with import mode and direct query mode, comparing internal model storage to live data, and note imports up to 1 GB premium and 10 GB.

Learn to use Power BI as a market-leading business intelligence and visualization tool to extract data from multiple sources via ETL, model data, and build reports and dashboards.

Explains Python as a high level open source language with easy syntax, widely used for web, software development, mathematics, and scripting, and covers version 3, case sensitivity, and common editors.

Explain how Python comments improve readability and prevent code execution during testing, using single-line hash comments and multi-line triple quotes with practical Jupyter notebook examples.

Learn Jupyter notebook shortcuts for Python: execute cell with ctrl enter, move to next with shift enter, add or delete cells with alt enter, b, or x, and comment ctrl+/.

Discover how Python uses indentation to define blocks, with four spaces as default and tabs or spaces affecting execution. Avoid indentation errors in if and else blocks by maintaining consistency.

Learn to write basic Python scripts in a Jupyter Notebook, printing messages and storing them in variables. Open a Python 3 kernel, then run code with shift+enter.