OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Udemy logo

Learn T-SQL From Scratch For SQL Server Administrator

4.6 Filled star Filled star Filled star Filled star Half star
Based on 2,854 ratings
see reviews
Raphael Asghar

These individual courses will take you step by step in learning what it takes to become a SQL Production Database Administrator and will teach you the skills, roles, tasks, and responsibilities a SQL Production Database Administrator does on a daily basis. The great benefit of these courses is that you can navigate to one site to learn all that is needed to manage your SQL Server Environment.

Enroll now

What's inside

Learning objective

Students will be able to create database, tables, view, stored procedures, filter data, update and delete information and be able to create complex joins of tables

Syllabus

Step by Step process of configuring and managing a SQL Server Environment
SQL SERVER 2019 PART 1
SQL SERVER 2019 PART 2
SQL SERVER 2019 PART 3
Read more

(Course 1 of 5 ) An introduction to Transact SQL language. At the end of this course, the user will be able to build databases, query data with joins, insert, update and delete data from tables created by the user

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Builds a strong foundation in SQL for beginners
Covers the core tasks and responsibilities of a SQL Production Database Administrator
Teaches learners how to create databases, tables, stored procedures, views, and queries
Develops intermediate SQL skills for learners
Includes hands-on labs and interactive materials
Bonus lecture provides guidance on becoming a SQL DBA

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

T-sql foundation for beginners

According to learners, this course provides a clear and positive introduction to T-SQL, particularly effective for those starting from scratch. Students appreciate the step-by-step approach and numerous practical demonstrations and labs which help solidify understanding of essential querying and data manipulation tasks. Many say it builds a solid foundation in core T-SQL concepts necessary for working with SQL Server. However, some reviewers note the 'Administrator' aspect mentioned in the title may be more introductory than in-depth, focusing primarily on T-SQL rather than extensive administration tasks. A few also mentioned encountering demos using older SQL Server versions, which could be a warning for those requiring the very latest environment.
Builds a strong base in T-SQL.
"I learned so much about T-SQL basics, querying, and data manipulation."
"Provides a solid foundation in T-SQL. The explanations are clear and the instructor is knowledgeable."
"Good intro course. It covers the essential T-SQL commands needed for querying and manipulating data."
Hands-on examples aid learning.
"The hands-on examples are incredibly helpful."
"It's very practical and the instructor provides lots of demos."
"The Create, Read, Update, Delete operations and Joins sections were particularly well explained with practical labs."
Explains concepts simply for novices.
"Excellent course for beginners! The instructor explains everything in a very clear and simple manner."
"Perfect course for absolute beginners. I had no prior experience with databases or SQL, and this course made it very accessible."
"Starts from the absolute basics, perfect if you know nothing about databases or SQL."
May use older software versions.
"Also noticed some demos using SQL Server 2014, while the title mentions 2019."
"Wish it was fully updated to the latest version to avoid compatibility issues."
Admin topics are introductory.
"The 'Administrator' part feels more like a brief overview rather than a deep dive into admin tasks."
"I was hoping for more content related to actual SQL Server Administration, like backups, security, monitoring, etc."
"the administration content is minimal. If you want to learn SQL Server admin specifically, you'll need another course."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Learn T-SQL From Scratch For SQL Server Administrator with these activities:
View Azure SQL Architecture Fundamentals video
Learn the basics of the components of Azure SQL to gain a stronger foundation before beginning SQL Server Administration.
Show steps
  • Go to the Microsoft Learn website.
  • Search for "Azure SQL Architecture Fundamentals".
  • Watch the full video.
Review SQL syntax and basics
Refresh the basics of SQL syntax and commands to prepare for this course's more advanced topics.
Browse courses on SQL
Show steps
  • Review online SQL tutorials or documentation
  • Practice writing basic SQL queries using an online SQL editor or database
  • Take a practice SQL quiz or assessment
