Thursday, March 12, 2020

How to get random rows in SQL? SQL Query to get Random data. Top N Random Records.

There are a number of ways to get Random data from database. Following are some examples that works without any extra algorithm:

SQL Server:

SELECT TOP 20 *
FROM table_name
ORDER BY NEWID()

MySQL:

SELECT *
FROM table_name
ORDER BY RAND()
LIMIT 20



PostgreSQL:

SELECT *
FROM table_name
ORDER BY RANDOM()
LIMIT 20

Oracle:

SELECT *  FROM
( SELECT *
FROM table_name
ORDER BY dbms_random.value )
WHERE rownum <= 20











Thursday, March 5, 2020

Indonesia Public Holidays 2020


  Indonesia Public Holidays 2020

Following table contains a national calendar of all 2020 public holidays for Indonesia which is subject to change on official decision by the government of Indonesia.

DateDayHoliday
1 JanuaryWednesdayNew Year's Day
25 JanuarySaturdayChinese New Year
22 MarchSundayIsra Mi'raj
25 MarchWednesdayBali Hindu New Year
10 AprilFridayGood Friday
1 MayFridayLabour Day
7 MayThursdayWaisak Day
21 MayThursdayAscension Day of Jesus Christ
22 MayFridayLebaran Holiday
24 May to 25 MaySunday to MondayHari Raya Idul Fitri
26 May to 27 MayTuesday to WednesdayLebaran Holiday
1 JuneMondayPancasila Day
31 JulyFridayIdul Adha
17 AuguestMondayIndependence Day
20 AuguestThursdayIslamic New Year
29 OctoberThursdayProphet Muhammad's Birthday
24 DecemberThursdayChristmas Holiday
25 DecemberFridayChristmas Day


Wednesday, March 4, 2020

Thailand Public Holidays 2020

  Thailand Public Holidays 2020

Following table contains a national calendar of all 2020 public holidays for Thailand which is subject to change on official decision by the government of Thailand.

Date Day Holiday
1 January Wednesday New Year's Day
25 January Saturday Chinese New Year
8 FebruarySaturdayMakha Bucha Day
10 FebruaryMondayMakha Bucha Holiday
6 AprilMondayChakri Day
13 April to 16 AprilMonday to ThursdaySongkran Festival
1 MayFridayLabour Day
4 MayMondayCoronation of King Vajiralongkorn
6 MayWednesdayVisakha Bucha Day
11 MayMondayRoyal Ploughing Ceremony
24 MaySundayEnd of Ramadan
3 JuneWednesdayQueen Suthida's Birthday
5 JulySundayAsahna Bucha Day
6 JulyMondayKhao Phansa Day
6 JulyMondayAsahna Bucha Day Holiday
7 JulyTuesdayKhao Phansa Holiday
28 JulyTuesdayKing Vajiralongkorn's Birthday
12 AugustWednesdayHer Majesty the Queen Mother's Birthday
13 OctoberTuesdayPassing of His Majesty the Late King
23 OctoberFridayChulalongkorn Memorial Day
5 DecemberSaturdayHis Majesty the Late King's Birthday
7 DecemberMondayHis Majesty the Late King's Birthday Holiday
10 DecemberThursdayConstitution Day
25 DecemberFridayChristmas Day
31 December Thursday New Year's Eve


Google Sheet Tutorial Basic Mathematical Functions & Formulas





Google Sheet Tutorial Basic Mathematical Functions and Formulas. Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. With Google Sheets, everyone can work together in the same spreadsheet at the same time. Use formulas, functions, and formatting options to save time and simplify common spreadsheet tasks. Google sheet is alternative to Microsoft Excel and have some facilities over Microsoft excel.


Referral links that will not charge you but help me earning commissions. Buy tubebuddy channel booster plugin for your channel: https://bit.ly/2HP5lJR

Please watch till the end of the video, I hope you will enjoy it. If you have enjoy the video, please go ahead and like it. Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments. Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v



Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v

Channel URL: https://goo.gl/VYi58K

Most Recent Videos: https://goo.gl/hXFN4w

Most Popular Video: https://goo.gl/7u7B1x


Social:

Facebook: https://www.facebook.com/triksbuddy/

Linked in: https://www.linkedin.com/company/triksbuddy/

Blog: https://triksbuddy.blogspot.com/

Tumblr: https://imrulquaes89.tumblr.com/

RSS Feed:
https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw



 #GoogleSheetTutorial, #triksbuddy

How to Draw Usecase Diagram using Draw.io







Learn How to Draw Usecase Diagram using Draw.io. This video shows you how easily you can draw usecase uml diagram using www.Draw.io. 

