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!
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024
