SQL Server Developer - Using SQL Server, TSQL and Power BI

SQL Server Developer : Using SQL Server, TSQL and Power BI, available at $19.99, has an average rating of 3.5, with 37 lectures, 1 quizzes, based on 17 reviews, and has 824 subscribers.

You will learn about You will learn how use SQL Server and Power BI and wants to become a SQL Server Developer Get employed using SQL Server and Power BI to becoming a SQL Server Developer Having knowledge of SQL Server and Power BI, you will learn how to install SQL Server Having knowledge of SQL Server and Power BI, you will learn how to use Power BI to becoming a SQL Server Developer Having knowledge of SQL Server and Power BI, you will learn how to use TSQL to run queries to becoming a SQL Server Developer This course is ideal for individuals who are Students who want to use SQL Server and Power BI to become a SQL Server Developer It is particularly useful for Students who want to use SQL Server and Power BI to become a SQL Server Developer.

Enroll now: SQL Server Developer : Using SQL Server, TSQL and Power BI

Summary

Title: SQL Server Developer : Using SQL Server, TSQL and Power BI

Price: $19.99

Average Rating: 3.5

Number of Lectures: 37

Number of Quizzes: 1

Number of Published Lectures: 37

Number of Published Quizzes: 1

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: ￡34.99

Quality Status: approved

Status: Live

What You Will Learn

You will learn how use SQL Server and Power BI and wants to become a SQL Server Developer

Get employed using SQL Server and Power BI to becoming a SQL Server Developer

Having knowledge of SQL Server and Power BI, you will learn how to install SQL Server

Having knowledge of SQL Server and Power BI, you will learn how to use Power BI to becoming a SQL Server Developer

Having knowledge of SQL Server and Power BI, you will learn how to use TSQL to run queries to becoming a SQL Server Developer

Who Should Attend

Students who want to use SQL Server and Power BI to become a SQL Server Developer

Target Audiences

Students who want to use SQL Server and Power BI to become a SQL Server Developer

Do you want to learn how to use Microsoft SQL Server and Power BI and become a SQL Server Developer?

This SQL Server and

Power BI course is for anybody who has zero knowledge of using Microsoft SQL Server and Power BIwants to becomea SQL Server Developer.

As more organizations adopt DevOps for application lifecycle management, developers

and other non-professional database administrators find themselves responsible for

developing and operating databases.

This course will show you how to start on the path of learning SQL Server and Power BIto becoming a SQL Server Developer.

You will learn how to

Install SQL Server

Use SQL Server to retrieve information from a database

Use SQL Server to update information from a database

Use SQL Server to delete information from a database

Use SQL Serverto insert information into a database

How to join tables within a SQL Server database.

How to filter information within a SQL Server database

How to use Power BI to retrieve information from SQL Server to produce reports

How you can use Power BI to create different styles of reports.

How to format different sections of the reports

With this course, you will be able to start to think about different occupations that you would be interested in. You might be interested in becoming a SQL Server Developer after finishing the course or you might venture into becoming a SQL Server Developer.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the course

Lecture 2: Support

Chapter 2: Installing SQL Server on a Windows Server Environment

Lecture 1: Download and Installing SQL Server on the Windows Server environment

Chapter 3: Using SQL Server Management Studio

Lecture 1: Open up the downloaded file from lecture 2

Lecture 2: Using SQL Server Management Studio

Chapter 4: How to create a database and table a SQL Server Database

Lecture 1: What is a database

Lecture 2: What is a table

Lecture 3: Setup and creating test data

Chapter 5: Using T-SQL

Lecture 1: USE Command – Switching Between Databases

Lecture 2: SELECT

Lecture 3: UNION

Lecture 4: DATE Functions

Lecture 5: CASE Statements

Lecture 6: Further Reading

Chapter 6: Joining tables using JOIN Statements

Lecture 1: JOINS : INNER, LEFT AND RIGHT JOINS – PART 1

Lecture 2: JOINS : INNER, LEFT AND RIGHT JOINS – PART 2

Lecture 3: Which JOIN is better? PART 1

Lecture 4: Which JOIN is better? PART 2

Chapter 7: Aggregation Functions

Lecture 1: COUNT Statement

Lecture 2: SUM Statement

Lecture 3: AVG (Average) Statement

Chapter 8: Filter GROUP BY Statement using HAVING Statements

Lecture 1: Filter GROUP BY Statement using HAVING Statements

Chapter 9: Insert Statements

Lecture 1: Insert Statements

Lecture 2: Further Reading

Chapter 10: Update Statements

Lecture 1: Update Statements

Lecture 2: Further Reading

Chapter 11: Delete Statements

Lecture 1: Delete Statements

Lecture 2: Further Reading

Chapter 12: Condition Statements

Lecture 1: IF / ELSE

Lecture 2: Further Reading

Chapter 13: Practice Assignment

Chapter 14: Introduction to Power BI

Lecture 1: Installing Power BI

Lecture 2: Connecting to SQL Server

Lecture 3: Visualizations

Lecture 4: Formatting Dates

Lecture 5: Formatting Columns and Conditional Formatting

Chapter 15: Conclusion

Lecture 1: Well Done

Lecture 2: What to do next

Instructors

Gary Cowan
SQL Server Teacher / AWS Database Teacher / Azure Teacher

Rating Distribution

1 stars: 2 votes

2 stars: 1 votes

3 stars: 2 votes

4 stars: 7 votes

5 stars: 5 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!