Use cases are a way of describing interactions between users and a system using a graphical model and structured text. They were first introduced in the Objectory method and have now become a fundamental feature of the Unified Modeling Language (UML). In their simplest form, a use case identifies the actors involved in an interaction and names the type of interaction. You then add additional information describing the interaction with the system. The additional information may be a textual description or one or more graphical models such as the UML sequence or state charts.

Use cases identify the individual interactions between the system and its users or other systems. Each use case should be documented with a textual description. These can then be linked to other models in the UML that will develop the scenario in more detail.

There are many tools available in the market for drawing use case diagrams. Visio is one of the most popular tool from microsoft which is not free for use. As an alternative of visio, draw.io is a great tool that allows you free access along with free storage and integration with other cloud applications like google drive, dropbox etc for storing you drawings.

 
 
If you have enjoy the video and get it interesting, please hit like button.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification. 
 
In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. 
Subscription link: https://goo.gl/GE4g8v 
Please subscribe in below link and like our video. 
Subscription URL: https://goo.gl/GE4g8v 
Channel URL: https://goo.gl/VYi58K 
Most Recent Videos: https://goo.gl/hXFN4w 
Most Popular Video: https://goo.gl/7u7B1x 
Social:
Facebook: https://www.facebook.com/triksbuddy/ 
Linked in: https://www.linkedin.com/company/triksbuddy/ 
Blog: https://triksbuddy.blogspot.com/ 
Tumblr: https://www.tumblr.com/blog/imrulquaes89 
RSS Feed: https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw
 

Creating a Meeting in GSuite Google Calender - triksbuddy







This video will shows way of creating a meeting in GSuite Google
Calender. Google GSuite allows you to create a meeting call easily using
google calender. The application allows you to setup meeting
notification which will be shown to the participants before the given
period of time before the meeting. GSuite allows you to setup available
meeting rooms of your organization. You can invite internal and external
guest.

Tuesday, November 26, 2019

Supervised, Unsupervised and Semi-supervised Learning Algorithm - Machine Learning Tutorial-02





This video demonstrates Supervised Learning, Unsupervised Learning and Semi-supervised Machine Learning Algorithm. Welcome to Introduction to Machine Learning - Machine Learning Tutorial.

Supervised Learning: In supervised learning, label data or output or supervisor data or teacher data is given in training data. Supervised learning must contain label data during training phase.
Supervised Learning Algorithms are:
- Nearest Neighbor (NN)
- K-Nearest Neighbor (KNN)
- Artificial Neural Network (ANN)
- Support Vector Machine (SVM)
- Decision Tree (DT) ex: ID3, C4.5
- Apriori Algorithm
- Hidden Markov Model (HMM)
- Logistic Regression
- Naive Bayes Classifier

Unsupervised Learning: In unsupervised learning only input data is given in training data. No label data or supervisor data is given. Unsupervised Learning separate data into clusters.

Un-Supervised Learning Algorithms are:
- K-Means Clustering
- Modified K-Means Clustering
- Hierarchical Clustering
- SOM (Self Organizing Map)
- Fuzzy C-Mean Clustering

Semi-Supervised Learning: In semi-supervised learning for some data label data is given and for some data label data is missing. Input data that are not labelled have to be labelled using labelled input training data. Then apply testing data for intelligent decision.

Please watch till the end of the video to get a clear concept of machine learning algorithms, I hope you will enjoy it.


Monday, November 18, 2019

Introduction to Machine Learning - Machine Learning Tutorial-01





Welcome to Machine Learning tutorial. This is introduction to machine learning which is the first video of this series.

In this video I have given a very easy definition of Machine Learning, shown application of Machine Learning in different sectors and different types of Machine Learning techniques.

In next video, I will discuss about different Machine Learning types in broader details.

The content of this video is primarily focused for computer science  undergraduate and graduate level students who wants to make clear understanding of machine learning algorithms with solving mathematical problems using machine learning algorithm. However any other interested learners who have high interest on learning Machine Learning can watch and join the community.

*Subscribe the channel and get in touch.
*If you have any query regarding Machine Learning concept please write in comments.
*If you think this video might be helpful for others, please keep sharing.


Sunday, October 27, 2019

Learn Project Management For Free from Top Universities and Organizations


There are huge resource online to learn about project management. Following is a short list of free project management learning resources over there in online that are very helpful for your study:

Edx:

Coursera:
 Udemy: 
Alison:
FutureLearn:

Youtube:

 

Wednesday, October 23, 2019

Introduction to Project Management: Definition of Project, Characteristics of Project

What is a Project? What are the characteristics of Project?

According to the Project Management Institute:
 "A project is a temporary endeavor undertaken to create a unique product, service, or result." 

