Home » Archives for Sergio Lauriano Junior

Author Archives: Sergio Lauriano Junior

Avatar photo
Sergio is graduated in Software Development in the University City of São Paulo (UNICID). During his career, he get involved in a large number of projects such as telecommunications, billing, data processing, health and financial services. Currently, he works in financial area using mainly Java and IBM technologies.

Loops in Python

set python

In this article, we’re going to learn how to work with loops in Python. 1. Introduction In all programming languages, loops are used to control the flow of or application. Sometimes, we use loops to iterate a list or a collection of data. Python provides some types of loops to handle our data structures during the execution of the software. ...

Read More »

Python import Example

set python

1. Introduction Programming languages have a lot of features that improve our code making it stable and reusable, speeding up the development of the application. Python uses the import statement to make use of other modules into our code that can be accessed throughout the implementation of our solution. In the next step, we’re going to see the different kinds ...

Read More »

Install Python on Mac OS

set python

In this article, we’re going to install Python on Mac OS using the software pyenv. Also, we’ll see some configurations to set our Python version and run an example. 1. Introduction 1.1 Pre-requisites For this article, it’s recommended to install the package manager Homebrew. It’s an open-source package management system that makes simpler the installation of software on a macOS ...

Read More »

Download and Install SQL Server Management Studio

Bipartite Graph

In this article, we’re going to the steps to download and install the Microsoft SQL Server Management Studio (SSMS). 1. SSMS System Requirements SQL Server Management Studio (SSMS) is a powerful application maintained and distributed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. The application was first launched with Microsoft SQL Server 2005 ...

Read More »

How to Learn Python for Data Science

set python

In this article, we’re going to discuss Data Science with Python. The way to start your studies, the necessary stuff, and why you should learn Python. 1. Why Learn Python For Data Science? I’m a big fan of the phrase “all knowledge is valid”. That means, everything you study can bring something to add to your life as well to ...

Read More »

How to Download and Install MySQL

Bipartite Graph

In this article, we’re going to see how to download and install MySQL using the default installer. Also, we’ll set up the server using the auto start package and do some examples. 1. Download MySQL Installer As Linux/macOS-based system user, I commonly use a package manager like Home Brew and APT in the terminal to install software that I need. ...

Read More »

SQL SUBSTRING Function

Bipartite Graph

In this article, we’re going to explain the SUBSTRING function in SQL. 1. Introduction The SUBSTRING function is available in SQL Server (from 2008 edition) and MySQL (from version 4.0) as a part of String functions. Using this function we’re able to manipulate strings directly with a SQL query. Also, in combination with other functions and procedures, the SUBSTRING function ...

Read More »

SQL is null – SQL is not null

Bipartite Graph

In this article, we’re going to see how to test null values in an SQL database. 1. What is a NULL Value? Basically, a field with a NULL value in a SQL table is a field without value. When creating a table, we can mark a column that accepts null values when inserting data into the table. A null value ...

Read More »

SQL Server Versions

Bipartite Graph

In this article, we’re going to see several Microsoft SQL Server versions and editions and how to identify them. 1. Introduction On MSSQL Server we need to determine the version and edition to troubleshoot some issues or to know if feature support is available. To do that, MSSQL Server introduces some procedures to identify the version and edition which we’re ...

Read More »

Java Runtime Environment Tutorial

Bipartite Graph

In this article, we’re going to discuss Java Runtime Environment, the bundle used to run Java applications and libraries. 1. What is a runtime environment? The runtime environment is the environment in which a program or application is executed. As soon as a software program is executed, it is in a runtime state. Java Runtime Environment (JRE) is the software ...

Read More »