Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 46 Minute(s)
Language
English
Taught by
Bluelime Learning Solutions
Rating
Course Overview
Learn Hands-On how to build Real World SQL Queries to answer questions with data.
SQL Server is a relational database management system -RDBMS developed and owned by Microsoft.
Thousands of companies all over the world use SQL Server for their data solution .
SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.
T-SQL - Transact SQL is Microsoft's implementation of SQL. There are a lot of similarities between them but also proprietary parts that are specific to SQL Server.
SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.
This course is a beginners guide to performing data analysis using SQL to interrogate SQL Server to provide answers to data related questions. You will learn to write useful SQL queries that is applicable to the Real World production environment.
Everywhere data is being collected, every transaction, every web page visit,every payment—all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information.
There is a demand for people who can use data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.
Skills You will learn include:
• How to design and write simple SQL queries for data analysis.
• How to merge data from multiple tables
• How to use aggregate functions
• How to use wild cards with SQL queries
• How to group related data
• How to Filter Data search with SQL WHERE clause
• How to Use Alias
• How to retrieve all the data from a table
In this course we will use SQL to provide answers to questions like:
How many customers or employees doe a company has?
How many sales reps does a company have?
When was the first order placed?
This course is packed with real world examples that will help you build your SQL Skills .
.
Course Content
- 3 section(s)
- 40 lecture(s)
- Section 1 Installing SQL Server and Sample Database
- Section 2 Data Analysis Using SQL Examples For The Real World
- Section 3 Practice Exercises
What You’ll Learn
- Analyse various types of data Using SQL, Analyse Data from multiple Database Tables, Sort Data for analysis, Restrict Data , Build query with Group By Clause, Build Query with Like operator and wild cards, Build query with aggregate function, Create a data model, Filter data using WHERE Clause, Build query with various types of operators
Skills covered in this course
Reviews
-
TTom Swift
The course really could have used a bit of structure in how the lectures were presented. Each one was less a unified whole than individual independent lectures. I was hoping for more organization and increasing sophistication of the learning as the course progressed.
-
SSuyash Singh Fartyal
Very Nice pace and detailed for corporate work
-
VV D
Thank you! It was easy to follow. Clear direction step by step very organized.
-
PPrakhar Rajendra Tiwari
ON point according to basics but the info is too basic as i am on lecture 14 and still writing the query for order by which was taught in like first 2-3 lectures