Let's break down this definition into its components to understand further what a project is (and what it is not) and try to understand project characteristics:

It is a temporary endeavor:- what does that mean? It means that it isn't endless; it has a start date and an end date. Projects do not go on indefinitely. Activities that go on indefinitely are typically known as processes or operations. So how do we understand when a project ends?

The project reaches to end when one or more of the following condition(s) met:
  • The project’s objectives have been achieved;
  • The objectives will not or cannot be met;
  • Funding is exhausted or no longer available for allocation to the project;
  • The need for the project no longer exists (e.g., the customer no longer wants the project completed, a change in strategy or priority ends the project, the organizational management provides direction to end the project);
  • The human or physical resources are no longer available; or
  • The project is terminated for legal cause or convenience.
It creates a unique product, service, or result:- which we call a deliverable. Unique means that it is unlike any other project. It may be similar to other projects but it is never identical to one. This is what distinguishes a project from a process. A project is unique; a process is repeatable and strives for consistency, standardization, and no deviation from a standard. Deliverable means that it has a tangible or intangible outcome: i.e. a new software product, a new drug, a new building, a merger of two companies, improved customer service, etc. The outcome may be a product, goods, or a service.

Fulfillment of project objectives may produce one or more of the following deliverables:
  • A unique product that can be either a component of another item, an enhancement or correction to an item, or a new end item in itself (e.g., the correction of a defect in an end item);
  • A unique service or a capability to perform a service (e.g., a business function that supports production or distribution);
  • A unique result, such as an outcome or document (e.g., a research project that develops knowledge that can be used to determine whether a trend exists or a new process will benefit society); and
  • A unique combination of one or more products, services, or results (e.g., a software application, its associated documentation, and help desk services).

 ⇛ It drive change in the Organization:- From a business perspective, a project is aimed
at moving an organization from one state to another state in order to achieve a specific objective. The term Current State, Future State, and Transition State are used to describe change in organization.  
  • Current state: is the state of organization before the project begins.  
  • Future state: is the desired or resulted state where the organization will be driven by the project. 
  • Transition state: For large projects, if there are milestone deliverables, transition state refer to the state where organization reaches after each milestone is delivered.
It enables business value creation:- business value is the net quantifiable tangible, intangible, or both benefit to the stakeholders derived from a business endeavor. It is considered the return, in the form of elements such as time, money, goods, or intangibles in return for something exchanged.

Examples of tangible elements:
  • Monetary assets,
  • Stockholder equity,
  • Utility,
  • Fixtures,
  • Tools, and
  • Market share.
Examples of intangible elements:
  • Goodwill,
  • Brand recognition,
  • Public benefit,
  • Trademarks,
  • Strategic alignment, and
  • Reputation.

It initiated in some context:- projects are created in context of organizational factors by organizational leaders. Four fundamental categories of factors are there, which illustrates the context of initiating a project:
  • Meet regulatory, legal, or social requirements;
  • Satisfy stakeholder requests or needs;
  • Implement or change business or technological strategies; and
  • Create, improve, or fix products, processes, or services.

It has defined objectives:- The goals expected to be achieved. There can be technical goals (develop new technology), legal or political goals (to meet governmental regulations), and/or business goals (beating or eliminating competition). These objectives should be measurable.

It has scope:- All the work required to deliver the product or result and satisfy the objectives for which a project was undertaken at a level of quality expected by the customer. The scope includes all the deliverables required to meet the project objectives.

It has cot:- The planned cost of conducting the project; it includes human and physical resources.

It has Time/Schedule:- The planned time to complete the project, as well as the Milestones along the way. 


EXAMPLES OF PROJECTS:

  • Building a house
  • Developing a new pharmaceutical compound for market
  • Building a mobile application
  • Expanding a tour guide service
  • Developing a new product
  • Merging two organizations
  • Improving a business process within an organization
  • Improvement of a service (i.e. customer service, Six Sigma initiative)
  • Modifying a computer software program used in an organization
  • Conducting research to develop a new manufacturing process


EXAMPLES OF PROJECT OUTCOMES:

  • Pyramids of Giza,
  • Olympic games,
  • Great Wall of China,
  • Taj Mahal,
  • Publication of a children’s book,
  • Panama Canal,
  • Development of commercial jet airplanes,
    Polio vaccine,
  • Human beings landing on the moon,
  • Commercial software applications,
  • Portable devices to use the global positioning system (GPS), and
  • Placement of the International Space Station into Earth’s orbit.


Further reading on PMP:
  1. Project Management Life Cycle
  2. Project Management Certifications Questions with explanation.
  3. Free PMP Certification Questions