Develop an in-depth understanding of the concepts and functions of an advanced SQL server with this free online course.

Have you already mastered the basics of SQL and are now looking to take your skills to the next level? In this course on advanced SQL programming, course creator Travis Cuzick takes your foundational knowledge from the earlier ‘SQL Server for Data Analysis’ course and raises the level up a few notches. We will be starting out with an understanding of how to carry out analysis with key Windows functions such as PARTITION_BY, ROW_NUMBER, RANK and LAG. We will also take a detailed look at subqueries and their application in SQL 2019.

Are you familiar with the concept of pivot tables and how to properly use them? As the course progresses, we will examine the application of EXISTS, STUFF and PIVOTs to perform numerous functions in SQL 2019. The use of common table expressions or CTEs in order to simplify queries will be discussed along with the application of TEMP tables to manage data. Operations such as CREATE, INSERT, UPDATE and DELETE for data management will also be examined in detail as we move along.

As we head towards the tail-end of the material, we will discuss the concepts pertaining to data optimisation and storing data properly. We will be taking a look at LOOKUP tables, user-defined functions IF statements and, finally, programming with dynamic SQL. With SQL developers being the most sought-after data professionals in the market, getting well acquainted with essential SQL concepts is a must. So do not waste any more time: enrol now to take a leap in your professional and personal journey.