Main menu

Pages

Latest Posts

Show more
 8 Powerful SQL Techniques to Boost Your Data Analysis Skills
Mister 13 April 2024
SQL Techniques to Boost Your Data Analysis Skills In today's data-driven world, data analysts are the unsung heroes, transforming raw ...
Read more
 Oracle SQL Associate Certification for Data Analysts
Mister 10 April 2024
How to Standout as a Data Analyst In today's data-driven world, data analysts are rock stars. However, the magic behind their analysis...
Read more
SQL Date Function in SQL Server
Mister 27 April 2022
 SQL Date Function in SQL Server SELECT        GETDATE() AS SystemTime,       DATEPART(year, GETDATE()) AS System_Year,       YEAR(GETDATE()...
Read more
String Functions with SQL
Mister 26 April 2022
 String Functions SELECT            FirstName,           left(FirstName,3) AS First3,   right(FirstName,3) AS Last3,   upper(FirstName) ...
Read more
Calculations with SQL
Mister 26 April 2022
 What is T-SQL SQL is the structured query language A language that communicates with the  databases             retrieve, insert, edit, del...
Read more
Power BI tips for Better Visualization
 Conditional Formatting  form field pane select default color  Set the formatting settings  The visual shows the profit by branch
Read more
The Practical Examples of SQL Joins
Mister 23 April 2022
  The Practical Examples of SQL Joins SQL Join Join clause is used to mege data from two or more table into one table, using shared column b...
Read more