What are the various components of SQL Server (T-SQL, DBA, SSRS, SSIS, SSAS, and Azure)?
In this video, we'll have a look at the various programs which make up SQL Server.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
When you think about Microsoft SQL, what comes to mind first is probably T-SQL, Microsoft’s implementation of the SQL programming language. T-SQL is short for Transact Structured Query Language, and it focuses on SELECT statements.
But there are many other aspects of SQL Server.
Database Administration (DBA) focuses on the SQL Server engine and databases. Instead of querying data, you manage them, including patching and backups.
SQL Server Reporting Services (SSRS) allow you to create reports based on database data.
SQL Server Analysis Services (SSAS) create cubes or models of your existing data. Cubes are used in the SSAS MDX version, and models are created in the SSAS Tabular version. These cubes can take some time to set up, but once you do, both cubes and models can make your analysis quicker and easier to interrogate.
In SQL Server Integration Services (SSIS), you create data flows. This enables you to transform your data from one form to another.
Смотрите видео What are the various components of SQL Server (T-SQL, DBA, SSRS, SSIS, SSAS, and Azure)? онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал SQL Server 101 17 Ноябрь 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 608 раз и оно понравилось 29 посетителям.
