We may earn an affiliate commission when you visit our partners.
Dan Sullivan
Using T-SQL, the CLR, XML, managing SQL Server operations and security in SQL Server
This course is primarily for C# developers who use SQL Server in their applications. T-SQL developers and Database Administrators will also find it useful.
Register for this course and see more details by visiting:
OpenCourser.com/course/82q9e0/sql
What's inside
Syllabus
Introduction to SQL Server
Using Group By and Having
CTE's and Ranking
Hierarchies
Read more
Syllabus
Introduction to SQL Server
Using Group By and Having
CTE's and Ranking
Hierarchies
Read more
Managing Query Plans
Recursion, Pivoting, and Sampling
Security I
Security II
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Provides the basis for understanding and managing SQL Server security to protect databases and their contents.
Examines advanced Transact-SQL (T-SQL) techniques like managing XML data in SQL Server, simplifying complex queries with common table expressions (CTEs), and optimizing query performance through effective query planning and execution
Focuses on practical implementation, providing hands-on labs and interactive materials to reinforce learning
Suitable for C# developers, T-SQL developers, and database administrators seeking to enhance their SQL Server skills
Taught by Dan Sullivan, an experienced instructor known for his expertise in SQL Server
Does not cover the latest versions of T-SQL introduced in SQL Server 2023. Prerequisites. Requires basic understanding of SQL and C# programming or T-SQL
Save this course
Save SQL Server Fundamentals to your list so you can find it easily later:
Save
Save
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 SQL Server Fundamentals with these
activities:
Review SQL Concepts
Show steps
Strengthen foundational understanding of SQL before starting the course.
Browse courses on
SQL
Show steps
-
Review SQL syntax and data types
-
Practice writing simple SELECT queries
Read 'SQL Server 2012 Bible'
Show steps
Gain in-depth knowledge of SQL Server concepts through a comprehensive book.
View
Microsoft SQL Server 2012 Bible
on Amazon
Show steps
-
Read chapters relevant to course topics
-
Take notes and highlight important concepts
-
Review notes and discuss with peers
Organize Course Materials
Show steps
Enhance learning by organizing and reviewing course materials regularly.
Show steps
-
Create a dedicated folder for course materials
-
File lecture notes, assignments, and other resources
-
Review materials regularly
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Review SQL syntax
Show steps
Practice writing SQL queries to enforce better syntax memorization.
Browse courses on
SQL Syntax
Show steps
-
Review SQL keywords and data types
-
Write simple SELECT queries
-
Practice using joins and subqueries
Follow SQL Tutorials
Show steps
Enhance understanding of SQL Server concepts by following guided tutorials.
Show steps
-
Identify reputable SQL tutorial websites or resources
-
Select tutorials that align with course topics
-
Follow the tutorials step-by-step
Practice T-SQL Queries
Show steps
Practice writing T-SQL queries to improve your understanding of SQL Server's data manipulation language.
Browse courses on
T-SQL
Show steps
-
Write queries to select, insert, update, and delete data.
-
Use aggregate functions to summarize data.
-
Use joins to combine data from multiple tables.
-
Test your queries on a sample database.
T-SQL Exercises
Show steps
Solve T-SQL exercises to strengthen understanding of SQL Server operations.
Browse courses on
T-SQL
Show steps
-
Find exercises online or in textbooks
-
Solve exercises on your own
-
Review solutions and discuss with peers
Follow Tutorials on SQL Server Security
Show steps
Enhance your understanding of SQL Server security by working through guided tutorials that cover topics like authentication, authorization, and auditing.
Browse courses on
SQL Server Security
Show steps
-
Find tutorials on SQL Server security from reputable sources.
-
Follow the tutorials step-by-step.
-
Apply what you learn to your own SQL Server environment.
-
Test your understanding by completing the exercises provided in the tutorials.
Database Design Project
Show steps
Design and create a database to solidify understanding of database concepts and SQL Server.
Browse courses on
Database Design
Show steps
-
Define the purpose and scope of the database
-
Create an ER diagram
-
Implement the database in SQL Server
-
Populate the database with data
-
Test the database and make necessary adjustments
Develop a SQL Server Management Plan
Show steps
Create a comprehensive plan that outlines the strategies and procedures for managing your SQL Server environment, ensuring its performance, security, and availability.
Show steps
-
Gather requirements and define the scope of your SQL Server environment.
-
Research and select appropriate tools and technologies for managing your environment.
-
Develop policies and procedures for database backups, monitoring, and performance tuning.
-
Implement your management plan and monitor its effectiveness.
Review SQL Concepts
Show steps
Strengthen foundational understanding of SQL before starting the course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review SQL syntax and data types
- Practice writing simple SELECT queries
Read 'SQL Server 2012 Bible'
Show steps
Gain in-depth knowledge of SQL Server concepts through a comprehensive book.
View
Microsoft SQL Server 2012 Bible
on Amazon
Show steps
Show steps
Show steps
- Read chapters relevant to course topics
- Take notes and highlight important concepts
- Review notes and discuss with peers
Organize Course Materials
Show steps
Enhance learning by organizing and reviewing course materials regularly.
Show steps
Show steps
Show steps
- Create a dedicated folder for course materials
- File lecture notes, assignments, and other resources
- Review materials regularly
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Review SQL syntax
Show steps
Practice writing SQL queries to enforce better syntax memorization.
Browse courses on
SQL Syntax
Show steps
Show steps
Show steps
- Review SQL keywords and data types
- Write simple SELECT queries
- Practice using joins and subqueries
Follow SQL Tutorials
Show steps
Enhance understanding of SQL Server concepts by following guided tutorials.
Show steps
Show steps
Show steps
- Identify reputable SQL tutorial websites or resources
- Select tutorials that align with course topics
- Follow the tutorials step-by-step
Practice T-SQL Queries
Show steps
Practice writing T-SQL queries to improve your understanding of SQL Server's data manipulation language.
Browse courses on
T-SQL
Show steps
Show steps
Show steps
- Write queries to select, insert, update, and delete data.
- Use aggregate functions to summarize data.
- Use joins to combine data from multiple tables.
- Test your queries on a sample database.
T-SQL Exercises
Show steps
Solve T-SQL exercises to strengthen understanding of SQL Server operations.
Browse courses on
T-SQL
Show steps
Show steps
Show steps
- Find exercises online or in textbooks
- Solve exercises on your own
- Review solutions and discuss with peers
Follow Tutorials on SQL Server Security
Show steps
Enhance your understanding of SQL Server security by working through guided tutorials that cover topics like authentication, authorization, and auditing.
Browse courses on
SQL Server Security
Show steps
Show steps
Show steps
- Find tutorials on SQL Server security from reputable sources.
- Follow the tutorials step-by-step.
- Apply what you learn to your own SQL Server environment.
- Test your understanding by completing the exercises provided in the tutorials.
Database Design Project
Show steps
Design and create a database to solidify understanding of database concepts and SQL Server.
Browse courses on
Database Design
Show steps
Show steps
Show steps
- Define the purpose and scope of the database
- Create an ER diagram
- Implement the database in SQL Server
- Populate the database with data
- Test the database and make necessary adjustments
Develop a SQL Server Management Plan
Show steps
Create a comprehensive plan that outlines the strategies and procedures for managing your SQL Server environment, ensuring its performance, security, and availability.
Show steps
Show steps
Show steps
- Gather requirements and define the scope of your SQL Server environment.
- Research and select appropriate tools and technologies for managing your environment.
- Develop policies and procedures for database backups, monitoring, and performance tuning.
- Implement your management plan and monitor its effectiveness.
Career center
Learners who complete SQL Server Fundamentals will develop knowledge and skills
that may be useful to these careers:
SQL Server Database Administrator
SQL Server Database Administrator
SQL Server Database Administrators set up, configure, maintain, and support SQL Server databases. They ensure that databases are available, secure, and performant. This course can help you build a foundation in SQL Server, which is essential for success as a Database Administrator. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to manage SQL Server databases effectively and efficiently.
Data Analyst
Data Analyst
Data Analysts use data to solve business problems. They collect, clean, and analyze data to identify trends and patterns. This course can help you build a foundation in SQL Server, which is a valuable tool for Data Analysts. You will learn how to use T-SQL to query data, and how to use the CLR and XML to extend the functionality of SQL Server. This knowledge will help you to extract insights from data and make informed decisions.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines. They ensure that data is available, reliable, and scalable. This course can help you build a foundation in SQL Server, which is a popular database for data pipelines. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to design and build data pipelines that are efficient and reliable.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. They use a variety of programming languages and technologies to create software that meets the needs of users. This course can help you build a foundation in SQL Server, which is a popular database for enterprise software applications. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to develop software applications that are scalable, reliable, and secure.
Database Architect
Database Architect
Database Architects design and implement database systems. They ensure that databases are efficient, scalable, and secure. This course can help you build a foundation in SQL Server, which is a popular database for enterprise database systems. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to design and implement database systems that meet the needs of your organization.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts use data to improve business processes. They identify trends and patterns in data to help businesses make better decisions. This course can help you build a foundation in SQL Server, which is a valuable tool for Business Intelligence Analysts. You will learn how to use T-SQL to query data, and how to use the CLR and XML to extend the functionality of SQL Server. This knowledge will help you to extract insights from data and make informed decisions.
Systems Analyst
Systems Analyst
Systems Analysts design and implement computer systems. They work with users to identify needs, and then design and implement systems that meet those needs. This course can help you build a foundation in SQL Server, which is a popular database for enterprise computer systems. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to design and implement computer systems that are efficient, reliable, and secure.
Web Developer
Web Developer
Web Developers design and develop websites and web applications. They use a variety of programming languages and technologies to create websites that are user-friendly and functional. This course can help you build a foundation in SQL Server, which is a popular database for web applications. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to develop web applications that are scalable, reliable, and secure.
IT Manager
IT Manager
IT Managers plan and direct the activities of an organization's IT department. They are responsible for the development, implementation, and maintenance of IT systems. This course can help you build a foundation in SQL Server, which is a popular database for enterprise IT systems. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to manage IT systems effectively and efficiently.
IT Consultant
IT Consultant
IT Consultants provide advice and guidance to organizations on the use of IT. They help organizations to select, implement, and maintain IT systems. This course can help you build a foundation in SQL Server, which is a popular database for enterprise IT systems. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to provide advice and guidance to organizations on the use of SQL Server.
Data Scientist
Data Scientist
Data Scientists use data to solve complex problems. They develop and apply statistical and machine learning models to data to identify trends and patterns. This course can help you build a foundation in SQL Server, which is a valuable tool for Data Scientists. You will learn how to use T-SQL to query data, and how to use the CLR and XML to extend the functionality of SQL Server. This knowledge will help you to extract insights from data and make informed decisions.
Network Administrator
Network Administrator
Network Administrators design, implement, and maintain computer networks. They are responsible for the security and performance of networks. This course can help you build a foundation in SQL Server, which is a popular database for network management systems. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to design and implement network management systems that are efficient, reliable, and secure.
Security Analyst
Security Analyst
Security Analysts identify and mitigate security risks. They develop and implement security measures to protect organizations from cyberattacks. This course can help you build a foundation in SQL Server, which is a popular database for security information and event management (SIEM) systems. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to develop and implement SIEM systems that are effective in protecting organizations from cyberattacks.
Cloud Engineer
Cloud Engineer
Cloud Engineers design, build, and maintain cloud computing systems. They are responsible for the security and performance of cloud systems. This course can help you build a foundation in SQL Server, which is a popular database for cloud computing systems. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to design and implement cloud systems that are efficient, reliable, and secure.
Project Manager
Project Manager
Project Managers plan and execute projects. They are responsible for the success of projects, and for ensuring that projects are completed on time, within budget, and to the required quality. This course may be useful for Project Managers who are working on projects that involve SQL Server. You will learn about T-SQL, the CLR, XML, and managing SQL Server operations and security. This knowledge will help you to understand the technical aspects of SQL Server projects, and to make informed decisions about the use of SQL Server in your projects.
For more career information including salaries, visit:
OpenCourser.com/course/82q9e0/sql
Reading list
We've selected six 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
SQL Server Fundamentals.
Provides a detailed look at SQL Server execution plans, covering topics such as how to read and understand execution plans, and how to use them to improve query performance. It would be a valuable reference for developers and administrators who want to learn more about query performance tuning.
Provides a deep dive into the internals of SQL Server, covering topics such as memory management, query processing, and storage. It would be a valuable reference for developers and administrators who want to learn more about how SQL Server works.
Provides a detailed look at SQL Server execution plans, covering topics such as how to read and understand execution plans, and how to use them to improve query performance. It would be a valuable reference for developers and administrators who want to learn more about query performance tuning.
Provides a comprehensive guide to CLR programming in SQL Server, covering topics such as creating CLR assemblies, using CLR types in T-SQL, and debugging CLR code. It would be a valuable reference for developers who want to use CLR programming to extend the functionality of SQL Server.
Provides a comprehensive guide to CLR programming in SQL Server, covering topics such as creating CLR assemblies, using CLR types in T-SQL, and debugging CLR code. It would be a valuable reference for developers who want to use CLR programming to extend the functionality of SQL Server.
Save
Provides a good introduction to SQL Server for beginners, covering the basics of database design, T-SQL, and SQL Server management. It would be helpful as background reading before taking this course.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/82q9e0/sql
Share
Similar courses
Here are nine courses similar to
SQL Server Fundamentals.
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)
OpenCourser.com/course/m4fmto/become
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL...
Most relevant
SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping
OpenCourser.com/course/173zi9/sql
SQL Server: Understanding, Configuring, and...
SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring
OpenCourser.com/course/6ea1gy/sql
SQL Server: Understanding, Configuring and...
Understanding Query Optimization in SQL Server
OpenCourser.com/course/og3xif/understanding
Understanding Query Optimization in SQL Server
T-SQL Data Manipulation Playbook
OpenCourser.com/course/r8f06m/t
T-SQL Data Manipulation Playbook
SQL Server Performance Tuning Part 1
OpenCourser.com/course/splh3q/sql
SQL Server Performance Tuning Part 1
Supporting SQL Server High Availability with Kubernetes
OpenCourser.com/course/fuidmc/supporting
Supporting SQL Server High Availability with Kubernetes
T-SQL Functions Playbook
OpenCourser.com/course/gm6un2/t
T-SQL Functions Playbook
Unit Testing T-SQL Code with tSQLt
OpenCourser.com/course/e07glp/unit
Unit Testing T-SQL Code with tSQLt
Time
492 hours
Level
Introductory
Via
Pluralsight
Instructor
Dan Sullivan
Language
English
Good to know
Provides the basis for understanding and managing SQL Server security to protect databases and their contents.
Examines advanced Transact-SQL (T-SQL) techniques like managing XML data in SQL Server, simplifying complex queries with common table expressions (CTEs), and optimizing query performance through effective query planning and execution
Focuses on practical implementation, providing hands-on labs and interactive materials to reinforce learning
Suitable for C# developers, T-SQL developers, and database administrators seeking to enhance their SQL Server skills
Taught by Dan Sullivan, an experienced instructor known for his expertise in SQL Server
Does not cover the latest versions of T-SQL introduced in SQL Server 2023. Prerequisites. Requires basic understanding of SQL and C# programming or T-SQL
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