Read and review 'Database Management Systems' by Garcia-Molina & Ullman
Review the core concepts of database management systems to strengthen foundational knowledge in advance of taking this course.
View Database Systems: The Complete Book on Amazon
Show steps
  • Purchase a copy of 'Database Management Systems' by Garcia-Molina & Ullman
  • Set a reading schedule to dedicate to this book for the next 8 weeks
  • Write a summary of each chapter in your own words
  • Complete all review questions and exercises at the end of each chapter
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
Create a cheat sheet or summary of key SQL concepts
Reinforce SQL concepts by creating a condensed and easy-to-reference summary.
Browse courses on SQL
Show steps
  • Identify the key SQL concepts covered in the course
  • Create a cheat sheet or summary document using visual aids, concise notes, or examples
  • Review and update the cheat sheet regularly
Practice creating a new SQL database
Improve understanding of how to create and manage databases in SQL Server through practice.
Show steps
  • Open SQL Server Management Studio (SSMS).
  • Connect to a SQL Server instance.
  • Create a new database.
Practice writing SQL queries to filter data
Gain proficiency in filtering data using SQL queries, which is a key skill for data analysis and retrieval.
Show steps
  • Open SQL Server Management Studio (SSMS).
  • Connect to a SQL Server instance.
  • Create a new query window.
  • Write a SQL query to filter data.
Practice writing SQL queries on an online platform
Gain hands-on experience writing SQL queries and troubleshooting errors to improve proficiency.
Browse courses on SQL
Show steps
  • Create an account on an online SQL practice platform
  • Start with basic SQL queries and gradually move on to more complex ones
  • Review solutions and explanations for incorrect queries
Follow online tutorials on SQL Server 2019
Become familiar with the latest features and functionality of SQL Server 2019 to enhance practical skills.
Show steps
  • Identify a reputable online platform offering SQL Server 2019 tutorials
  • Choose tutorials that align with your learning goals
  • Follow the tutorials step-by-step and complete any hands-on exercises
Create a personal database project
Apply the skills learned in the course by creating a personal database project to manage and analyze your own data, fostering practical application and retention.
Show steps
  • Identify a personal data management need.
  • Design a database schema to meet the need.
  • Create the database and tables.
  • Populate the database with data.
  • Write SQL queries to analyze the data.
Attend a SQL Server Administration workshop
Immerse yourself in a real-world environment and learn advanced SQL Server administration techniques.
Show steps
  • Research and identify relevant SQL Server Administration workshops
  • Register and attend the workshop
  • Actively participate and engage with instructors and peers
Contribute to open-source SQL projects
Gain practical experience and enhance SQL skills by actively contributing to open-source projects.
Browse courses on Database Development
Show steps
  • Identify open-source SQL projects that align with your interests and skill level
  • Familiarize yourself with the codebase and development guidelines
  • Start contributing bug fixes, new features, or documentation
Mentor junior SQL professionals or students
Deepen your understanding of SQL concepts and develop leadership skills by mentoring others.
Browse courses on Mentoring
Show steps
  • Identify opportunities to mentor junior SQL professionals or students
  • Prepare materials and resources to support your mentees
  • Provide regular feedback and guidance on SQL-related topics

Career center

