We may earn an affiliate commission when you visit our partners.
Course image
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
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

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

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
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.
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.

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.
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.
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.

Share

Help others find this course page by sharing it with your friends and followers:

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...
Most relevant
SQL Server Essentials, from Scratch
Most relevant
Managing SQL Server Database Maintenance
Most relevant
Microsoft Azure Developer: Managing Azure SQL Database
Most relevant
Learn SQL +Security(pen) testing from Scratch
Most relevant
SQL for Beginners: Learn SQL using MySQL and Database...
Most relevant
How To Begin Your Career As a SQL Server DBA
Most relevant
Auditing SQL Server With Policy-Based Management
Most relevant
SQL - MySQL for Data Analytics and Business Intelligence
Most relevant
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