Microsoft SQL from A to Z
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
Use built-in SQL Server functions
Understand SQL Server Data Types and Type Casting
Work with Table Expressions: Derived Tables and CTEs
Use CASE Statements
Use Subqueries
Requirements
I assume that you have NO SQL or database background before taking this course.
You need to have a Windows computer or the ability to run a Windows Operating System on your computer.
Description
This course is an extension of our previous course, “Microsoft SQL for Beginners”. This course, “Microsoft SQL from A to Z” contains all the course material and content from the previous course plus the additional MANY new lectures on more intermediate and advanced-level SQL querying topics. Students who sign up for this course will also have access to our 150+ page “Complete T-SQL Querying Guide” as an added bonus to assist you in the learning process.
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 ALSO START HERE: T-SQL Training Guide
Lecture 3 Installing SQL Server Written Instructions
Lecture 4 How to Install Microsoft SQL Server Express
Lecture 5 How to Attach the AdventureWorks Sample Database
Lecture 6 Introduction to T-SQL and Database Concepts
Lecture 7 Literal SELECT Statements – Part 1
Lecture 8 Literal SELECT Statements – Part 2
Lecture 9 Literal SELECT Statement Practice Problems
Lecture 10 Basic SELECT Statements – Part 1
Lecture 11 Basic SELECT Statements – Part 2
Lecture 12 Basic SELECT Statements – Part 3
Lecture 13 Basic SELECT Statement Practice Problems
Section 2: Filtering Data with the WHERE Clause
Lecture 14 Using the WHERE Clause – Part 1
Lecture 15 Using the WHERE Clause – Part 2
Lecture 16 Using the WHERE Clause – Part 3
Lecture 17 Using the WHERE Clause – Part 4
Lecture 18 Using the WHERE Clause – Part 5
Lecture 19 Using the WHERE Clause – Part 6
Lecture 20 Using the WHERE Clause – Part 7
Lecture 21 WHERE Clause Practice Problems
Section 3: Sorting Data with the ORDER BY Clause
Lecture 22 Sorting with the ORDER BY Clause – Part 1
Lecture 23 Sorting with the ORDER BY Clause – Part 2
Lecture 24 ORDER BY Clause Practice Problems
Section 4: Querying Multiple Tables with Joins
Lecture 25 Using the INNER JOIN – Part 1
Lecture 26 Using the INNER JOIN – Part 2
Lecture 27 INNER JOIN Practice Problems
Lecture 28 Using the LEFT OUTER JOIN – Part 1
Lecture 29 Using the LEFT OUTER JOIN – Part 2
Lecture 30 Using the LEFT OUTER JOIN – Part 3
Lecture 31 LEFT/RIGHT OUTER JOIN Practice Problems
Section 5: Aggregate Functions
Lecture 32 Aggregate Functions – Part 1
Lecture 33 Aggregate Functions – Part 2
Lecture 34 Aggregate Function Practice Problems
Section 6: Grouping Data with the GROUP BY Clause
Lecture 35 Grouping with the GROUP BY Clause – Part 1
Lecture 36 Grouping with the GROUP BY Clause – Part 2
Lecture 37 GROUP BY Clause Practice Problems
Section 7: Filtering Groups with the HAVING Clause
Lecture 38 Filtering Groups with the HAVING Clause – Part 1
Lecture 39 Filtering Groups with the HAVING Clause – Part 2
Lecture 40 HAVING Clause Practice Problems
Section 8: Using SQL Server Functions
Lecture 41 Using SQL Server Functions – Part 1
Lecture 42 Using SQL Server Functions – Part 2
Lecture 43 Using SQL Server Functions – Part 3
Lecture 44 Using SQL Server Functions – Part 4
Lecture 45 Using SQL Server Functions – Part 5
Lecture 46 Using SQL Server Functions – Part 6
Lecture 47 Using SQL Server Functions – Part 7
Lecture 48 Using SQL Server Functions – Part 8
Lecture 49 Nesting Functions – Part 1
Lecture 50 Nesting Functions – Part 2
Lecture 51 SQL String and Nesting Function Practice Problems
Lecture 52 Using Date Functions – Part 1
Lecture 53 Using Date Functions – Part 2
Lecture 54 Using Date Functions – Part 3
Lecture 55 Date Function Practice Problems
Lecture 56 NULL Handling Functions – Part 1
Lecture 57 NULL Handling Functions – Part 2
Lecture 58 NULL Handling Function Practice Problems
Section 9: SQL Server Data Types and Type Casting
Lecture 59 The Basics of SQL Server Data Types and Type Casting Functions
Lecture 60 SQL Server Type Casting and Data Types Practice Problems
Section 10: Working with Table Expressions
Lecture 61 Using Derived Tables – Part 1
Lecture 62 Using Derived Tables – Part 2
Lecture 63 Using Derived Tables – Part 3
Lecture 64 Using Derived Tables – Part 4
Lecture 65 Using Derived Tables – Part 5
Lecture 66 Derived Table Practice Problems
Lecture 67 Working with CTEs – Part 1
Lecture 68 Working with CTEs – Part 2
Lecture 69 Working with CTEs – Part 3
Lecture 70 Working with CTEs – Part 4
Lecture 71 Common Table Expression (CTE) Practice Problems
Section 11: CASE Statements
Lecture 72 Using CASE Statements – Part 1
Lecture 73 Using CASE Statements – Part 2
Lecture 74 Using CASE Statements – Part 3
Lecture 75 Using CASE Statements – Part 4
Lecture 76 Using CASE Statements – Part 5
Lecture 77 Using CASE Statements – Part 6
Lecture 78 CASE Statement Practice Problems
Section 12: Creating Tables and Inserting/Updating Data
Lecture 79 Creating a Table
Lecture 80 Insert Data into a Table
Lecture 81 Updating Data in a Table
Anyone who works with data, tables, or databases!,Someone who wants to learn the foundational skill of big data and data analytics.,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 | 5h 43m | 2.16 GB
Created by: Brewster Knowlton
You Can See More Courses in the Developer >> Greetings from CourseDown.com