Description
This course is intended for anyone who is involved in data exploration and analysis. SQL developers, data analysts, data scientists, and database administrators are all included. It will also be useful for data integration and data warehousing professionals, as well as Python and PowerShell developers looking for a data-centric platform to use with their preferred language.
Syllabus :
1. Open Source, Cross-Platform, Multi-Database
- Open Source
- Cross-Platform and Multi-Database
2. Everything Starts with a Connection
- Getting Started With SQL Server
- Azure SQL and PostgreSQL
- Grouping and the Central Management Servers Extension
- Databases and Servers Quiz
3. SQL Editing Reimagined
- IntelliSense and Snippets
- Object Definitions
- Saving Queries and Snippets
- Minimap
- SQL Queries via the Command Terminal
- Code Snippets Quiz
4. Visualizing and Exporting Your Queries
- Loading Sample Data
- Running Queries and the Results Pane
- SandDance
- Queries Quiz
5. Getting Things Done with Notebooks
- Jupyter Notebooks
- Setting up Our Code Cells
- Charting Our Results
- Kernel Options
- Python Kernel
- Notebooks Quiz
6. Reaching Beyond SQL
- Setting up a Dataflow
- Running Our Dataflow
- Running in the Terminal
- Using the Simple DataFlow Extension for ADS
- PowerShell Quiz
7. Source Control by Design
- Cloning a Git Repository
- Creating Your Own Repository
- Using Git to Manage File Changes
- Publishing Your ADS Repository to GitHub
- Source Control Quiz