This video comprehends the terms Python which is to develop by Guido van Rossum. Guido van Rossum started implementing Python in 1989. Python is a very simple programming language so even if you are new to programming, you can learn python without facing any issues.

This topic will cover, Installing Python which is generally easy, and nowadays many Linux and UNIX distributions include a recent Python. Even some Windows computers now come with Python already installed.

In this Python tutorial, we will learn about Python variables and data types which is being used in Python. We will also learn about converting one data type to another in Python and local and global variables in Python. So, let’s begin with Python variables and data types Tutorial.

In this topic you will learn about the data type which is an important concept. Variables can store data of different types, and different types can do different things.

This session will teach you about the Python defines type conversion functions to directly convert one data type to another which is useful in day to day and competitive programming. This article is aimed at providing information about certain conversion functions.

In this tutorial, you will learn about the keywords which is the reserved words in Python and identifiers names given to variables, functions, etc. We cannot use a keyword as a variable name, function name or any other identifier. They are used to define the syntax and structure of the Python language.

In this tutorial, we are going to learn how to take multiple inputs from the user in Python. The data entered by the user will be in the string format. So, we can use the split method to divide the user entered data.

This tutorial focuses on two built in functions print and input to perform Input and Output task in Python. Also, you will learn to import modules and use them in your program. Some of the functions like input and print are widely used for standard input and output operations respectively. Let us see the output section first.

This tutorial covers the different types of operators in Python, operator overloading, precedence and associativity. Just like in mathematics, programming languages like Python have operators. You can think of them as extremely simple functions that lie at the basis of computer science.

In this tutorial, you'll learn everything about different types of operators in Python, their syntax and how to use them with examples. Operators are special symbols in Python that carry out arithmetic or the logical computation. The value that the operator operates on is called the operand.

Previously, in our tutorial on Python Operators., Today, in this Python Bitwise Operators Tutorial, we will discuss Python Bitwise AND, OR, XOR, Left-shift, Right-shift, and 1’s complement Bitwise Operators in Python Programming. Along with this, we will discuss syntax and example of Python Bitwise Operators.

Today, we talk about Python decision making constructs. This includes Python if statements, if else statements, elif statement, nested if conditions and single statement conditions. We will understand these with syntax and example to get a clear understanding. So, let’s start the Python Decision Making Tutorial.

In this session you will learn about the if elif else which are conditional statements that provide you with the decision making that is required when you want to execute code based on a particular condition. The if elif else statement used in Python helps automate that decision making process.

In this session, you'll learn the different variations of for loop, for loop is used for iterating over a sequence that is either a list, a tuple, a dictionary, a set, or a string. This is less like the for keyword in other programming languages, and works more like an iterator method as found in other object-orientated programming languages.

In this session, you will learn to create a while loop in Python. Loops are used in programming to repeat a specific block of code. In this article, you will learn to create a while loop in Python. Loops are used in programming to repeat a specific block of code.

In this session, we show how to create an infinite loop in Python. An infinite loop that never ends it never breaks out of the loop. So, whatever is in the loop gets executed forever, unless the program is terminated. For certain situations, an infinite loop may be necessary.

In this video, you will learn how to make the computer execute a group of statements over and over if certain criterion holds. The group of statements being executed repeatedly is called a loop.

In this session, you'll learn about the different numbers used in Python, how to convert from one data type to the other, and the mathematical operations supported in Python. Python supports integers, floats and complex numbers.

In the tutorial on strings in Python, you learned how to define strings objects that contain sequences of character data. Processing character data is integral to programming. It is a rare application that doesn’t need to manipulate strings at least to some extent.

As discussed in the above tutorial, strings in Python are immutable and thus updating or deleting an individual character in a string is not allowed, which means that changing a particular character in a string is not supported in Python. Although, the whole string can be updated and deleted.

In this session, we'll learn everything about Python lists, how they are created, slicing of a list, adding or removing elements from them and so on. The list is a most versatile datatype available in Python which can be written as a list of comma-separated values items between square brackets. Important thing about a list is that items in a list need not be of the same type.

In this tutorial, learn how to update list element using Python. Use the index position and assign the new element to change any element of List. You can change the element of the list or item of the list with the methods given here.

