Who this course is for:
- Anyone looking to start or change a career
- Anyone who wants to learn skills that will earn them six figures!
- Anyone who works with data, tables, or databases!
- Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language.
- Anyone who works in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
- Lastly anyone that looking for a better future for themselves and their family
What you’ll learn
-
Create tables in a database and ALTER columns in the table.
-
Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
-
Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
-
JOIN two or more tables together, finding missing data.
-
INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
-
Create constraints, views and triggers
-
Use UNION, CASE, MERGE, procedures and error checking
-
Apply ranking and analytic functions, grouping, geography and geometry database
-
Create sub-queries and CTEs, PIVOTs, UDFs, APPLYs, synonyms.
-
Create reports and Subscriptions
-
Extract , Transform, and Load data from different sources
Requirements
-
You need to know how to use a computer, and hopefully know how to use a spreadsheet.
-
No prior knowledge of SQL Server required.
-
The course software cannot be installed on a Mac computer. A windows PC or laptop is required with windows 10 OS or later.
-
Why not have a look at the curriculum on the next tab and see what you can learn?
Description
SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language and in-depth reporting skills.
This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.
It will teach you how to create reports using T-SQL, SQL Server Reporting Services (SSRS) including dashboards with interactive visualizations objects.
It will teach you how to integrate data from different sources, combine them into one location, clean them and organize them accordingly using Microsoft Visual Studio (SSIS).
It will teach you how to read and interpret technical requirements and be able to deliver effective solutions.
It will teach you about most of the tools that are currently being used by companies.
You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems and links to reading or video materials to help reinforce what you learn in the video tutorials.
Course Features
- Lectures 17
- Quizzes 7
- Duration 52 weeks
- Skill level All levels
- Language English
- Students 5
- Assessments Self
