Home
Videos uploaded by user “The Bad Tutorials”
SQL Tutorial - 27: The DISTINCT Keyword
 
02:31
In this tutorial we'll see how we can pull out unique data from tables using the DISTINCT Clause in our Queries.
Views: 49191 The Bad Tutorials
Shell Scripting Tutorial-13: Cut Through Your Files
 
06:09
In this tutorial you'll learn to use the 'cut' command to extract data from your text files. Official Facebook Page: http://www.facebook.com/TheBadTutorials
Views: 113702 The Bad Tutorials
SQL Tutorial - 28: Aliasing Through AS Clause
 
02:31
In this tutorial we'll see how we can change the display names of fields in result sets.
Views: 38193 The Bad Tutorials
SQL Tutorial - 48: Views in SQL (Part-1)
 
05:35
In this tutorial we'll learn to create views in SQL using the CREATE VIEW command.
Views: 43689 The Bad Tutorials
Shell Scripting Tutorial-45: The Internal Field Separator
 
05:43
In this tutorial we'll try to understand the significance of IFS by seeing its impact on the behavior of the 'set' command.
Views: 33678 The Bad Tutorials
Shell Scripting Tutorial-60: Create Your Own Commands Using Functions
 
04:26
In this tutorial you'll learn to create your own commands using functions.
Views: 31859 The Bad Tutorials
Python Programming Tutorial - 40: Updating Global Variables
 
02:43
In this tutorial we'll see how we can update global variables in python using the 'global' keyword from within functions.
Views: 19341 The Bad Tutorials
SQL Tutorial - 41: SUBSTR(), RIGHT() & LEFT() Functions
 
04:34
In this tutorial we'll see how we can chop off strings and use only parts of them using the SUBSTR(), RIGHT() and LEFT() Functions.
Views: 34317 The Bad Tutorials
Shell Scripting Tutorial-11: Count Lines, Words & Characters Using 'wc'
 
05:59
In this tutorial you'll learn to execute the 'file' command to see contents of folders, and also to count the number of lines, words and characters in text files using 'wc'. Official Facebook Page: http://www.facebook.com/TheBadTutorials
Views: 124618 The Bad Tutorials
SQL Tutorial - 22: The DELETE Query
 
04:07
In this tutorial we'll see in action the DELETE Query which is used to remove records from a table in the database.
Views: 49304 The Bad Tutorials
Python Programming Tutorial - 11: Membership & Identity Operators
 
05:41
In this tutorial we'll see how we can use the 'IN' membership operator to see if a value is present in a string or a list and how we can use the 'IS' identity operator to see if two variables have the same value as well as the same data type.
Views: 30808 The Bad Tutorials
Shell Scripting Tutorial-6: Rename & Delete Files & Directories
 
04:37
In this tutorial you'll learn to rename files using 'mv' command and you'll also learn to delete files and directories using 'rm' and 'rmdir' Official Facebook Page: http://www.facebook.com/TheBadTutorials
Views: 151970 The Bad Tutorials
Python Programming Tutorial - 1: Installing Python
 
06:07
Welcome! In this tutorial we'll see how we can install the python interpreter on Windows and we'll also discuss some cool and important features of Python.
Views: 229581 The Bad Tutorials
Shell Scripting Tutorial-59: Communicate with other users using 'write'
 
04:27
In this tutorial you'll learn to send messages to other users on your system using the 'write' command. You'll also learn to use 'finger' command to see which users who have disabled message reception and which have not.
Views: 24951 The Bad Tutorials
C Programming Tutorial-6: Receive Input from Users Using scanf()
 
03:33
In this tutorial we'll learn to accept input from users in C programs. Just as we use the printf() function to display content on the screen (the default output device), we use the scanf() function to receive input through the keyboard (the default input device). Thank you for watching!
Views: 19621 The Bad Tutorials
Shell Scripting Tutorial-10: Change File Permissions Using 'chmod'
 
04:50
In this tutorial you'll learn to change file permissions using 'chmod'. You'll understand the significance of permissions for directories and you'll also learn to use 'uname' to view information about your system. Official Facebook Page: http://www.facebook.com/TheBadTutorials
Views: 112646 The Bad Tutorials
Shell Scripting Tutorial-39: The 'while' Loop
 
05:36
In this tutorial we'll learn to use the while loop to display ten numbers on screen. The 'while' loop is my favorite loop and I am sure you will be able to appreciate it's usefulness as well as we move along.
Views: 54307 The Bad Tutorials
Shell Scripting Tutorial-7: Create Copies, Links to Files & Directories
 
