SQL Bootcamp for Business, Product, & Data Analysts
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
5 lectures • 18minIntroduction
- Preview04:21
- 04:09Installation of SQL Server 2019 & SSMS
- 03:04Connect To Sql Server
- 04:18Create Sample Database (MediaStoreDb)
- 01:48Generate a Database Relationship Diagram
5 lectures • 8minSELECT
2 lectures • 3minColumn Alias
2 lectures • 3minDISTINCT
11 lectures • 18minWHERE (=,<>,>,<,>=,LIKE,BETWEEN,IN (OR/AND)
4 lectures • 6minORDER BY (ASC/DESC)
3 lectures • 4minTOP
9 lectures • 14minAggregates/GROUP BY (SUM,AVG,COUNT,MAX,MIN)
2 lectures • 4minConcatenation
4 lectures • 8minInner Queries/SubQueries
Instructor
![Manish Narayan](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 2,970 Reviews
- 21,297 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