In that tutorial of Python Functions, we discussed user-defined functions in Python. But that isn’t all, a list of Python built-in functions that we can toy around with. In this tutorial on Built-in functions in Python, we will see each of those, we have 67 of those in Python 3.6 with their Python Syntax and examples.

In this tutorial, you'll learn everything about Python tuples. More specifically, what are tuples, how to create them, when to use them and various methods you should be familiar with. A tuple in Python is similar to a list. The difference between the two is that we cannot change the elements of a tuple once it is assigned whereas we can change the elements of a list.

This session teaches you the tuple in Python which are immutable sequences, you cannot update them. You cannot add, change, remove items (elements) in tuples.Tuple represent data that you don't need to update, so you should use list rather than tuple if you need to update it. However, if you really need to update tuple, you can convert it to list, update it, and then turn it back into tuple.

In this tutorial, you'll learn everything about Python dictionaries how they are created, accessing, adding, removing elements from them and various built in methods. Python dictionary is an unordered collection of items. Each item of a dictionary has a pair. Dictionaries are optimized to retrieve values when the key is known.

In this session we will teach you the dictionary which is a data type similar to arrays, but works with keys and values instead of indexes. Each value stored in a dictionary can be accessed using a key, which is any type of object a string, a number, a list, etc. instead of using its index to address it.

In this session we will teach you the Python for beginners training course which is a lead the students from the basics of writing and running Python scripts to more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting.

In this video, you will learn to manipulate date and time in Python with the help of examples. Python has a module named datetime to work with dates and times. Let's create a few simple programs related to date and time before we dig deeper.

In this session, you'll learn about functions, what a function is, the syntax, components, and types of functions. Also, you'll learn to create a function in Python. In Python, a function is a group of related statements that performs a specific task. Functions help break our program into smaller and modular chunks.

In this video we will learn, the function which use the same variable and object. Pass by Value. In pass by value the function is provided with a copy of the argument object passed to it by the caller. That means the original object stays intact and all changes made are to a copy of the same and stored at different memory locations.

In this tutorial, you'll learn about the anonymous function, also known as lambda functions. You'll learn what they are, their syntax and how to use them with examples.

In this tutorial we will teach you the module which is a piece of software that has a specific functionality. Like, when building a ping pong game, one module would be responsible for the game logic, and another module would be responsible for drawing the game on the screen. Each module is a different file, which can be edited separately.

This session teaches you the Python rename method which is used to rename a file or directory. This method is a part of the python module and comes extremely handy.

In this tutorial, you'll learn about Python file operations. More specifically, opening a file, reading from it, writing into it, closing it, and various file methods that you should be aware of.

In this tutorial we will learn about program for files in Python which provides us with an important feature for reading data from the file and writing data into a file. Mostly, in programming languages, all the values or data are stored in some variables which are volatile in nature.

In this session we will tell you the method that you the current position within the file; in other words, the next read or write will occur at that many bytes from the beginning of the file. The seek method changes the current file position.

In this tutorial, you'll learn how to handle exceptions in your Python program using try, except and finally statements with the help of examples. Python has many built-in exceptions that are raised when your program encounters an error (something in the program goes wrong).

In this tutorial, you will learn about different types of errors and exceptions that are built-in to Python. They are raised whenever the Python interpreter encounters errors.

In this video we will teach you about the Exception handling in Python which is very similar to Java. The code, which harbors the risk of an exception, is embedded in a try block.

In this tutorial, you will learn about the core functionality of Python objects and classes. You'll learn what a class is, how to create it and use it in your program.

In this session you will learn about the programming in Python (object-oriented programming) for some time, then you have definitely come across methods that have self as their first parameter. Let us first try to understand what this recurring self-parameter is.

This tutorial teaches you about the regular expression which is a special sequence of characters that helps you match or find other strings or sets of strings, using a specialized syntax held in a pattern. Regular expressions are widely used in UNIX world.

In this tutorial we will learn about the python search which is a method of the module That is Syntax of search () re. search (pattern, string). It is similar to re. match () but it doesn’t limit us to find matches at the beginning of the string only. Unlike in re. match () method, here searching for pattern ‘Tutorials’ in the string ‘TP Tutorials Point TP’ will return a match.

