Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio
- Description
- Curriculum
- FAQ
- Reviews
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.
-
10
Filtering data with equality filters -
11
Filtering data with comparisons
-
12
Filtering data with logical comparisons
-
13
Filtering data with string comparisons
-
14
Filtering data with NULL Comparisons
-
15
Sorting data with ORDER BY
-
16
Sorting data in ascending order
-
17
Sorting data in descending order
-
18
Sorting data by multiple columns
-
19
Analysing data with SET Operators
-
20
Query data with EXCEPT Operator
-
21
Query data with INTERSECT Operator
-
22
Query data with UNION Operator
-
23
Aggregating data with Aggregate functions
-
24
Analyse data using COUNT Aggregate function
-
25
Analyse data using AVG Aggregate function
-
26
Analyse data using MAX Aggregate function
-
27
Analyse data using MIN Aggregate function
-
28
Analyse data using SUM Aggregate function
-
29
Grouping Data
-
30
Analysing and combining data from multiple tables
-
31
Analysing data with INNER Join
-
32
Analysing data with LEFT Outer Join
-
33
Analysing data with Right Outer Join
