From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, and 2022
Instructed by Phillip Burton 28.5 hours on-demand video, 3 coding exercises & 30 articles, 27 downloadable resources
After completing the course, you will…
-
Create tables in a database and ALTER columns in the table.
-
Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
-
retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
-
JOIN two or more tables together, finding missing data.
-
INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
-
Create constraints, views and triggers
-
Use UNION, CASE, MERGE, procedures and error checking
-
Apply ranking and analytic functions, grouping, geography and geometry database
-
Create subqueries and CTEs, PIVOTs, UDFs, APPLYs, synonyms.
-
Manipulate XMLs and JSONs.
-
Learn about transactions, optimise queries and row-based v set-based operations
Who this course is for:
- This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to learn T-SQL.
- This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.
Similar Udemy Course Coupons
- SQL and Transact-SQL (T-SQL) For Beginners
- SQL Introduction Course 2024: SQL Crash Course.
- Complete Microsoft SQL and Database Design Masterclass
Deal Score-2
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.