Academy of Computer Education

04/01/2023

How to reset Windows Login Password in Windows 7 & Windows 10 using with Command Prompt.

16/12/2022

Computer Secret Tips

15/12/2022

15/12/2022

Top 10 Computer Tricks
Academy of Computer Education

14/12/2022

08/12/2022

The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel.

03/12/2022

The course is designed to provide how to execute core SQL commands to define, select, manipulate, control access, aggregate and join data and data tables. Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems.