Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio

Data Analysis using: MS SQL |Azure SQL| SSMS |Data Studio

4.40 (11 reviews)
Udemy
platform
English
language
Data & Analytics
category
Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio
2,826
students
4.5 hours
content
Oct 2023
last update
$19.99
regular price

What you will learn

Filtering data

Sorting Data

Grouping Data

Combining Data

Create Database and Table

Insert Data

Update and Delete Data

Description

MSSQL is a suite of database software published by Microsoft and used extensively within our enterprise. Typically, it includes a relational database engine, which stores data in tables, columns and rows, Integration Services (SSIS), which is a data movement tool for importing, exporting and transforming data, Reporting Services (SSRS), which is used to create reports and serve reports to end users, and also Analysis Services (SSAS), which is a multidimensional database used to query data from the main database engine.

Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements.

Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.

Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.


Content

SQL Server Setup

Introduction
What is SQL Server
SQL Server Editions
Installation Requirements
Download SQL Server
Install SQL Server
Install SSMS
Connect SSMS to SQL Server
Install Sample Database

Data Analysis with T-SQL & SQL Server

Filtering data with equality filters
Filtering data with comparisons
Filtering data with logical comparisons
Filtering data with string comparisons
Filtering data with NULL Comparisons
Sorting data with ORDER BY
Sorting data in ascending order
Sorting data in descending order
Sorting data by multiple columns
Analysing data with SET Operators
Query data with EXCEPT Operator
Query data with INTERSECT Operator
Query data with UNION Operator
Aggregating data with Aggregate functions
Analyse data using COUNT Aggregate function
Analyse data using AVG Aggregate function
Analyse data using MAX Aggregate function
Analyse data using MIN Aggregate function
Analyse data using SUM Aggregate function
Grouping Data
Analysing and combining data from multiple tables
Analysing data with INNER Join
Analysing data with LEFT Outer Join
Analysing data with Right Outer Join

Azure SQL Data Analysis

What is Azure
What is Azure SQL
Creating Azure Account
How to access Azure Services
Create a database
Query Database
Connect Azure SQL Database with SSMS
Insert data into Azure SQL Database
Update Data in Azure SQL Database
Delete Data from Azure SQL Database
Install Azure Data Studio
Connect Azure Data Studio to Azure Database
Create a new Database
Create a table
Insert data and query data

Coupons

DateDiscountStatus
11/9/2021100% OFF
expired
12/14/2021100% OFF
expired

Charts

Price

Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio - Price chart

Rating

Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio - Ratings chart

Enrollment distribution

Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio - Distribution chart

Related Topics

4384154
udemy ID
11/6/2021
course created date
11/9/2021
course indexed date
Bot
course submited by