Database Developer (MSSQL, SSRS, & SSIS)

سرفصل های دوره

Mastering Data Management and Integration: Database Developer Proficiency in MSSQL, SSRS, & SSIS

1 - Introduction to Database Development and MSSQL

1 - Introduction

2 - Understanding the role of a database developer.html

3 - Introduction to relational databases and MSSQL.html

4 - Installing and configuring MSSQL Server.html

5 - SQL Server Management Studio SSMS overview.html

6 - Basic SQL queries SELECT INSERT UPDATE DELETE.html

7 - Data types constraints and normalization principles.html

8 - Introduction to TSQL programming.html

2 - Microsoft SQL Server Setup

9 - What is SQL Server

10 - SQL Server Editions

11 - SQL Server Installation Requirements.html

12 - Download SQL Server

13 - Install SQL Server

14 - SQL Server Configuration Manager

15 - Install SQL Server Management Studio

16 - Connect to SQL Server using SSMS

17 - Install sample database

3 - Visual Studio Setup

18 - What is Visual Studio.html

19 - Visual Studio Installation Requirements.html

20 - Install Visual Studio

21 - Visual Studio workloads

22 - Install SQL Server Data Tools

23 - Install SSDT Templates

4 - Creating a Report

24 - What is SSRS.html

25 - Install SQL Server Reporting Services

26 - Requirements to configure report server

27 - Configure Report Server

28 - Create a report server project

29 - Create a report definition file

30 - Configure a data source for the report

31 - Define a dataset for the report

32 - Add a table to the report

33 - Format the report

34 - Grouping data in the report

35 - Adding Totals to the report

36 - Previewing the report

37 - Exporting the report

38 - Publishing Reports

5 - Implementing ETL with SSIS

39 - Introduction to SSIS and ETL Concepts.html

40 - What is SSIS.html

41 - Installing SQL Server Integration Service

42 - Create a a new SSIS Project

43 - SSIS designer

44 - Add and configure a flat file connection manager

45 - Remapping column data types

46 - Add and configure an OLE DB connection manager

47 - Add a data flow task to package

48 - Add and Configure flat file source

48 - SampleCurrencyData.txt

49 - Add and configure lookup transformations

49 - lookupsqlquery.txt

50 - Add and configure lookup datekey transformations

51 - Add and configure OLE DB Destination

52 - Test and Run SSIS Package

6 - AGGREGATE FUNCTIONS

53 - Introduction to Aggregate Functions

54 - AVG Function

55 - Count Function

56 - Max Function

57 - Min Function

58 - SUM Function

59 - Using Multiple Aggregate Functions

60 - Grouping Data

7 - Table Joins

61 - TableJoinIntroduction

62 - WhyTableJoins

63 - RIGHTOUTERJOIN

64 - LEFTOUTERJOIN

65 - INNERJOIN

66 - FULL OUTER JOIN

8 - Filtering Records

67 - Introduction

68 - Filteringwithbasiccomparisons

69 - Filtering with equality filters

70 - Filtering with logical comparison

71 - Filtering with String Comparison

9 - Sorting Data

72 - Introduction

73 - sorting by ascending

74 - Sorting by descending order

75 - sortingbymultiplecolumns

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy