October 2023
Intermediate
7h 10m
English
on-demand course
The Ultimate T-SQL And Microsoft SQL Server Bootcamp
with Trevoir Williams, Emar Morrison
Closed Captioning available in English
Overview
In this 7-hour course, you will dive deep into Microsoft SQL Server and T-SQL, mastering the skills necessary for efficient database management and development. Starting with the fundamentals, you'll progress to advanced database operations, gaining practical experience through hands-on examples and exercises.
What I will be able to do after this course
- Grasp the essentials of SQL Server and T-SQL, including writing queries and managing database schemas.
- Write advanced queries with joins, subqueries, and window functions for complex analysis.
- Develop practical database management skills, covering database security and configuration.
- Master the use of T-SQL procedures, variables, functions, and advanced operations.
- Understand transaction management to ensure data accuracy and integrity in database systems.
Course Instructor(s)
Trevoir Williams and Emar Morrison are experienced database and programming professionals with a strong background in SQL Server and T-SQL. They have years of teaching experience, focusing on providing learners with hands-on, real-world skills. Their teaching methods foster understanding, ensuring you can apply your knowledge effectively.
Who is it for?
This course is ideal for anyone seeking to build or enhance their skills in SQL and database management. Beginners with a basic understanding of database concepts, IT professionals looking to upskill, and developers transitioning into data analysis or database administration will find this course particularly beneficial.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.