Udemybeginnerde

Fortgeschrittenes SQL für Datenwissenschaftler

Learn SQL for data science on SQL Server 2019! This 11-hour course equips you with essential skills.

4.4(4)
52students
9h 31m
Certificate
ELOA FORMATION begleiten Sie uns ! | SQL | Postgres |Python Powershell| MySQL | Verwaltung, TSQL- und SQL Server-Leistung.
ELOA FORMATION begleiten Sie uns ! | SQL | Postgres |Python Powershell| MySQL | Verwaltung, TSQL- und SQL Server-Leistung.Nehmen Sie am Masterclass SQL Server-Kurs teil!

Course Content

Fortgeschrittenes SQL für Datenwissenschaftler is a beginner-level Udemy course taught by ELOA FORMATION begleiten Sie uns ! | SQL | Postgres |Python Powershell| MySQL | Verwaltung, TSQL- und SQL Server-Leistung.. It runs 9h 31m, is taught in German, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 4 reviews, with 52 students enrolled. It is a paid course, last updated August 2021.

This course, presented in English with German subtitles, is your comprehensive guide to mastering Transact SQL (T-SQL) and preparing for the valuable Microsoft SQL Server certifications 70-461 and 70-761. Whether you're working with SQL Server 2012, 2014, 2016, 2017, or 2019, this course provides in-depth knowledge to elevate your skills.

What You'll Learn:

  • Database & Table Management: Learn to create and define databases and tables, the foundation of any SQL application.
  • Essential Data Manipulation (CRUD): Master SELECT, UPDATE, INSERT, and DELETE statements to effectively interact with your data. Explore column aliases and the nuances of the LIKE operator.
  • Data Filtering & Selection: Understand the power of TOP for limiting results, and how to remove duplicates using DISTINCT. Utilize comparison operators like =, !=, and more.
  • Data Copying & Manipulation: Efficiently copy tables using SELECT INTO. Learn to use IN, NOT IN, IS, and IS NOT for complex filtering. Master data sorting with ORDER BY.
  • Aggregate Functions: Discover the capabilities of aggregate functions like MIN, MAX, AVG, COUNT, and SUM. Combine these with AND and OR operators for powerful data analysis.
  • Data Grouping: Group data effectively using the GROUP BY operator.
  • Advanced Joins: A significant portion of the course (1 hour 30 minutes) is dedicated to mastering JOINs, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
  • Set Operations: Explore UNION and UNION ALL for combining result sets, as well as the LEFT and RIGHT functions.
  • String Manipulation: Learn to use functions like CHOOSE, TRIM, LTRIM, and RTRIM for manipulating strings.
  • Conditional Logic: Dive into advanced conditional statements with IIF, CASE WHEN, and OFFSET FETCH NEXT ROWS.
  • Data Type Conversion: Understand and utilize CAST, CONVERT, TRY_CAST, and TRY_CONVERT for data type conversions.
  • Date & Time Functions: Work with dates and times using functions like DATEADD, DATEDIFF, GETDATE(), and EOMONTH.
  • Advanced T-SQL Techniques: Deepen your skills with IF/ELSE, STRING SPLIT, STUFF, and MERGE statements.
  • Database Objects: Learn to create and define Views, Stored Procedures, Functions, Schemas, and Triggers.
  • RANKING Functions: A comprehensive section on RANKING functions including ROW_NUMBER, OVER, PARTITION BY, ROWS/RANGE UNBOUNDED PRECEDING, FIRST/LAST VALUES, LAG, and LEAD.
  • Common Table Expressions (CTEs) & Derived Tables: Unlock the power of CTEs and understand their role in simplifying complex queries.
  • Temporary, Variable, and Global Tables: Understand the differences between these table types.
  • SARGable Queries: Get an introduction to the concept of SARGable queries for optimizing performance.

Course Details:

  • SQL Server Version Coverage: This course covers all SQL Server versions, including the latest SQL Server 2019.
  • Format: 8 hours 30 minutes of demonstration videos with 30 minutes of theory (theory is provided in the classroom, not within the video).
  • Video Length: Videos are kept concise, generally under 10 minutes, to maintain engagement.
  • Career Advancement: This course will help you stand out from your peers and excel in job interviews.
  • Certification Preparation: This course is designed to help you pass your Microsoft SQL Server certifications.
  • Depth of Knowledge: This course offers a truly in-depth understanding of T-SQL – you won't find a more comprehensive course available!
$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

4.7(274)
5h 18m
all
4.6(4,487)
2h 22m
all
4.5(710)
3h 46m
intermediate
4.5(3,668)
23h 21m
all