05:36
In this tutorial you'll learn to create copies of files and directories using 'cp' and also to create soft and hard links to files using 'ln' command. Official Facebook Page: http://www.facebook.com/TheBadTutorials
Views: 146456 The Bad Tutorials
SQL Tutorial - 43: REPEAT() & REPLACE() Functions
 
02:25
In this tutorial we'll learn to repeat a string a few times and also replace a part or all of a string with another string using the REPEAT and REPLACE Functions respectively.
Views: 22716 The Bad Tutorials
Shell Scripting Tutorial-4: Create Files & Directories
 
05:27
Official Facebook Page: http://www.facebook.com/TheBadTutorials In this tutorial you'll learn to use 'touch' and 'mkdir' to create files and directories respectively. You'll also learn to use 'cd' to change your working directory in the terminal.
Views: 215459 The Bad Tutorials
Perl Tutorial - 8: Slicing Arrays
 
03:27
Thanks for watching! Check out my other tutorials at: https://www.youtube.com/user/madhurbhatia89?feature=guide
Views: 16777 The Bad Tutorials
Python Programming Tutorial - 19: The Break Statement
 
03:35
In this tutorial we'll see how we can get out of a loop prematurely using the break statement.
Views: 28438 The Bad Tutorials
SQL Tutorial - 40: The TRIM() Function
 
02:32
In this tutorial we'll see how we can remove leading and trailing spaces from strings using the TRIM() function.
Views: 27054 The Bad Tutorials
SQL Tutorial - 31: Left Outer JOIN
 
03:41
In this tutorial we'll take a look at the LEFT Outer JOIN and see how it is different from the regular JOIN
Views: 38483 The Bad Tutorials
C Programming Tutorial - 39: Nested Loops
 
07:31
In this tutorial we'll learn to use nested loops. Nested loops are loops within loops. We'll learn to use to loops to print the following pattern-: * ** *** **** ***** Thanks for watching!
Views: 67333 The Bad Tutorials
SQL Tutorial - 29: SQL JOINS
 
07:54
In this tutorial we'll take a look at SQL JOINS and see how we can pull data from two tables through a single query!
Views: 109551 The Bad Tutorials
Shell Scripting Tutorial-40: The 'until' Loop
 
04:39
In this tutorial you'll lean to use the until loop which I like to refer as while's baby brother. Though I always choose while whenever I have to make a choice between while and until, until has it's own advantages and at times you will find yourself using it over while for convenience sake. So, make a not of it's syntax and you'll be good to proceed.
Views: 38298 The Bad Tutorials
C Programming Tutorial - 13: Associativity of Operators
 
05:13
In this tutorial we'll see how C resolves conflicts between operators that enjoy the same priority.
Views: 10854 The Bad Tutorials
Perl Tutorial - 1: Introduction, Installation, First Script!
 
07:51
Thanks for watching! Check out my other tutorials at: https://www.youtube.com/user/madhurbhatia89?feature=guide
Views: 107654 The Bad Tutorials
Shell Scripting Tutorial-5: Text Files: Create, Merge & Play
 
04:19
Official Facebook Page: http://www.facebook.com/TheBadTutorials In this tutorial you will learn to create text files through the terminal using the 'cat' command. 'cat' is an extremely important command and we'll be using it a lot in the course. I have discussed a few applications of the command here, will be checking it out again in future.
Views: 183522 The Bad Tutorials
SQL Tutorial - 14: The SELECT Query
 
03:22
In this tutorial we'll talk about the SELECT Statement in SQL that is used to pull data from tables in a database.
Views: 93778 The Bad Tutorials
Shell Scripting Tutorial-3: View System Date, Calender
 
05:41
Official Facebook Page: http://www.facebook.com/TheBadTutorials Next in the series: http://youtu.be/0csDVuBloIQ 'cal' and 'date' are handy utilities to check out system date and time and also to view dates from past and future. Try running 'cal' for September 1752, you'll be amazed to see the output.
Views: 261253 The Bad Tutorials
Python Programming Tutorial - 29: List Functions (Part-1)
 
03:37
In this tutorial we'll check out a bunch of list functions.
Views: 17294 The Bad Tutorials
SQL Tutorial - 55: The ALTER TABLE Command
 
