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

Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio, available at $19.99, has an average rating of 4.4, with 49 lectures, based on 12 reviews, and has 2834 subscribers.

You will learn about Filtering data Sorting Data Grouping Data Combining Data Create Database and Table Insert Data Update and Delete Data This course is ideal for individuals who are Beginners to Data Analysis with Microsoft SQL (T-SQL) It is particularly useful for Beginners to Data Analysis with Microsoft SQL (T-SQL).

Enroll now: Microsoft SQL Analyst- MS SQL |Azure SQL| SSMS |Data Studio

Summary

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

Price: $19.99

Average Rating: 4.4

Number of Lectures: 49

Number of Published Lectures: 49

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 49

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Filtering data
Sorting Data
Grouping Data
Combining Data
Create Database and Table
Insert Data
Update and Delete Data

Who Should Attend

Beginners to Data Analysis with Microsoft SQL (T-SQL)

Target Audiences

Beginners to Data Analysis with Microsoft SQL (T-SQL)

MSSQLis 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.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Overview of SQL Server

Lecture 2: Introduction

Lecture 3: What is SQL Server

Lecture 4: SQL Server Editions

Lecture 5: Installation Requirements

Lecture 6: Download SQL Server

Lecture 7: Install SQL Server

Lecture 8: Install SSMS

Lecture 9: Connect SSMS to SQL Server

Lecture 10: Install Sample Database

Chapter 2: Data Analysis with T-SQL & SQL Server

Lecture 1: Filtering data with equality filters

Lecture 2: Filtering data with comparisons

Lecture 3: Filtering data with logical comparisons

Lecture 4: Filtering data with string comparisons

Lecture 5: Filtering data with NULL Comparisons

Lecture 6: Sorting data with ORDER BY

Lecture 7: Sorting data in ascending order

Lecture 8: Sorting data in descending order

Lecture 9: Sorting data by multiple columns

Lecture 10: Analysing data with SET Operators

Lecture 11: Query data with EXCEPT Operator

Lecture 12: Query data with INTERSECT Operator

Lecture 13: Query data with UNION Operator

Lecture 14: Aggregating data with Aggregate functions

Lecture 15: Analyse data using COUNT Aggregate function

Lecture 16: Analyse data using AVG Aggregate function

Lecture 17: Analyse data using MAX Aggregate function

Lecture 18: Analyse data using MIN Aggregate function

Lecture 19: Analyse data using SUM Aggregate function

Lecture 20: Grouping Data

Lecture 21: Analysing and combining data from multiple tables

Lecture 22: Analysing data with INNER Join

Lecture 23: Analysing data with LEFT Outer Join

Lecture 24: Analysing data with Right Outer Join

Chapter 3: Azure SQL Data Analysis

Lecture 1: What is Azure

Lecture 2: What is Azure SQL

Lecture 3: Creating Azure Account

Lecture 4: How to access Azure Services

Lecture 5: Create a database

Lecture 6: Query Database

Lecture 7: Connect Azure SQL Database with SSMS

Lecture 8: Insert data into Azure SQL Database

Lecture 9: Update Data in Azure SQL Database

Lecture 10: Delete Data from Azure SQL Database

Lecture 11: Install Azure Data Studio

Lecture 12: Connect Azure Data Studio to Azure Database

Lecture 13: Create a new Database

Lecture 14: Create a table

Lecture 15: Insert data and query data

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 3 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu