Database Developer (MSSQL, SSRS, & SSIS)

Focused View

Bluelime Learning Solutions

5:47:17

35 View

1 - Introduction to Database Development and MSSQL

1 - Introduction.mp4

00:20

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

02:57

10 - SQL Server Editions.mp4

09:43

11 - SQL Server Installation Requirements.html

12 - Download SQL Server.mp4

04:31

13 - Install SQL Server.mp4

09:43

14 - SQL Server Configuration Manager.mp4

08:10

15 - Install SQL Server Management Studio.mp4

05:48

16 - Connect to SQL Server using SSMS.mp4

02:16

17 - Install sample database.mp4

06:28

3 - Visual Studio Setup

18 - What is Visual Studio.html

19 - Visual Studio Installation Requirements.html

20 - Install Visual Studio.mp4

06:46

21 - Visual Studio workloads.mp4

03:59

22 - Install SQL Server Data Tools.mp4

04:09

23 - Install SSDT Templates.mp4

06:21

4 - Creating a Report

24 - What is SSRS.html

25 - Install SQL Server Reporting Services.mp4

02:19

26 - Requirements to configure report server.mp4

02:48

27 - Configure Report Server.mp4

07:04

28 - Create a report server project.mp4

02:05

29 - Create a report definition file.mp4

01:56

30 - Configure a data source for the report.mp4

02:32

31 - Define a dataset for the report.mp4

04:51

32 - Add a table to the report.mp4

03:33

33 - Format the report.mp4

04:43

34 - Grouping data in the report.mp4

03:50

35 - Adding Totals to the report.mp4

04:38

36 - Previewing the report.mp4

00:54

37 - Exporting the report.mp4

00:49

38 - Publishing Reports.mp4

02:26

5 - Implementing ETL with SSIS

39 - Introduction to SSIS and ETL Concepts.html

40 - What is SSIS.html

41 - Installing SQL Server Integration Service.mp4

04:58

42 - Create a a new SSIS Project.mp4

02:13

43 - SSIS designer.mp4

02:18

44 - Add and configure a flat file connection manager.mp4

06:26

45 - Remapping column data types.mp4

11:12

46 - Add and configure an OLE DB connection manager.mp4

03:39

47 - Add a data flow task to package.mp4

05:02

48 - Add and Configure flat file source.mp4

04:28

48 - SampleCurrencyData.txt

49 - Add and configure lookup transformations.mp4

11:29

49 - lookupsqlquery.txt

50 - Add and configure lookup datekey transformations.mp4

09:28

51 - Add and configure OLE DB Destination.mp4

07:53

52 - Test and Run SSIS Package.mp4

02:02

6 - AGGREGATE FUNCTIONS

53 - Introduction to Aggregate Functions.mp4

02:12

54 - AVG Function.mp4

07:52

55 - Count Function.mp4

09:24

56 - Max Function.mp4

06:49

57 - Min Function.mp4

06:50

58 - SUM Function.mp4

07:17

59 - Using Multiple Aggregate Functions.mp4

05:09

60 - Grouping Data.mp4

08:10

7 - Table Joins

61 - TableJoinIntroduction.mp4

00:27

62 - WhyTableJoins.mp4

00:49

63 - RIGHTOUTERJOIN.mp4

09:30

64 - LEFTOUTERJOIN.mp4

12:26

65 - INNERJOIN.mp4

10:36

66 - FULL OUTER JOIN.mp4

10:14

8 - Filtering Records

67 - Introduction.mp4

02:16

68 - Filteringwithbasiccomparisons.mp4

06:07

69 - Filtering with equality filters.mp4

13:35

70 - Filtering with logical comparison.mp4

14:08

71 - Filtering with String Comparison.mp4

11:22

9 - Sorting Data

72 - Introduction.mp4

00:31

73 - sorting by ascending.mp4

04:34

74 - Sorting by descending order.mp4

05:03

75 - sortingbymultiplecolumns.mp4

05:09

Description

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

What You'll Learn?

Understanding the role and importance of a Database Developer in modern data-centric organizations.
Installing and configuring Microsoft SQL Server (MSSQL) for database development.
Creating and managing relational database structures using T-SQL and MSSQL.
Writing SQL queries to retrieve, filter, sort, and aggregate data from databases.
Designing and developing interactive and visually appealing reports using SQL Server Reporting Services (SSRS).
Designing ETL workflows using SQL Server Integration Services (SSIS).
Building data flow tasks to extract data from various sources and transform it for destination systems.
Building data flow tasks to extract data from various sources and transform it for destination systems.

Who is this for?

Aspiring Database Developers: Individuals who are new to the field of database development and want to build a strong foundation in designing, managing, and optimizing databases.

SQL Developers: Those who have experience with SQL but want to expand their skill set to include advanced database development techniques and data integration.

Business Intelligence Developers: Individuals interested in working with data to generate meaningful reports, dashboards, and insights for decision-makers.

IT Professionals: IT professionals looking to enhance their skills and specialize in database development and data integration using Microsoft SQL Server tools.

Data Analysts: Data analysts who want to explore data transformation and integration techniques for enhancing their analytical capabilities.

Database Administrators (DBAs): DBAs who want to expand their skill set beyond database administration to include database development and data integration tasks.

