InLearning SQLbyMartyna AdamJoining A to SQL: Using Joins and Normalization To Advance Your Queries and Data AnalysisWelcome to the next installment of the “From A to SQL” series. In previous chapters of the learning journey, we covered databases, setting…Oct 21, 2022Oct 21, 2022
Minh Ngoc NguyenFUNCTION and STORED PROCEDURE in SQL Server, are they the same?Both FUNCTION and STORED PROCEDURE can take parameters and SQL statements to complete a specific task. So why do they need to be separated…Sep 8, 2022Sep 8, 2022
Minh Ngoc NguyenDeal with missing data using SQLMissing values in a dataset are quite popular when cleaning data. In SQL Server, missing values are represented by NULL. There are many…Oct 20, 2022Oct 20, 2022
Minh Ngoc NguyenVIEW vs CTE in SQL, difference and use casesIn this post, I will clearly explain all about View and CTEs (Common Table Expressions) to help you fully understand the difference and use…Aug 31, 20225Aug 31, 20225
Minh Ngoc NguyenJOIN and UNION in SQL, what is the difference?Have you ever been confused between JOIN and UNION function in SQL, when the ven diagrams of JOIN and UNION look like this:Aug 28, 20221Aug 28, 20221
