Microsoft SQL for Beginners
What you’ll learn
Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Learn about database design and normalization
Using joins, return columns from multiple tables in the same query
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Group data together using the GROUP BY clause
Filter groups of data using the HAVING clause
Requirements
I assume you have absolutely NO SQL or database background before taking this course.
You will need to have a Windows-based computer to run Microsoft SQL Server.
Description
Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!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. 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.You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.
Overview
Section 1: Introduction to SELECT Statements
Lecture 1 START HERE: Introduction Lecture
Lecture 2 How to Install Microsoft SQL Server Express
Lecture 3 How to Download and Install SQL Server Express
Lecture 4 How to Attach the AdventureWorks Database
Lecture 5 Introduction to T-SQL and Database Concepts
Lecture 6 Literal SELECT Statements – Part 1
Lecture 7 Literal SELECT Statements – Part 2
Lecture 8 Literal SELECT Statement Practice Problems
Lecture 9 Basic SELECT Statements – Part 1
Lecture 10 Basic SELECT Statements – Part 2
Lecture 11 Basic SELECT Statements – Part 3
Lecture 12 Basic SELECT Statement Practice Problems
Section 2: Filtering Data with the WHERE Clause
Lecture 13 Using the WHERE Clause – Part 1
Lecture 14 Using the WHERE Clause – Part 2
Lecture 15 Using the WHERE Clause – Part 3
Lecture 16 Using the WHERE Clause – Part 4
Lecture 17 Using the WHERE Clause – Part 5
Lecture 18 Using the WHERE Clause – Part 6
Lecture 19 Using the WHERE Clause – Part 7
Lecture 20 WHERE Clause Practice Problems
Section 3: Sorting Data with the ORDER BY Clause
Lecture 21 Sorting with the ORDER BY Clause – Part 1
Lecture 22 Sorting with the ORDER BY Clause – Part 2
Lecture 23 ORDER BY Clause Practice Problems
Section 4: Querying Multiple Tables with Joins
Lecture 24 Using the INNER JOIN – Part 1
Lecture 25 Using the INNER JOIN – Part 2
Lecture 26 INNER JOIN Practice Problems
Lecture 27 Using the LEFT OUTER JOIN – Part 1
Lecture 28 Using the LEFT OUTER JOIN – Part 2
Lecture 29 Using the LEFT OUTER JOIN – Part 3
Lecture 30 LEFT/RIGHT OUTER JOIN Practice Problems
Section 5: Aggregate Functions
Lecture 31 Aggregate Functions – Part 1
Lecture 32 Aggregate Functions – Part 2
Lecture 33 Aggregate Function Practice Problems
Section 6: Grouping Data with the GROUP BY Clause
Lecture 34 Grouping with the GROUP BY Clause – Part 1
Lecture 35 Grouping with the GROUP BY Clause – Part 2
Lecture 36 GROUP BY Clause Practice Problems
Section 7: Filtering Groups with the HAVING Clause
Lecture 37 Filtering Groups with the HAVING Clause – Part 1
Lecture 38 Filtering Groups with the HAVING Clause – Part 2
Lecture 39 HAVING Clause Practice Problems
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. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.,If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information,Someone who wants to learn skills that give them the potential to earn near SIX figures!
Course Information:
Udemy | English | 3h 59m | 1.42 GB
Created by: Brewster Knowlton
You Can See More Courses in the Developer >> Greetings from CourseDown.com