Skip to content

andrei-kolesnik/hackerrank

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

90 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

HackerRank Problems

Solutions for the practice problems on HackerRank.

C++ / Python / PHP

Strings

  • string input via cin
  • string.substr
  • string.find_first_of
  • vector<string>
  • unordered_map<string, string>
  • substrings
  • Counter class (in Version 1)
  • substrings

ginortS :: [Python] {medium}

  • sorted with key

Classes

  • throw with try-catch
  • standard and non-standard exceptions
  • custom exceptions with parameters
  • abstract functions
  • virtual functions
  • overloaded functions
  • static fields
  • abstract functions
  • virtual functions
  • double-linked lists
  • map
  • multiple inheritance
  • private, protected, and public functions
  • operator overloading
  • 2-D vector
  • static fields
  • operator overloading
  • enum
  • class/struct template specialization
  • template parameter packs
  • variadic templates
  • non-type template parameters

Algorithms / Data Structures / Containers

  • Quicksort

No Idea! :: [Python] {medium}

  • sets
  • hash table
  • tuples

Deque :: [C++ STL] {medium}

  • deque<int>

Piling Up! :: [Python] {medium}

  • collection.deque
  • collections.defaultdict
  • collectios.Counter
  • Binary Search Tree
  • Binary Search Tree
  • Binary Tree
  • bit operations
  • Set bits in an integer / Brian Kernighan's Algorithm
  • construct an array with n elements such that each element between 1 and k, inclusive
  • the first and last elements of the array to be 1 and x
  • heap<int> (C++) / heapq (Python)
  • big integers
  • vector.reverse_iterator
  • graphs
  • depth first search
  • connected components

Python

Easy problems (in one Jupyter Notebook) :: [Python]

Medium and Hard problems (in individual files) :: [Python]

Itertools

  • itertools.permutations
  • itertools.groupby
  • list comprehension
  • itertools.product
  • map
  • list comprehension

SQL

Basic Select

  • count / distinct count
  • shortest / longest string value in the table
  • starting or ending with a vowel
  • not starting or not ending with a vowel

Basic Join

  • inner join, case
  • inner join, group by, having, count
  • inner join, min
  • inner join, group by, having, count
  • inner join, group by, having, sum, max

Aggregation

The Blunder :: [SQL] {easy}

  • cast, avg, replace, ceiling

Alternative Queries

  • Version 1: while, replicate
  • Version 2: Recursive Common Table Expressions (CTE's)
  • Control of Flow: while, break, if

Advanced Select

  • case

The PADS :: [SQL] {medium}

  • group by, count, left, lower, cast

Occupations :: [SQL] {medium}

  • rank, partition, pivot
  • case, exists

New Companies :: [SQL] {medium}

  • join, count distinct, group by

Advanced Join

  • with, row_number over, partition by, group by, count, datediff
  • Common Table Expressions (CTE's)

Projects :: [SQL] {medium}

  • Finding Sequences Tabibitosan Method
  • cross join (Cartesian Product)
  • with, row_number over, datediff

Placements :: [SQL] {medium}

  • join
  • with, row_number over
  • Common Table Expressions (CTE's)

Linux Shell

About

Solutions for the practice problems on HackerRank (https://www.hackerrank.com/andrei_kolesnik)

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published