05:30
In this tutorial we'll see how we can modify the structure of a table through the ALTER TABLE command in SQL. The command allows us to add, drop or modify fields in a table. Thanks for watching!
Views: 77518 The Bad Tutorials
C Programming Tutorial - 79: Running C Programs in Linux Environment
 
05:01
In this tutorial we'll learn to execute a very simple C Program on Ubuntu.
Views: 62016 The Bad Tutorials
Shell Scripting Tutorial-19: Positional Parameters
 
07:19
In this tutorial you'll learn to use command line arguments in your scripts through positional parameters.
Views: 114843 The Bad Tutorials
C Programming Tutorial - 70: Pointers to Structures
 
05:04
This is going to be the final tutorial on Structures in this course and in this one we'll see how we can store the address of a Structure variable in a pointer and then use the pointer to access the members of the structure owned by the structure variable.
Views: 44683 The Bad Tutorials
SQL Tutorial - 39: UPPER() and LOWER() Functions
 
02:52
In this tutorial we'll learn to display characters in upper case or lower case using the UPPER and LOWER functions.
Views: 23629 The Bad Tutorials
Shell Scripting Tutorial-14: Convert & Copy Files With 'dd'
 
05:26
'dd' can be used to change case of characters in a text file, to change the character encoding in text files and for a lot more cool things. In this tutorial you'll learn to use it.
Views: 101752 The Bad Tutorials
SQL Tutorial - 25: The ORDER BY Clause
 
04:45
The ORDER BY Clause is used to sort data obtained from a table through a SELECT Query. In this tutorial we'll check out simple applications of the ORDER BY Clause.
Views: 64332 The Bad Tutorials
Shell Scripting Tutorial-42: Rant & Little Work
 
05:36
Link to Tutorial-30: http://www.youtube.com/watch?v=YhtHm9gyMxE In this tutorial you'll learn to use the '=' operator while comparing two floats. The -eq operator does a good job with integers but it doesn't quite work with real numbers. Thanks for watching!
Views: 33712 The Bad Tutorials
Perl Tutorial - 13: Hashes
 
04:12
Thanks for watching! Check out my other tutorials at: https://www.youtube.com/user/madhurbhatia89?feature=guide
Views: 15910 The Bad Tutorials
SQL Tutorial - 19: The WHERE Clause
 
04:09
In this tutorial we'll talk about the WHERE Clause in SQL and check out how we can include conditions in our SQL Queries using the WHERE Clause.
Views: 54387 The Bad Tutorials
C Programming Tutorial - 41: The Continue Statement
 
04:16
In this tutorial we are going to have a look at the continue statement and see how it's different from break.
Views: 8010 The Bad Tutorials
Shell Scripting Tutorial-16: Hello World!
 
05:21
In this tutorial you'll learn to create and execute a shell script. You'll learn to include comments in script files and display "Hello World" in the terminal using the 'echo' command.
Views: 115908 The Bad Tutorials
Python Programming Tutorial - 52: Sending Email
 
04:19
In this tutorial we'll learn to connect with the Gmail SMTP Server and send a mail through an account I created for this tutorial.
Views: 39021 The Bad Tutorials
SQL Tutorial - 5: Create, Use and Drop Databases
 
05:06
In this tutorial we'll check out three very simple SQL Commands to create, use and drop Databases.
Views: 125830 The Bad Tutorials
Shell Scripting Tutorial-43: Search Patterns Using 'grep'
 
06:19
In this tutorial you'll learn to use 'grep' to find patterns in text files. 'grep' is a really important command and I am surprised why I didn't discuss it earlier in the course. Anyway, I hope you guys like the tutorial. We have forty three tutorials in the course and still there is so much more to discuss. That attests to my slow speed and shell's power and extent. I'll try to pick some speed and make the course more interesting for us all. Thanks for watching! See you in the next tutorial.
Views: 52367 The Bad Tutorials
Shell Scripting Tutorial-9: See What's In Using 'ls'
 
06:57
In this tutorial you'll learn to use 'ls' command to see contents of directories. 'ls' is a very powerful utility and comes with more than a dozen options, we'll discuss it in even greater detail in later parts of the course. Official Facebook Page: http://www.facebook.com/TheBadTutorials
Views: 120600 The Bad Tutorials
SQL Tutorial - 51: Aggregate Functions (Part-1)
 
04:48
In this tutorial we'll learn to use the COUNT, MAX & MIN aggregate functions to determine the number of records returned in a result set, the maximum value of a field and the least value of a field respectively.
Views: 22976 The Bad Tutorials