DIPLOMA
Diploma in Advanced SQL Server
byIT
Diploma in Advanced SQL Server
time6-10hrs
levelbeginner level
In this course, we will be taking your basic database skills up a notch and providing you with a refined understanding of coding in SQL 2019. We will be going through essential coding concepts such as carrying out advanced analyses, using subqueries, common table expressions and data optimisation. All these techniques can help you become a more efficient programmer and take your skills and career to the next level. So enrol now to keep learning!
Diploma in Advanced SQL Server
Develop an in-depth understanding of the concepts and functions of an advanced SQL server with this free online course.
In this course, we will be taking your basic database skills up a notch and providing you with a refined understanding of coding in SQL 2019. We will be going through essential coding concepts such as carrying out advanced analyses, using subqueries, common table expressions and data optimisation. All these techniques can help you become a more efficient programmer and take your skills and career to the next level. So enrol now to keep learning!
Before We Start Coding
In this module, we review some of the essential details regarding programming in SQL. A guide on how to install SQL Server 2019 and SQL server management studio shall be provided. We will also go through the process of downloading the AdventureWorks sample database. A walkthrough of the course environment shall also be provided during the module.
Advanced Analysis With Window Functions
Scalar and Correlated Subqueries
Common Table Expressions
Temp Table Functions
Optimization
Programming SQL
Course assessment

AD

Related
Articles
Recommended Related
Courses