Software Engineers: Software developers who want to broaden their knowledge to include database design and integration into their applications.

Technology Enthusiasts: Individuals with a passion for technology and data who want to explore the world of databases, reporting, and data integration.

Career Changers: Professionals looking to transition into a career in the technology industry, especially those interested in database-related roles.

Students and Graduates: Students pursuing degrees in computer science, information technology, or related fields who want to gain practical skills in database development.

Self-Learners: Anyone with a strong desire to learn and master the concepts and tools of database development, reporting, and data integration.

What You Need to Know?

Basic Computer Skills: Students should have a fundamental understanding of how to operate a computer, navigate through files and folders, and use software applications.

Familiarity with Databases: A basic understanding of databases and their concepts, such as tables, rows, columns, and relationships, will be beneficial.

SQL Fundamentals: Familiarity with SQL (Structured Query Language) basics, including writing SELECT queries, is recommended as the course will involve more advanced SQL topics.

Basic Programming Concepts: While not mandatory, having some knowledge of programming concepts will help students grasp scripting and custom logic aspects in SSIS.

Computer and Software Requirements: Students will need access to a computer with internet connectivity. They should have software like Microsoft SQL Server, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), and any necessary tools for remote learning, depending on the course delivery method.

Understanding of Business Data: A general awareness of business data and its importance in decision-making processes can be helpful when working with databases and reports.

Microsoft Office Skills: Basic skills in using Microsoft Office applications (such as Excel) can aid in understanding reporting concepts and data manipulation.

Willingness to Learn: Enthusiasm for learning about databases, reporting, and data integration is crucial. These areas can be complex, but a willingness to learn and practice will be valuable.

More details

Description
Welcome to thisÂ course on Database Development with a focus on Microsoft SQL Server (MSSQL), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS). In this course, we will embark on a journey into the world of data management and integration, equipping you with the skills and knowledge needed to excel as a proficient Database Developer.
In today's data-driven landscape, effective management and utilization of data are paramount for organizations to make informed decisions, enhance efficiency, and drive innovation. As a Database Developer, you will play a pivotal role in designing, optimizing, and maintaining databases, ensuring seamless data flow, and enabling valuable insights through reports and data integration workflows.
Course Highlights:
Throughout this course, you will delve into the intricacies of Microsoft SQL Server, a leading Relational Database Management System (RDBMS). You will gain hands-on experience in crafting SQL queries to retrieve and manipulate data, designing efficient database structures, and ensuring data integrity.
You will also dive into the world of SQL Server Reporting Services (SSRS), exploring how to design and deliver insightful reports that empower organizations with visualized data. From creating interactive dashboards to producing pixel-perfect printed reports, you will learn to leverage SSRS to present data in compelling and accessible ways.
Furthermore, the course will guide you through SQL Server Integration Services (SSIS), your gateway to orchestrating data workflows, transforming data, and loading it into various destinations. You will learn to build ETL (Extract, Transform, Load) processes, automate data movement, and ensure data quality across different systems.
Course Objectives:
By the end of this course, you will be equipped with the skills to:
Design and create efficient database structures using MSSQL.
Craft complex SQL queries for data retrieval, manipulation, and analysis.
Develop interactive and visually appealing reports using SSRS.
Create ETL workflows, transforming and loading data with SSIS.

Who Should Enroll:
This course is designed for aspiring and current Database Developers, SQL Developers, Business Intelligence Developers, and anyone seeking a solid foundation in database management, reporting, and data integration. Whether you're new to the field or looking to enhance your existing skills, this course is tailored to accommodate learners at various levels of expertise.
Prepare to embark on a transformative learning journey that will empower you to contribute significantly to data-driven decision-making processes. Get ready to explore the dynamic world of databases, reporting, and data integration with Microsoft SQL Server, SSRS, and SSIS. Let's dive in!
Who this course is for:
Aspiring Database Developers: Individuals who are new to the field of database development and want to build a strong foundation in designing, managing, and optimizing databases.
SQL Developers: Those who have experience with SQL but want to expand their skill set to include advanced database development techniques and data integration.
Business Intelligence Developers: Individuals interested in working with data to generate meaningful reports, dashboards, and insights for decision-makers.
IT Professionals: IT professionals looking to enhance their skills and specialize in database development and data integration using Microsoft SQL Server tools.
Data Analysts: Data analysts who want to explore data transformation and integration techniques for enhancing their analytical capabilities.
Database Administrators (DBAs): DBAs who want to expand their skill set beyond database administration to include database development and data integration tasks.
Software Engineers: Software developers who want to broaden their knowledge to include database design and integration into their applications.
Technology Enthusiasts: Individuals with a passion for technology and data who want to explore the world of databases, reporting, and data integration.
Career Changers: Professionals looking to transition into a career in the technology industry, especially those interested in database-related roles.
Students and Graduates: Students pursuing degrees in computer science, information technology, or related fields who want to gain practical skills in database development.
Self-Learners: Anyone with a strong desire to learn and master the concepts and tools of database development, reporting, and data integration.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

MySQL

Database Programming

Microsoft SQL

Bluelime Learning Solutions

Instructor's Courses

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.