Learners who complete Learn T-SQL From Scratch For SQL Server Administrator will develop knowledge and skills that may be useful to these careers:
SQL Server Developer
A SQL Server Developer is responsible for designing, developing, and maintaining databases that run on the Microsoft SQL Server platform. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. You will also learn how to filter data, update and delete information, and create complex joins of tables. These skills are essential for any SQL Server Developer.
See salaries and explore the career path for SQL Server Developer
SQL Server Database Administrator
A SQL Server Database Administrator is responsible for the day-to-day operation and maintenance of SQL Server databases. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. You will also learn how to filter data, update and delete information, and create complex joins of tables. These skills are essential for any SQL Server Database Administrator.
See salaries and explore the career path for SQL Server Database Administrator
Data Analyst
A Data Analyst is responsible for collecting, cleaning, and analyzing data to help businesses make better decisions. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to filter data, update and delete information, and create complex joins of tables. These skills are essential for any Data Analyst who needs to work with SQL Server databases.
See salaries and explore the career path for Data Analyst
Business Intelligence Analyst
A Business Intelligence Analyst is responsible for using data to help businesses make better decisions. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to filter data, update and delete information, and create complex joins of tables. These skills are essential for any Business Intelligence Analyst who needs to work with SQL Server databases.
See salaries and explore the career path for Business Intelligence Analyst
Data Scientist
A Data Scientist is responsible for using data to solve business problems. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to filter data, update and delete information, and create complex joins of tables. These skills are essential for any Data Scientist who needs to work with SQL Server databases.
See salaries and explore the career path for Data Scientist
Database Designer
A Database Designer is responsible for designing and developing databases. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. These skills are essential for any Database Designer who needs to work with SQL Server databases.
See salaries and explore the career path for Database Designer
Software Engineer
A Software Engineer is responsible for designing, developing, and testing software applications. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. These skills can be helpful for any Software Engineer who needs to work with SQL Server databases.
See salaries and explore the career path for Software Engineer
Web Developer
A Web Developer is responsible for designing and developing websites. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. These skills can be helpful for any Web Developer who needs to work with SQL Server databases.
See salaries and explore the career path for Web Developer
IT Manager
An IT Manager is responsible for planning, implementing, and managing the IT infrastructure of an organization. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. These skills can be helpful for any IT Manager who needs to work with SQL Server databases.
See salaries and explore the career path for IT Manager
Project Manager
A Project Manager is responsible for planning, executing, and controlling projects. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. These skills can be helpful for any Project Manager who needs to work with SQL Server databases.
See salaries and explore the career path for Project Manager
Business Analyst
A Business Analyst is responsible for analyzing business needs and developing solutions to meet those needs. This course can help you build a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to filter data, update and delete information, and create complex joins of tables. These skills can be helpful for any Business Analyst who needs to work with SQL Server databases.
See salaries and explore the career path for Business Analyst
Salesforce Administrator
A Salesforce Administrator is responsible for managing and maintaining Salesforce instances. This course may be useful for building a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. These skills can be helpful for any Salesforce Administrator who needs to work with SQL Server databases.
See salaries and explore the career path for Salesforce Administrator
Technical Writer
A Technical Writer is responsible for writing and editing technical documentation. This course may be useful for building a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to filter data, update and delete information, and create complex joins of tables. These skills can be helpful for any Technical Writer who needs to work with SQL Server databases.
See salaries and explore the career path for Technical Writer
Product Manager
A Product Manager is responsible for managing and developing products. This course may be useful for building a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to create and manage databases, tables, views, and stored procedures. These skills can be helpful for any Product Manager who needs to work with SQL Server databases.
See salaries and explore the career path for Product Manager
Customer Success Manager
A Customer Success Manager is responsible for managing and supporting customer relationships. This course may be useful for building a foundation in Transact-SQL, which is the language used to interact with SQL Server databases. You will learn how to filter data, update and delete information, and create complex joins of tables. These skills can be helpful for any Customer Success Manager who needs to work with SQL Server databases.
See salaries and explore the career path for Customer Success Manager

Reading list

