Fortgeschrittenes SQL für Datenwissenschaftler
Learn SQL for data science on SQL Server 2019! This 11-hour course equips you with essential skills.
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
LIKEoperator. - Data Filtering & Selection: Understand the power of
TOPfor limiting results, and how to remove duplicates usingDISTINCT. Utilize comparison operators like=,!=, and more. - Data Copying & Manipulation: Efficiently copy tables using
SELECT INTO. Learn to useIN,NOT IN,IS, andIS NOTfor complex filtering. Master data sorting withORDER BY. - Aggregate Functions: Discover the capabilities of aggregate functions like
MIN,MAX,AVG,COUNT, andSUM. Combine these withANDandORoperators for powerful data analysis. - Data Grouping: Group data effectively using the
GROUP BYoperator. - Advanced Joins: A significant portion of the course (1 hour 30 minutes) is dedicated to mastering JOINs, including
INNER JOIN,LEFT JOIN,RIGHT JOIN, andFULL OUTER JOIN. - Set Operations: Explore
UNIONandUNION ALLfor combining result sets, as well as theLEFTandRIGHTfunctions. - String Manipulation: Learn to use functions like
CHOOSE,TRIM,LTRIM, andRTRIMfor manipulating strings. - Conditional Logic: Dive into advanced conditional statements with
IIF,CASE WHEN, andOFFSET FETCH NEXT ROWS. - Data Type Conversion: Understand and utilize
CAST,CONVERT,TRY_CAST, andTRY_CONVERTfor data type conversions. - Date & Time Functions: Work with dates and times using functions like
DATEADD,DATEDIFF,GETDATE(), andEOMONTH. - Advanced T-SQL Techniques: Deepen your skills with
IF/ELSE,STRING SPLIT,STUFF, andMERGEstatements. - 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, andLEAD. - 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!
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.