Get Started with T-SQL

Focused View

Robert Angi-lazar

3:19:15

39 View

1. Introduction Get Started with T-SQL

1. Welcome to the course!.mp4

01:11

2. About the author.mp4

01:46

3. More about the Course Content.mp4

02:34

4. Database, SQL, T-SQL - What does it all mean.mp4

07:27

2. Set up the environment

1. Download SQL Server.mp4

05:21

2. Downland SQL Server Management Studio.mp4

02:52

3. Import the AdventureWorks database.mp4

03:05

4. Quick Tips & Tricks.mp4

03:24

3. T-SQL Fundamentals

1. Write Your First SELECT Statement.mp4

10:45

2. Filtering Data with WHERE, OR and AND.mp4

05:24

3. Understanding LIKE.mp4

08:46

4. IN and NOT IN.mp4

09:47

5. Custom Columns & Aliases.mp4

07:20

6. Understanding NULL.mp4

10:55

7. Practise test T-SQL Fundamentals.html

4. Working with Data types and Functions

1. Numeric Values.mp4

11:57

2. Working with Strings.mp4

07:42

3. CHARINDEX.mp4

01:53

4. REPLACE.mp4

01:29

5. REPLICATE.mp4

01:08

6. UPPER and LOWER.mp4

02:14

7. SUBSTRING.mp4

08:18

8. Date Data Types.mp4

05:08

9. DATEPART, DATENAME.mp4

02:07

10. DATEADD.mp4

02:17

11. DATEDIFF.mp4

02:38

5. Aggregating Data

1. Understanding ORDER BY.mp4

03:34

2. Understanding GROUP BY.mp4

06:37

3. Summarize Data with SUM.mp4

05:19

4. Count Rows with COUNT.mp4

06:03

5. Understanding MIN and MAX.mp4

04:57

6. Calculating Averages with AVG.mp4

05:50

7. More Aggregate Functions.mp4

02:10

6. Introducing JOINS

1. Introducing JOINS.mp4

03:09

2. Working with INNER JOIN.mp4

11:52

3. Understand LEFT JOIN.mp4

07:06

4. Understand RIGHT JOIN.mp4

01:50

5. Understand FULL OUTER JOIN.mp4

04:57

6. Understand SELF JOIN.mp4

05:36

7. Next Steps

1. Congratulations!.mp4

02:47

Description

Master the fundamentals of Transact-SQL and learn how to filter and analyze data in databases

What You'll Learn?

Learn the fundamentals of SQL and T-SQL queries
Understand the different types of joins and perform more complex queries
Learn to work with the different data types available in T-SQL
How to filter queries and analyze query results

Who is this for?

Beginner SQL/database developers, data analytics and business intelligence consultants

What You Need to Know?

No previous SQL skills are required. All the necessary fundamentals with be teached

More details

Description
The "Get Started with T-SQL" course is designed to provide a comprehensive introduction to the fundamentals of T-SQL, an essential language for interacting with relational databases. Whether you're a database beginner or looking to enhance your SQL skills, this course offers a structured and hands-on approach to mastering T-SQL. By the end of this course, you will have a solid foundation in querying databases using T-SQL:

Understanding Databases:
Introduction to databases and their importance in modern data management.
Differentiating between SQL and T-SQL, with a focus on T-SQL's unique features and capabilities.
Setting up the Environment:
How to install SQL Server and SQL Server Management Studio (SSMS).
Practical steps to import a sample database for hands-on learning.
Writing T-SQL Queries:
Learning the syntax and structure of T-SQL queries.
Retrieve data from databases.
Data Filtering:
Understanding the WHERE and LIKE operators to filter and refine data retrieval.
Real-world scenarios and examples to apply these operators effectively.
Dealing with Null Values:
Comprehensive coverage of the concept of "null" in databases.
How to handle and work with null values in T-SQL queries.
Grouping and Aggregating Data:
Introduction to common aggregate functions (e.g., SUM, COUNT, AVG) and their applications.
Hands-on practice in grouping and summarizing data to gain insights.
Mastering Joins:
In-depth exploration of SQL joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN and SELFÂ JOIN).
A breakdown of when and how to use each type of join, with practical examples.
This course is suitable for beginners and intermediate learners interested in working with databases, particularly those who need to use T-SQL for data manipulation and retrieval. Whether you're a data analyst, developer, or aspiring database administrator, this course will provide you with essential skills to excel in your career.
No prior database or SQL knowledge is required. Participants should have a basic understanding of computer usage and be ready to engage in hands-on exercises throughout the course.
Upon completion of the "Get Started with T-SQL" course, participants will:
Have a solid understanding of databases and the T-SQL language.
Be able to install and configure SQL Server and SQL Server Management Studio.
Write T-SQL queries for data retrieval and manipulation.
Filter data effectively using WHERE and LIKE operators.
Handle null values in T-SQL queries.
Perform data grouping and aggregation with confidence.
Master SQL joins and their various applications.
This course is delivered through a combination of interactive lectures, practical exercises, and real-world examples. Participants will have access to support throughout the course.
Get started on your journey to becoming a proficient T-SQL practitioner. Enroll in the "Get Started with T-SQL" course today and unlock the power of structured data manipulation and database management.
Who this course is for:
Beginner SQL/database developers, data analytics and business intelligence consultants

User Reviews

Rating

average 0

Total votes0

Focused display

My name is Robert Angi-Lazar and i have documented experience as a Business Intelligence Lead/Developer, RPA Developer/Consultant and Data Engineer. I'm a fullstack developer with a strong passion for the back-end programming where SQL Server and ETL development are my strenghts. I've also been part of large Power BI and Tableau implementations for customers in various fields!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.