We've selected eight books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Learn T-SQL From Scratch For SQL Server Administrator.
Cover image
T-SQL Fundamentals
Save
Provides a solid foundation in T-SQL, the language used to interact with SQL Server databases. It covers topics such as data types, operators, control flow, and stored procedures. It good choice for anyone who wants to learn more about T-SQL and how to use it to manage SQL Server databases.
T-SQL Fundamentals (Developer Reference)
Paperback
$$
T-SQL Fundamentals (Developer Reference)
Paperback
$$
Microsoft SQL Server 2012 T-SQL Fundamentals
Paperback
$$
Microsoft SQL Server 2012 T-SQL Fundamentals...
Kindle Edition
$$
Microsoft SQL Server 2012 T-SQL Fundamentals by...
Unknown Binding
$$$
Cover image
SQL Server 2022 Query Performance Tuning
Save
Provides a practical guide to performance tuning SQL Server databases. It covers topics such as identifying and resolving bottlenecks, optimizing queries, and using performance monitoring tools. It valuable resource for anyone who wants to learn how to improve the performance of their SQL Server databases.
SQL Server 2022 Query Performance Tuning
Paperback
Check
SQL Server 2022 Query Performance Tuning
Kindle Edition
Check
Cover image
Microsoft SQL Server 2012 Analysis Services
Save
Provides a comprehensive overview of SQL Server data architecture, covering topics such as data modeling, indexing, and storage. It valuable resource for anyone who wants to learn more about how SQL Server stores and manages data.
Microsoft SQL Server 2012 Analysis Services: The...
Kindle Edition
$$
Cover image
Introducing Microsoft SQL Server 2016
Save
Provides a comprehensive overview of SQL Server performance monitoring, covering topics such as performance counters, traces, and extended events. It valuable resource for anyone who wants to learn more about how to monitor the performance of their SQL Server databases.
Introducing Microsoft SQL Server 2016
Paperback
Check
Introducing Microsoft SQL Server 2016
Kindle Edition
Check
Cover image
SQL Cookbook
Save
Provides a collection of recipes for common SQL Server administration tasks, such as creating databases, managing users, and backing up databases. It valuable resource for anyone who wants to learn more about how to administer SQL Server databases.
SQL Cookbook: Query Solutions and Techniques for...
Paperback
$$
SQL Cookbook: Query Solutions and Techniques for...
Paperback
$$
[(SQL Cookbook)] [By (author) Anthony Molinaro]...
Paperback
$$$
SQL Cookbook: Query Solutions and Techniques for...
Kindle Edition
$$
Cover image
SQL Server MVP Deep Dives, Volume 2
Save
Provides a comprehensive overview of SQL Server query performance tuning, covering topics such as query optimization, indexing, and performance monitoring. It valuable resource for anyone who wants to learn more about how to improve the performance of their SQL Server queries.
SQL Server MVP Deep Dives, Volume 2
Kindle Edition
$$
Cover image
Data Analysis with Microsoft Power BI
Save
Provides a comprehensive overview of SQL Server Reporting Services, covering topics such as report design, data sources, and deployment. It valuable resource for anyone who wants to learn more about how to use SQL Server Reporting Services to create reports.
Data Analysis with Microsoft Power BI
Kindle Edition
$$
Cover image
Refactoring Databases
Save
Provides a comprehensive overview of SQL Server Integration Services, covering topics such as data integration, data transformation, and data cleansing. It valuable resource for anyone who wants to learn more about how to use SQL Server Integration Services to move data between different systems.
Refactoring Databases: Evolutionary Database Design
Hardcover
$$
Refactoring Databases: Evolutionary Database Design...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Learn T-SQL From Scratch For SQL Server Administrator.
IBM Data Topology
Most relevant
Enterprise Search on Generative AI App Builder
Most relevant
Data and Digital Strategy Execution
Most relevant
Oracle RAC Advanced Operations and Deployment Scenarios
Most relevant
Master Excel Advanced Functions and Analytics
Most relevant
Google BigQuery for Data and ML Engineers
Most relevant
Data Analytics in Excel Using Real-World Examples
Most relevant
Mastering Oracle SQL Functions with SQL Developer
Most relevant
Everyday Excel, Part 2
Most relevant

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Rating
4.6 Filled star Filled star Filled star Filled star Half star
Effort
9 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Builds a strong foundation in SQL for beginners
Covers the core tasks and responsibilities of a SQL Production Database Administrator
Teaches learners how to create databases, tables, stored procedures, views, and queries
Develops intermediate SQL skills for learners
Includes hands-on labs and interactive materials
Bonus lecture provides guidance on becoming a SQL DBA
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to Learn T-SQL From Scratch For SQL Server Administrator.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser