If your interested in learning SQL programming. I have a tutorial on Youtube for FREE! In the tutorial I go through the basics all in one video, so you get started quickly. I explain how to create a database, how to create a table and how to insert values in the columns. If you are … Continue reading FREE SQL Training!
Today, I want to talk about Indexes. What is an Index in SQL? An index is to find something in a database much faster. When you think about an index at a library using a catalog, it uses an index to find a book faster. You can also search for a particular topic using an … Continue reading SQL: What is an Index?
SQL: Using JOINS in SQL Server JOINS Introduction What is a JOIN? JOINS in SQL Server are used to retrieve data from two of more related tables. Tables are generally related by foreign key restraints. We will discuss the different types of JOINS: INNER JOIN OUTER JOIN FULL JOIN CROSS JOIN OUTER JOINS are … Continue reading SQL: Using JOINS in SQL Server
SQL: Using the LIKE Operator LIKE Introduction LIKE is a special operator just for strings LIKE will match strings with a pattern Wildcard Character % Introduction You can use the % Wildcard character with LIKE % Wildcard character can go anywhere in the string The percent sign % wildcard character matches any sequence … Continue reading SQL: Using the LIKE Operator
AND Introduction AND means that two expressions by AND must evaluate to TRUE Example: Who are all the people in my contact list that have the first name Jon and have a birthday later than 1965? SELECT p.person_first_name FROM person p WHERE p.person_first_name = ‘Jon’ AND p.birthday > 12/31/1965; OR Introduction … Continue reading SQL: Using AND and OR
Where Clause Introduction The WHERE clause consists of the keyword WHERE followed by a search condition that specifies the rows to be retrieved. The WHERE clause is like a search The body of the WHERE clause will be a set of expressions that can evaluate TRUE OR FALSE TRUE or FALSE is called … Continue reading SQL: WHERE Clause
These are some of the common statements in SQL. We store data for a reason and it might be important for us to use later. It can be important to our business or us personally. Querying is all about asking questions We can pretend that another human knows everything and has it stored in … Continue reading SQL: Using SELECT and FROM Clause
What is SQL? SQL stands for Stuctured Query Language. It is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). However, in this article I will introduce what is SQL, what are some … Continue reading Introduction to SQL Programming