We may earn an affiliate commission when you visit our partners.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/vbsr44/learn
Here's a deal for you
We found an offer that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
UDEAFNULP2024
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
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
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
SQL SERVER 2019 PART 4
SQL SERVER 2019 PART 5
SQL SERVER 2019 PART 6
HOW TO ACCESS EXTRACT A ZIF FILE FOR DOCS AND SQL SCRIPTS
Introduction to Becoming a Production SQL Server Administrator
(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
POST ADDENDUM
APPLICATIONS NEEDED
CREATE A VIRTUAL MACHINE
INSTALL SQL SERVER 2017
ADD ADVENTUREWORKS2017 DATABASE
SQL SERVER 2014 AND 2017 COMPARISON
SQL Express 2012 Install
SQL AdventureWorks2012 Database
What is Database and a Table
Select
Where
Where With Like
Order By
Quiz 1
Insert Into
Update
Delete
IN Operator
Between
Quiz 2
Create Database
Create Table
Create Temp Table
Constraints Part 1
Constraints Part 2
Aliases
Quiz 3
Joins
Quiz 4
Union
Aggregates
Group By and Having
Alter
Null
ISNULL
Quiz 5
Select Into
Subquery
Data Type
Cast and Convert
String Function
Numeric and Date Function
Quiz 6
Views
Case
Indexes
Stored Procedure
Quiz 7
Triggers
Design Query Editor
Rank
Extra Quiz with answers
SQL Server Administration Part 1
BONUS LECTURE: GET GUIDENCE TO BECOMING A SQL DBA
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Learn T-SQL From Scratch For SQL Server Administrator to your list so you can find it easily later:
Save
Save
Reviews summary
Well-paced t-sql introduction
Learners say this well-paced course is a good introduction to T-SQL for beginners. Rafael, the instructor, presents the material clearly in an order that's conducive to learning T-SQL from scratch. Overall, students are very satisfied with this course.
Well-presented material
"Overall, the material is presented well and is in an order conducive to learning T-SQL from scratch."
Suitable for beginners
"Overall, the material is presented well and is in an order conducive to learning T-SQL from scratch."
"good introduction to T-SQL for beginners."
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
View Azure SQL Architecture Fundamentals video
Show steps
Learn the basics of the components of Azure SQL to gain a stronger foundation before beginning SQL Server Administration.
Show steps
Show steps
Show steps
- Go to the Microsoft Learn website.
- Search for "Azure SQL Architecture Fundamentals".
- Watch the full video.
Review SQL syntax and basics
Show steps
Refresh the basics of SQL syntax and commands to prepare for this course's more advanced topics.
Browse courses on
SQL
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Reinforce SQL concepts by creating a condensed and easy-to-reference summary.
Browse courses on
SQL
Show steps
Show steps
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
Show steps
Improve understanding of how to create and manage databases in SQL Server through practice.
Show steps
Show steps
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
Show steps
Gain proficiency in filtering data using SQL queries, which is a key skill for data analysis and retrieval.
Show steps
Show steps
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
Show steps
Gain hands-on experience writing SQL queries and troubleshooting errors to improve proficiency.
Browse courses on
SQL
Show steps
Show steps
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
Show steps
Become familiar with the latest features and functionality of SQL Server 2019 to enhance practical skills.
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Immerse yourself in a real-world environment and learn advanced SQL Server administration techniques.
Show steps
Show steps
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
Show steps
Gain practical experience and enhance SQL skills by actively contributing to open-source projects.
Browse courses on
Database Development
Show steps
Show steps
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
Show steps
Deepen your understanding of SQL concepts and develop leadership skills by mentoring others.
Browse courses on
Mentoring
Show steps
Show steps
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 Database Administrator
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.
SQL Server Developer
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.
Data Analyst
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.
Business Intelligence 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.
Data Scientist
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.
Database Designer
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.
Web Developer
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.
Project 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.
IT Manager
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.
Software Engineer
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.
Business Analyst
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.
Salesforce Administrator
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.
Customer Success 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.
Technical Writer
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.
Product Manager
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.
For more career information including salaries, visit:
OpenCourser.com/course/vbsr44/learn
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.
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.
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.
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.
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.
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.
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.
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.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/vbsr44/learn
Share
Similar courses
Here are nine courses similar to
Learn T-SQL From Scratch For SQL Server Administrator.
SQL Tutorial: Learn SQL with MySQL Database - Updated (2024)
OpenCourser.com/course/m0u4s9/sql
SQL Tutorial: Learn SQL with MySQL Database - Updated...
Most relevant
SQL Server Essentials, from Scratch
OpenCourser.com/course/89m75i/sql
SQL Server Essentials, from Scratch
Most relevant
Managing SQL Server Database Maintenance
OpenCourser.com/course/b8mtra/managing
Managing SQL Server Database Maintenance
Most relevant
Microsoft Azure Developer: Managing Azure SQL Database
OpenCourser.com/course/xhas1i/microsoft
Microsoft Azure Developer: Managing Azure SQL Database
Most relevant
Learn SQL +Security(pen) testing from Scratch
OpenCourser.com/course/1ssoma/learn
Learn SQL +Security(pen) testing from Scratch
Most relevant
SQL for Beginners: Learn SQL using MySQL and Database Design
OpenCourser.com/course/i1l4q3/sql
SQL for Beginners: Learn SQL using MySQL and Database...
Most relevant
How To Begin Your Career As a SQL Server DBA
OpenCourser.com/course/2p1p03/how
How To Begin Your Career As a SQL Server DBA
Most relevant
Auditing SQL Server With Policy-Based Management
OpenCourser.com/course/fogit7/auditing
Auditing SQL Server With Policy-Based Management
Most relevant
SQL - MySQL for Data Analytics and Business Intelligence
OpenCourser.com/course/418fex/sql
SQL - MySQL for Data Analytics and Business Intelligence
Most relevant
Effort
9 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Good to know
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
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 - 2024 OpenCourser