Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence SQL

SQL Bootcamp for Business, Product, & Data Analysts

SQL Server 2017, SQL Querying and Reporting
Rating: 4.1 out of 54.1 (16 ratings)
1,346 students
Created by Manish Narayan
Last updated 4/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • SQL Programming
  • SQL Server 2017
  • Transforming Business Requirements into SQL Queries
  • SQL Reporting

Requirements

  • Basic Technical Background

Description

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!

Who this course is for:

  • 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

Course content

12 sections • 55 lectures • 2h 0m total length

  • Preview04:21
  • Installation of SQL Server 2019 & SSMS
    04:09
  • Connect To Sql Server
    03:04
  • Create Sample Database (MediaStoreDb)
    04:18
  • Generate a Database Relationship Diagram
    01:48

  • Get all Customer Details
    03:39
  • Get all Album Details
    00:39
  • Get Customer Fields
    01:16
  • Get Track Fields
    01:24
  • Get Employee Fields
    01:31

  • Display Customer Phone Number using Custom Field Name
    01:38
  • Display Track Unit Price using Custom Field Alias
    01:18

  • Get Customers Unique Countries
    01:55
  • Get Employee Titles
    00:54

  • Get Tracks having Track Length Condition
    02:35
  • Preview03:00
  • Tracks Starting With The Letters A - F
    01:14
  • Tracks Not Starting With The Letters A - F
    01:54
  • Get Invoices Between Two Dates
    01:48
  • Get Customers from California and Florida
    01:25
  • Get Management Level Employees
    01:08
  • Get IT Staff Level Employees
    01:00
  • Customers in USA, Canada with Custom Last Name
    01:37
  • Customers not from USA with Custom Last Name
    01:43
  • Customers Missing a State Code
    01:04

  • Customers Living in Berlin Sorted
    01:57
  • Most Recent Orders between Two Dates
    01:29
  • Employees Sorted by Title and Last Name
    01:33
  • Tracks Having a Composer Sorted by Name
    01:01

  • Last Five Invoices Created
    01:15
  • Top 10% of Tracks by Length
    01:37
  • First Ever Invoice Created
    01:00

  • Preview02:42
  • Total Price of Each Invoice with Condition
    01:08
  • Average Track Length
    01:16
  • Customer Count by Country
    01:47
  • Countries Having Less than 5 Customers
    01:02
  • Invoice Count per Customer
    01:08
  • Longest Running Track and Total Tracks
    01:37
  • Average Runtime, Total Price, Highest Bytes,Total Tracks (All Albums)
    01:59
  • Average Runtime, Total Price, Highest Bytes,Total Tracks (Per Album)
    01:31

  • Customer Display Name (Last, First)
    01:36
  • Apply 50% Discount of Track's Unit Price
    02:16

  • Tracks Having Runtime Smaller than Average
    02:18
  • Customers with Invoices More Than Some Amount
    01:50
  • Tracks Having No Sales
    01:15
  • Genres Having No Sales
    02:26

Instructor

Manish Narayan
President - Innovative Institution, Professor of Engineering
Manish Narayan
  • 4.4 Instructor Rating
  • 3,608 Reviews
  • 24,490 Students
  • 12 Courses

Professor Manish Narayan had a passion for teaching since an early stage in his career and his vision is to share his wealth of knowledge and subject matter expertise with all students and professionals at any level across universities and companies world wide.

An educational background in Mathematical Physics (B.S.), Aerospace Engineering (M.S.) coupled with years of Software Architecture and Development, Professor Narayan currently lectures as a Professor of Mechanical Engineering, has taught various technical seminars at Fortune 100 companies including General Motors, Lockheed Martin, The Aerospace Corporation, and U.S. Air Force

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.