This workshop will introduce GUI programming in Python, it is a is a popular language for elementary programming but it not so easy to write programs with a graphical user interface (GUI).

In this tutorial, we will learn how to develop graphical user interfaces by writing some Python GUI examples using the Tkinter package. Tkinter package is shipped with Python as a standard package, so we don’t need to install anything to use it.

This session teaches you about the frame widgets which is a rectangular region on the screen. The frame widget is mainly used as a geometry master for other widgets, or to provide padding between other widgets.

Lecture 1.1 - Introduction to Microsoft SQL Server

Lecture 1.2 - Introduction to Microsoft SQL Server

Lecture 1.3 - Introduction to Microsoft SQL Server

Lecture 2.1 - Select and Where

Lecture 2.2 - Select and Where

Lecture 2.3 - Select and Where

Lecture 3.1 - SQL Sub Languages - Order By Clauses

Lecture 3.2 - SQL Sub Languages - Order By Clauses

Lecture 4.1 - Any - All - Select Into - Insert Into - Case

Lecture 4.2 - Any - All - Select Into - Insert Into - Case

Lecture 5.1 - Delete - Top - Aggregate Functions - Wild Cards

Lecture 5.2 - Delete - Top - Aggregate Functions - Wild Cards

Lecture 6.1 - Insert - Update - Is Null Commands

Lecture 6.2 - Insert - Update - Is Null Commands

Lecture 6.3 - Insert - Update - Is Null Commands

Lecture 7.1 - In - Between - Table Alias

Lecture 7.2 - In - Between - Table Alias

Lecture 8.1 - SQL Comments - SQL Operators

Lecture 8.2 - SQL Comments - SQL Operators

Lecture 9.1 - Joins

Lecture 9.2 - Joins

Lecture 10.1 - Union All - Union - Group By - Having - Exists - Not Exists

Lecture 10.2 - Union All - Union - Group By - Having - Exists - Not Exists

Lecture 11.1 - Null Functions - Transact SQL

Lecture 11.2 - Null Functions - Transact SQL

Lecture 12.1 - Examples - If - Conditional Statements

Lecture 12.2 - Examples - If - Conditional Statements

Lecture 13.1 - Goto Statement - Looping Construct

Lecture 13.2 - Goto Statement - Looping Construct

Lecture 14.1 - Sub Programs - Stored Procedures

Lecture 14.2 - Sub Programs - Stored Procedures

Lecture 15.1 - Stored Procedure Examples

Lecture 15.2 - Stored Procedure Examples

Lecture 16.1 - Modifying and Dropping a Stored Procedure

Lecture 16.2 - Modifying and Dropping a Stored Procedure

Lecture 17.1 - Dynamic Queries - Procedure Returning Values - Functions

Lecture 17.2 - Dynamic Queries - Procedure Returning Values - Functions

Lecture 18.1 - Break - Continue - Exception Handling

Lecture 18.2 - Break - Continue - Exception Handling

Lecture 19.1 - Structured Exception Handling

Lecture 19.2 - Structured Exception Handling

Lecture 20.1 - Multiple and Nested Try Catch Blocks

Lecture 20.2 - Multiple and Nested Try Catch Blocks

Lecture 21.1 - Using Anonymous Block - Table Valued Functions

Lecture 21.2 - Using Anonymous Block - Table Valued Functions

Lecture 22.1 - Backup DB - Differential Example - DDL Statements

Lecture 22.2 - Backup DB - Differential Example - DDL Statements

Lecture 23.1 - User Defined DB - Creating DB with GUI - Query - Commands

Lecture 23.2 - User Defined DB - Creating DB with GUI - Query - Commands

Lecture 24.1 - Database Constraints and Domain Integrity Constraints

Lecture 24.2 - Database Constraints and Domain Integrity Constraints

Lecture 25.1 - Primary Key and Composite Key

Lecture 25.2 - Primary Key and Composite Key

Lecture 26.1 - Creating 1-to-1 Relationship - Indexes

Lecture 26.2 - Creating 1-to-1 Relationship - Indexes

Lecture 27.1 - Views and Types of Views

Lecture 27.2 - Views and Types of Views

Lecture 28.1 - Auto Increment - SQL Date Operations

Lecture 28.2 - Auto Increment - SQL Date Operations

Lecture 29 - Hosting