DEV Community: Daniel Karanja

strings in Python

Daniel Karanja — Sat, 27 May 2023 13:22:04 +0000

In Python, strings are a fundamental data type used to represent and manipulate text data. They are sequences of characters enclosed within single quotes (' '), double quotes (" "), or triple quotes (""" """).

Creating a String:
To create a string, simply assign a sequence of characters to a variable. For example:

message = "Hello, World!"

In this case, the variable message holds the string "Hello, World!".

String Manipulation:

Python provides a wide range of built-in functions and methods to manipulate strings. Here are some commonly used operations:

Accessing Characters:
You can access individual characters within a string using indexing. Python uses 0-based indexing, where the first character is at index 0. For example:

message = "Hello, World!"
print(message[0])  # Output: 'H'

String Length:

To determine the length of a string, you can use the len() function:

message = "Hello, World!"
print(len(message))  # Output: 13

String Concatenation:

To combine or concatenate strings, you can use the + operator:

greeting = "Hello"
name = "Alice"
message = greeting + ", " + name
print(message)  # Output: "Hello, Alice"

String Slicing:

You can extract a portion of a string using slicing. Slicing allows you to specify a range of indices to extract a substring. For example:

message = "Hello, World!"
print(message[7:12])  # Output: "World"

String Methods:

Python provides several useful string methods for various operations. Some common methods include:
lower(): Converts a string to lowercase.
upper(): Converts a string to uppercase.
strip(): Removes leading and trailing whitespace from a string.
replace(): Replaces occurrences of a substring with another substring.
split(): Splits a string into a list of substrings based on a delimiter.

Conclusion:
Strings are a versatile and powerful data type in Python that allow you to manipulate and process textual data. By leveraging the various built-in functions and methods available, you can perform a wide range of operations on strings, such as accessing characters, concatenating, slicing, and applying transformations

Basic Introduction to SQL

Daniel Karanja — Fri, 26 May 2023 21:01:42 +0000

MySQL is a widely recognized, freely available, and open-source database application that is highly regarded for its exceptional performance, user-friendly interface, and robust data security measures. As a result, it has become a preferred choice for many seeking a reliable database solution.
This comprehensive guide will walk you through the process of creating tables in MySQL, as well as inserting data into them. Additionally, you will learn about various techniques for querying the data stored within these tables.

*Step 1:Creating a database *

1. Create a database using the CREATE statement:
  CREATE DATABASE movies;
2. To verify that the database was created use the SHOW statement;
  SHOW DATABASES;
3. Select the database to make changes to it by using the USE statement:
 USE movies;

Step 2

Step 3: Create a Table
We’ll create a table containing information about movies:
CREATE TABLE movies(title VARCHAR(50) NOT NULL,genre VARCHAR(30) NOT NULL,director VARCHAR(60) NOT NULL,release_year INT NOT NULL,PRIMARY KEY(title));

- Verify that the table is created using the DESCRIBE command:
DESCRIBE movies;

Insert movie information in column order – title, genre, director, and release year. Use the INSERT command:
INSERT INTO movies VALUE ("Fast and furious X", "action", "Justin Lin", 2023);

- Use the SELECT command to display the table:
   SELECT * FROM movies;

Step 3: Create a view
Views are SQL queries that display data based on defined parameters.

Create a view named minimum_release_year to display movie titles whose release year is after 1990. Use the CREATE VIEW command and define query parameters:

CREATE VIEW minimum_release_year AS SELECT title FROM movies WHERE release_year > 2002;

Display the view using the SELECT command: SELECT * FROM minimum_release_year; The output displays movies released after the year 2002.

New journey begins......

Daniel Karanja — Mon, 24 Apr 2023 13:00:40 +0000

I've been longing to write about how I got into the tech industry. I'm an undergraduate studying business computing, in essence. My career path was rather different because I originally intended to study mechanical engineering but decided against it in favor of a business major so that I could, as they say, "enjoy campus life."
During my final year of college, I developed a love for technology. I even began going to tech-related events and learning for myself through w3school and codecademy.

I eventually lost self-pace control and made the decision to look for a boot camp where I could genuinely collaborate with other peers.I got a partial scholarship to attend Moringa School to study the vanilla programming languages of Python and JavaScript as well as the React.js library and Flask framework.

I will provide updates on my experience in addition to thorough information on the resources I believe are helping me.Follow along......