SQL Bootcamp for Business, Product, & Data Analysts
SQL Bootcamp for Business, Product, & Data Analysts, available at $34.99, has an average rating of 4.65, with 55 lectures, based on 45 reviews, and has 1456 subscribers.
You will learn about SQL Programming SQL Server 2017 Transforming Business Requirements into SQL Queries SQL Reporting This course is ideal for individuals who are Anyone who wants to start working with SQL Server 2017 or Anyone who wants to utilize a database for storing information or Analysts or Business Analysts or Systems Analysts or Product Analysts or Students and Professionals getting started with database systems It is particularly useful for Anyone who wants to start working with SQL Server 2017 or Anyone who wants to utilize a database for storing information or Analysts or Business Analysts or Systems Analysts or Product Analysts or Students and Professionals getting started with database systems.
Enroll now: SQL Bootcamp for Business, Product, & Data Analysts
Summary
Title: SQL Bootcamp for Business, Product, & Data Analysts
Price: $34.99
Average Rating: 4.65
Number of Lectures: 55
Number of Published Lectures: 55
Number of Curriculum Items: 55
Number of Published Curriculum Objects: 55
Original Price: $22.99
Quality Status: approved
Status: Live
What You Will Learn
- SQL Programming
- SQL Server 2017
- Transforming Business Requirements into SQL Queries
- SQL Reporting
Who Should Attend
- Anyone who wants to start working with SQL Server 2017
- Anyone who wants to utilize a database for storing information
- Analysts
- Business Analysts
- Systems Analysts
- Product Analysts
- Students and Professionals getting started with database systems
Target Audiences
- Anyone who wants to start working with SQL Server 2017
- Anyone who wants to utilize a database for storing information
- Analysts
- Business Analysts
- Systems Analysts
- Product Analysts
- Students and Professionals getting started with database systems
Get Started with SQL Bootcamp for the Business, Product, & Data Analyst and Master SQL Programming allowing interaction with relational data!
Are you a student or professional in the field of data science, business or systems analysis, product or maybe even contemplating an educational or career move to the SQL development world? Have you been looking for a quick and easy way to get up and running with SQL Server 2017, SQL Querying & Reporting, and don’t want to go through an overwhelming amount of material just to get your environment setup and ready for building your SQL queries that interact with data? Don’t worry as THIS IS THE COURSE FOR YOU!
In my course, I will teach you how to get your environment setup for SQL Server 2017 and help you to build your first set of SQL queries/reports that store and retrieve relational data quickly and through a step-by-step guided approach. I will be showing you all the necessary installation and setup needed for SQL Server 2017, SQL Server Management Studio, and converting business requirements into SQL code.
Take this course and feel proud of the fact that you will be one step closer towards the rewarding field of Software Engineering, Business Analysis, Data Science using Microsoft SQL Server technologies!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: Installation of SQL Server 2019 & SSMS
Lecture 3: Connect To Sql Server
Lecture 4: Create Sample Database (MediaStoreDb)
Lecture 5: Generate a Database Relationship Diagram
Chapter 2: SELECT
Lecture 1: Get all Customer Details
Lecture 2: Get all Album Details
Lecture 3: Get Customer Fields
Lecture 4: Get Track Fields
Lecture 5: Get Employee Fields
Chapter 3: Column Alias
Lecture 1: Display Customer Phone Number using Custom Field Name
Lecture 2: Display Track Unit Price using Custom Field Alias
Chapter 4: DISTINCT
Lecture 1: Get Customers Unique Countries
Lecture 2: Get Employee Titles
Chapter 5: WHERE (=,<>,>,<,>=,LIKE,BETWEEN,IN (OR/AND)
Lecture 1: Get Tracks having Track Length Condition
Lecture 2: Customers having Last Name Condition
Lecture 3: Tracks Starting With The Letters A – F
Lecture 4: Tracks Not Starting With The Letters A – F
Lecture 5: Get Invoices Between Two Dates
Lecture 6: Get Customers from California and Florida
Lecture 7: Get Management Level Employees
Lecture 8: Get IT Staff Level Employees
Lecture 9: Customers in USA, Canada with Custom Last Name
Lecture 10: Customers not from USA with Custom Last Name
Lecture 11: Customers Missing a State Code
Chapter 6: ORDER BY (ASC/DESC)
Lecture 1: Customers Living in Berlin Sorted
Lecture 2: Most Recent Orders between Two Dates
Lecture 3: Employees Sorted by Title and Last Name
Lecture 4: Tracks Having a Composer Sorted by Name
Chapter 7: TOP
Lecture 1: Last Five Invoices Created
Lecture 2: Top 10% of Tracks by Length
Lecture 3: First Ever Invoice Created
Chapter 8: Aggregates/GROUP BY (SUM,AVG,COUNT,MAX,MIN)
Lecture 1: Total Price of Each Invoice
Lecture 2: Total Price of Each Invoice with Condition
Lecture 3: Average Track Length
Lecture 4: Customer Count by Country
Lecture 5: Countries Having Less than 5 Customers
Lecture 6: Invoice Count per Customer
Lecture 7: Longest Running Track and Total Tracks
Lecture 8: Average Runtime, Total Price, Highest Bytes,Total Tracks (All Albums)
Lecture 9: Average Runtime, Total Price, Highest Bytes,Total Tracks (Per Album)
Chapter 9: Concatenation
Lecture 1: Customer Display Name (Last, First)
Lecture 2: Apply 50% Discount of Track's Unit Price
Chapter 10: Inner Queries/SubQueries
Lecture 1: Tracks Having Runtime Smaller than Average
Lecture 2: Customers with Invoices More Than Some Amount
Lecture 3: Tracks Having No Sales
Lecture 4: Genres Having No Sales
Chapter 11: Joins (INNER, LEFT, RIGHT)
Lecture 1: Customer, Invoice Info for Orders Placed Before March
Lecture 2: Invoice Details for a Specific Customer
Lecture 3: Total Daily Sales by Sales Agent
Lecture 4: Customers Having Zero Orders Placed
Lecture 5: Albums that Generated Zero Sales
Chapter 12: Stored Procedures
Lecture 1: Overview
Lecture 2: Create and Alter Your First Stored Procedure
Lecture 3: Excel GetCustomers Report
Instructors
-
Manish Narayan
President – Innovative Institution, Professor of Engineering
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 0 votes
- 3 stars: 4 votes
- 4 stars: 16 votes
- 5 stars: 23 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!
You may also like
- 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