We may earn an affiliate commission when you visit our partners.
SQL Server Fundamentals
Dan Sullivan
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
Coming soon
We're preparing activities for
SQL Server Fundamentals.
These are activities you can do either before, during, or after a course.
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