Learning Path

Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.

Data

SQL Server Fundamentals

8 Courses

13 Hours

Skill IQ

SQL Server Fundamentals covers Querying Data, Advanced Querying Techniques, Working with Hierarchies, Understanding Query Optimization, SQL Server Security and Securing SQL Server Applications.

Get started

Content in this path

SQL Server Fundamentals

SQL Server Fundamentals covers Querying Data, Advanced Querying Techniques, Working with Hierarchies, Understanding Query Optimization, SQL Server Security and Securing SQL Server Applications.

Course

Querying Data with SQL Server

by Mihaela Danci
1h 56m
Oct 12, 2023

Course

Working with Hierarchies in SQL Server

by Pinal Dave
49m
Aug 24, 2023

Course

Understanding Query Optimization in SQL Server

by Nikola Ilic
1h 24m
Dec 07, 2023

Course

Advanced Querying Techniques in SQL Server

by Gerald Britton
1h 13m
Oct 09, 2023

Course

SQL Server Security Fundamentals

by Pinal Dave
1h 29m
Jul 19, 2023

Course

Securing SQL Server Applications

by Rudi Bruchez
2h 6m
Nov 16, 2023

Course

Optimizing Query Performance with Columnstore Indexes

by Jared Westover
2h 33m
Aug 24, 2023

Access this learning path and other top-rated tech content with a free trial.

Free individual trial Free team trial

Have questions? Get them answered now.

Start a live chat

Not sure where to start?

With over 500 assessments to choose from, you can see where your skills stand and receive adaptive learning recommendations to fill knowledge gaps in as little as 10 minutes.

Learn more

Learn with the best

Ben Weissman

Ben Weissman, a Microsoft Data Platform MVP, has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. Besides his Pluralsight courses, Ben is also the co-author of multiple books on data and kubernetes including "SQL Server on Kubernetes ", "Azure Arc-enabled Data Services", "SQL Server Big Data Clusters" and "The Biml Book". He is also a regular speaker at international events. Ben and his team at Solisyon have been involved in more than 200 Business I...

Mihaela Danci

As a data analyst enthusiast, Mihaela has special interests in translating vision into action using end-to-end data analysis. She is very passionate about teaching and resolving real-world business problems. Her greatest joy is learning new data exploration techniques and pushing the boundaries of data analytics. Mihaela has a bachelor’s degree in economic cybernetics and in her spare time she loves to travel and dance.

Pinal Dave

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books, 91 Pluralsight courses and 11 Code Labs. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Nikola Ilic

Nikola Ilic is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI - but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed "Data-Mozart". As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer's last name as part of his nickname. That'...

Gerald Britton

Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. A multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater).

Rudi Bruchez

Rudi Bruchez is a freelance consultant and trainer based in Paris, France. He has more than 15 years of experience with SQL Server and started to venture into NoSQL territories. He worked first as a developer and started as a DBA in 2001, in Switzerland at MSC (Mediterranean Shipping Company). He moved to France in 2005 and is working freelance since 2006. He provides consulting, administration, audits and training. As SQL Server evolves into a more complex solution, he tries to make sure that d...

Jared Westover

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv...

SQL Server Fundamentals