Danilo Bilanoski

Hi there! I'm mostly here for coding challenges, learning & networking. All preferred variations for my handle were taken so Pascal Case it is.

[Danilo Bilanoski @DBilanoski]

Round 4 - day 100 of #100daysofcode #100daysofcodechallenge

Left this blank on Sept27, realized I never updated it. Discipline and continuity at their absolute worst. Worked a lot with dbs and Python, landed a dev job as a Global Implementation Specialist. See you next round😎

[Danilo Bilanoski @DBilanoski]

Round 4 - 099 of #100daysofcode #100daysofcodechallenge

Skipped few days, today back to it. Worked on error handling and unit testing in Python.

[Danilo Bilanoski @DBilanoski]

Round 4 - 098 of #100daysofcode #100daysofcodechallenge

Today was the all about the challenges \ assignments from some lectures on the OOP with Python.

[Danilo Bilanoski @DBilanoski]

Round 4 - 083-097 of #100daysofcode #100daysofcodechallenge
Another 1+month of posting nothing - probably the worst challenge round ever. Had a hell of a summer. But kept learning. So let's say 15 days of Python basics around oop, api handling and data crunching libraries.

[Danilo Bilanoski @DBilanoski]

Round 4 - 065-082 of #100daysofcode #100daysofcodechallenge

Pff.. had a month of posting nothing. But kept learning. So around 20 days we'll just have to do shortly and from the memory. Let's say 10 days of Python basics, then a week of SQL server and integration services.

[Danilo Bilanoski @DBilanoski]

Round 4 - 065 of #100daysofcode #100daysofcodechallenge

Spend some time to see which Python course could bring me up fast with basic Python and went with Udemy's "Automate Everything With Python". Did a crash course on bare basics today and starting with the course tomorrow.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 063 & 064 of #100daysofcode #100daysofcodechallenge

Did not post yesterday. Completed "Level Up: Advanced SQL" course and with that, the "Master SQL Development" LinkedIn learning is done.

Fantastic collection of short courses diving deeper into SQL internals.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 062 of #100daysofcode #100daysofcodechallenge

Completed "Advanced SQL for Data Scientist" course from the LinkedIn learning. A bit too advanced topics for me at this point but nevertheless, a good intro to data modeling, indexing algorithms and custom functions.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 061 of #100daysofcode #100daysofcodechallenge

Completed "Advanced SQL for Application Development" course from the "Master SQL Development" LinkedIn education. Worked with Python, learned about db drivers and ORM.

It was a blast.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 060 of #100daysofcode #100daysofcodechallenge

Completed "Advanced SQL for Query Tuning and Performance Optimization" course from the LinkedIn education path. Useful, explains query plans, indexing, partitioning and optimization quite well.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 059 of #100daysofcode #100daysofcodechallenge

Completed "Advanced SQL: Logical Query Processing, Pt. 2" course from the Linkedin path education. Maybe a tad too advanced for me at this point, but excellent dive into processing of joins, grouping sets and recursion.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 058 of #100daysofcode #100daysofcodechallenge

Completed "Advanced SQL: Logical Query Processing, Part 1" course from the "Master SQL Development" LinkedIn education where I learnt about execution order in SQL. Fantastic course to wrap your head around queries.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 056, 057 of #100daysofcode #100daysofcodechallenge

Last few days I was digging db\sql literature to solidify knowledge and was not posting here. Enrolled to "Master SQL Development" LinkedIn learning path and completed the first one of 8 short courses there.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 055 of #100daysofcode #100daysofcodechallenge

Took the Saturday off, today back to it.
Did the bonus lectures of the TSQL course and completed it fully. It was a choppy experience with some backtracking to skipped topics, would not really recommend it.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 054 of #100daysofcode #100daysofcodechallenge

Nearly at the end of the TSQL Udemy course, took a course test, got 83% and passed (70% was needed for passage). Then took it again and got 97% which looks better.

Few more bonus lessons tomorrow and outro.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 053 of #100daysofcode #100daysofcodechallenge

Continued with the TSQL course from Udemy. Today were basics about security and access control and how backup and recovery works in the Microsoft SQL server.

Nearly at the end of it.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 052 of #100daysofcode #100daysofcodechallenge

Continued with the TSQL course from Udemy where I worked with set operators, then learnt about indexes.
Another topic just briefly covered in the course so I'll have to dive deeper elsewhere.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 051 of #100daysofcode #100daysofcodechallenge

Onward with the TSQL course from Udemy - today was more DML objects, stored procedures and user defined functions.
Poorly covered in the course so had to explore elsewhere with few examples. Pretty useful.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 050 of #100daysofcode #100daysofcodechallenge

It's getting harder and harder to stay disciplined during weekends.

Continued with the TSQL course where I worked with DDL and learnt about views. Did few hours to compensate for the weekend off.

[Danilo Bilanoski @DBilanoski]

Round 4 - Day 049 of #100daysofcode #100daysofcodechallenge

Had a busy few days where I squeezed some learning time here and there, let's count one day for all of it.
Worked further with the TSQL course, learnt about DML, mostly how INSERT and UPDATE work and how to use them.