cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Basic

Track

SQL from A to Z in MS SQL Server

Become a SQL master – even if you’ve never coded before. Learn all the necessary tools to freely and efficiently work with any type of data. Start from the basics, then discover advanced SQL functions and features.

Start learning

89 free interactive coding challenges

Ultimate money saver

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

With our Forever plan this track will cost you only

$ 21.98

87% OFF

190 hours left

SEE PRICING
7

Interactive courses

83 h

Estimated time

1927

Users enrolled

☆☆☆☆☆
★★★★★

5 ratings

This learning path is for people who have no experience in IT and want to start their adventure with SQL. You’ll learn the basic and advanced features of this language. When you’ve completed this track, you’ll be able to efficiently work with databases and analyze data. Scroll down for details.

Don't have any IT experience and want to learn SQL? This learning path is for you! Data is everywhere. It’s the basis for almost every kind of business – banks, online services, taxi companies, stores, you name it. If you want to have an advantage over the competition, you need to know how to use data. To use data, you need SQL.

Maybe you dream of working as a database administrator or data analyst. Master SQL with the SQL from A to Z learning path. Don't waste time looking for other courses; this path has everything you need in one place. It will guide you through the entire learning process, from the very basics to the advanced features of modern SQL.

What's in it for me?

  • Smooth entry into the world of coding. No prior experience, extra software, or practice data sets needed.
  • Well-defined learning path with 7 fully interactive courses. This comprehensive SQL track contains everything you need to learn SQL in one place. The courses are arranged in logical order, and the teaching process was carefully designed for beginners to gain confidence and experience.
  • Proven learning efficiency. Don’t just learn concepts: get hands-on practice with our real code editor, real data sets, and real-life exercises.
  • Online certification. After successfully completing each course, you will receive a certificate that you can publish on your LinkedIn profile.
  • Trusted support system. Every course comes with access to our resource base, student2student support, mentor2student support, and technical support. You can also join our learning community and participate in on-task discussions.
  • Hints and more. If you get stuck, you can use the included exercise hints. Or use the Discuss tab to ask questions and share insights with other members of the LearnSQL community. You can also drop us a line at contact@learnsql.com and we'll be more than happy to help!

Objectives:

  • Create simple queries.
  • Combine data from multiple tables using SQL JOINs.
  • Write complex SQL queries using aggregation, subqueries, and set operations.
  • Add, modify, and delete data from a database using SQL.
  • Know when and how to use common standard functions.
  • Prepare complex reports with the GROUP BY and CASE WHEN clauses.
  • Understand and apply window functions, which make writing complex queries easier.
  • Understand and use Common Table Expressions, which help organize long SQL queries in a readable way.
  • Learn when and how to write recursive SQL queries, which allow you to process hierarchical SQL data structures like trees and charts.

Who should take this learning path?

  • SQL beginners.
  • People without any IT experience.
  • Computer Science / IT students.
  • Programmers learning SQL.
  • Anyone who wants to learn complete SQL, including SQL’s modern features.

Requirements:

  • A web browser
  • An internet connection

While doing the SQL From A to Z learning path, you can practice your knowledge with our SQL Practice track. You can also develop your skills and add new tools to your arsenal by continuing to the SQL Reporting learning path.

Track courses

1 0%
131

Coding challenges

☆☆☆☆☆
★★★★★

11 ratings

Basic

SQL Basics in MS SQL Server

Start here if you're new to SQL Server. Learn the basics of T-SQL for SQL Server, retrieve data from an SQL Server database and build simple reports.

Details
2 0%
79

Coding challenges

☆☆☆☆☆
★★★★★

2 ratings

Basic

How to Insert, Update, or Delete Data in MS SQL Server

Discover SQL Server data manipulation language (DML) processes. Learn how to insert, update, and delete data from a database.

Details
3 0%
149

Coding challenges

☆☆☆☆☆
★★★★★

3 ratings

Basic

Common Functions in MS SQL Server

Learn how to use common T-SQL functions to process various types of data with ease. Soon, you’ll be able to modify textual data, perform calculations, round numbers up or down, change date and time formats, and even adjust time zone info!

Details
4 0%
97

Coding challenges

☆☆☆☆☆
★★★★★

3 ratings

Advanced

Creating Basic SQL Reports in SQL Server

Learn how to build basic SQL reports and make more informed, strategic decisions.

Details
5 0%
214

Coding challenges

☆☆☆☆☆
★★★★★

3 ratings

Advanced

Window Functions in MS SQL Server

Learn how to use analytic T-SQL functions to deeply understand data.

Details
6 0%
112

Coding challenges

☆☆☆☆☆
★★★★★

2 ratings

Advanced

Recursive Queries in MS SQL Server

Master the most challenging type of T-SQL queries. Learn how to process trees and graphs in T-SQL, and how to effectively organize long SQL queries.

Details
7 0%
68

Coding challenges

☆☆☆☆☆
★★★★★

4 ratings

Advanced

GROUP BY Extensions in MS SQL Server

Learn how to use ROLLUP, CUBE, and GROUPING SETS—three extremely useful GROUP BY extensions that will help you create sophisticated queries in no time.

Details

Reviews (0)

Average rating

5.00 / 5

☆☆☆☆☆
★★★★★

5 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%