The Complete SQL Course 2024 – Learn by Doing – SQL Server
The Complete SQL Course 2024 – Learn by Doing – SQL Server, available at $99.99, has an average rating of 4.63, with 114 lectures, 1 quizzes, based on 2587 reviews, and has 9006 subscribers.
You will learn about How to write accurate SQL queries against a database Use SQL to perform data analysis Learn to perform GROUP BY Statements Learn how to join multiple tables – including complex joins Learn how to use window functions, correlated subqueries, set operators, CTEs and much more Best practices in SQL Replicate real-world situations and query reports How to create tables, views and stored procedures How to make your queries run faster by making them sargable Be comfortable putting SQL and SQL Server on your resume This course is ideal for individuals who are Anyone interested in learning SQL or data analysis! or Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. or If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data or Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career It is particularly useful for Anyone interested in learning SQL or data analysis! or Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. or If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data or Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career.
Enroll now: The Complete SQL Course 2024 – Learn by Doing – SQL Server
Summary
Title: The Complete SQL Course 2024 – Learn by Doing – SQL Server
Price: $99.99
Average Rating: 4.63
Number of Lectures: 114
Number of Quizzes: 1
Number of Published Lectures: 114
Number of Published Quizzes: 1
Number of Curriculum Items: 115
Number of Published Curriculum Objects: 115
Original Price: $109.99
Quality Status: approved
Status: Live
What You Will Learn
- How to write accurate SQL queries against a database
- Use SQL to perform data analysis
- Learn to perform GROUP BY Statements
- Learn how to join multiple tables – including complex joins
- Learn how to use window functions, correlated subqueries, set operators, CTEs and much more
- Best practices in SQL
- Replicate real-world situations and query reports
- How to create tables, views and stored procedures
- How to make your queries run faster by making them sargable
- Be comfortable putting SQL and SQL Server on your resume
Who Should Attend
- Anyone interested in learning SQL or data analysis!
- Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language.
- If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data
- Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career
Target Audiences
- Anyone interested in learning SQL or data analysis!
- Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language.
- If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data
- Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career
Learn how to write effective and accurate SQL with this course!
You will learn how to read and write complex SQL queries in a relational database (SQL Server). The skills you will learn are also largely applicable to any other major database system, such as MySQL, PostgreSQL, Oracle Database, and much more.
Knowing how to write SQL is one of the fastest ways to reach your career goals. This is because SQL is consistently the most in-demand skills in the tech sector. SQL can seem simple at first but it can quickly become complicated. It is common for people to a write SQL query without realizing they are getting an incorrect result returned. This course is designed with a focus on accuracy and understanding. You will learn how to avoid the common mistakes people make when writing SQL. Not only that.. but you will get a visual guide to the SQL language by seeing how queries work step-by-step. This is a complete course which covers all the core skills you need to master the SQL language.
I believe that the best way to learn SQL is by writing lots of SQL. For that reason, this course includes over 80 coding challenges where you get to write SQL queries and create database objects. These challenges are based on real-world scenarios and are designed for optimal understanding.
In this course you will learn everything you need to master SQL! Including:
-
Get started with SQL Server and SSMS, two of the world’s most popular SQL tools
-
How to install SQL Server on Windows and Mac-OS computers
-
Note: that Mac users will need to use Azure Data Studio rather than SSMS
-
-
Learn how to do data analysis and data analytics using SQL. Including advanced query techniques
-
Start by learning the fundamentals of the relational model and SQL language
-
Analyzing data using aggregate functions with the GROUP BY command
-
Writing advanced queries with string and date functions
-
Learn to use logical operators to add logic flow to your SQL queries
-
Learn how to write both self-contained and correlated sub queries
-
Learn how to join data by using the different types of JOIN commands
-
Learn how to do more advanced joins such as joining more than two tables and joining on multiple columns
-
Learn to create tables and integrity constraints
-
How to update, insert and delete data
-
How to create indexes
-
How to make your queries run faster by making them SARGable
-
Learn to write advanced SQL such as stored procedures, window functions, and common table expressions
-
Bonus section on Database Design – includes data normalization up to and including Boyce-Codd Normal Form.
-
and much, much more!
This course is one that puts you in control. Where you get to write SQL throughout the course, instead of watching someone else code. Every section comes with fresh challenges, modeled after real-world tasks and situations.
This comprehensive course allows you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself writing advanced SQL queries.
Course Curriculum
Chapter 1: SQL Statement Fundamentals and Software Setup
Lecture 1: Introduction
Lecture 2: Understanding the Foundations of SQL
Lecture 3: SELECT Statement
Lecture 4: Overview of SQL Server
Lecture 5: Windows – How to Setup SQL Server and SSMS on a Windows Computer
Lecture 6: Windows – How to Setup the SAMPLEDB Database on Windows Computer
Lecture 7: MacOS – How to set up SQL Server Database on a Mac Computer using Docker
Lecture 8: Overview of the Course Challenges
Lecture 9: SELECT Challenges
Lecture 10: Solutions to the SELECT Challenges
Lecture 11: SELECT DISTINCT Statement
Lecture 12: SELECT DISTINCT Challenges
Lecture 13: Solutions to the SELECT DISTINCT Challenges
Lecture 14: Row Ordering – ORDER BY
Lecture 15: Filtering Data with TOP
Lecture 16: ORDER BY Challenges
Lecture 17: Solutions to the ORDER BY Challenges
Lecture 18: WHERE Clause – Three-valued Logic
Lecture 19: Replacing Nulls in Queries
Lecture 20: WHERE Clause – Comparison Operators
Lecture 21: WHERE Clause Challenges
Lecture 22: Solutions to the WHERE Clause Challenges
Lecture 23: Introduction to Collations and Pattern Matching
Lecture 24: Pattern Matching – Part 2
Lecture 25: Introduction to Character Data Types
Lecture 26: Pattern Matching Challenges
Lecture 27: Solutions to the Pattern Matching Challenges
Lecture 28: Introduction to Aggregate Functions
Lecture 29: GROUP BY and Aggregate Functions
Lecture 30: HAVING Clause
Lecture 31: Logical Query Processing Order
Lecture 32: GROUP BY Challenges
Lecture 33: Solutions to the GROUP BY Challenges
Lecture 34: AND operator
Lecture 35: OR operator
Lecture 36: Operator Precedence
Lecture 37: IN Operator
Lecture 38: Logical Operator Challenges
Lecture 39: Solutions to the Logical Operator Challenges
Chapter 2: Joins and Integrity Constraints
Lecture 1: Inner Joins
Lecture 2: Outer Joins – LEFT OUTER JOIN and RIGHT OUTER JOIN
Lecture 3: FULL OUTER JOIN
Lecture 4: Integrity Constraints
Lecture 5: Many-to-many Relationships
Lecture 6: Join Challenges
Lecture 7: Solutions to the Join Challenges
Lecture 8: Composite Joins – Joining on multiple columns
Lecture 9: Joining more than two tables
Lecture 10: Predicate placement – ON clause vs WHERE clause
Lecture 11: Self-referencing Joins
Lecture 12: Cross Joins
Lecture 13: Advanced Join Challenges
Lecture 14: Solutions to the Advanced Join Challenges
Chapter 3: Set Operators
Lecture 1: UNION and UNION ALL
Lecture 2: INTERSECT
Lecture 3: EXCEPT
Lecture 4: Set Operator Precedence
Lecture 5: SET Operator Challenges
Lecture 6: Solutions to the Set Operator Challenges
Chapter 4: Subqueries
Lecture 1: Self-contained Subqueries
Lecture 2: Correlated Subqueries
Lecture 3: EXISTS
Lecture 4: Introduction to Window Functions
Lecture 5: Common Table Expressions
Lecture 6: Avoiding the NOT IN trap
Lecture 7: Subquery Challenges
Lecture 8: Solutions to the Subquery Challenges
Chapter 5: Scalar Functions
Lecture 1: Concatenation in SQL Server
Lecture 2: String Manipulation Functions
Lecture 3: Date and Time Functions
Lecture 4: Function Challenges
Lecture 5: Solutions to the Function Challenges
Lecture 6: CASE Expression
Lecture 7: CASE Expression Challenges
Lecture 8: Solutions to the CASE Expression Challenges
Chapter 6: Data Definition Language (DDL) and Data Manipulation Language (DML)
Lecture 1: Overview of Data Types
Lecture 2: Integer Data Types
Lecture 3: DECIMAL Data Type
Lecture 4: FLOAT Data Type
Lecture 5: CREATE TABLE Statement
Lecture 6: INSERT Statement
Lecture 7: CREATE TABLE Challenges
Lecture 8: Solutions to the CREATE TABLE Challenges
Lecture 9: UNIQUEIDENTIFIER (GUID) Data Type
Lecture 10: UPDATE Statement
Lecture 11: DELETE Statement
Lecture 12: TRUNCATE TABLE statement
Lecture 13: DROP TABLE Statement
Lecture 14: Transactions
Lecture 15: Stored Procedures
Lecture 16: Stored Procedures Demo
Lecture 17: Stored Procedure Challenges
Lecture 18: Solutions to the Stored Procedure Challenges
Lecture 19: ALTER TABLE Statement and sp_rename
Instructors
-
Daniel Tait
Database Instructor
Rating Distribution
- 1 stars: 10 votes
- 2 stars: 19 votes
- 3 stars: 177 votes
- 4 stars: 865 votes
- 5 stars: 1523 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024