Learn SQL


  • WatchMySQL Database Tutorial - 1 - Introduction to Databases
  • WatchMySQL Database Tutorial - 2 - Getting a MySQL Server
  • WatchMySQL Database Tutorial - 3 - Creating a Database
  • WatchMySQL Database Tutorial - 4 - SHOW and SELECT
  • WatchMySQL Database Tutorial - 5 - Basic Rules for SQL Statements
  • WatchMySQL Database Tutorial - 6 - Getting Multiple Columns
  • WatchMySQL Database Tutorial - 7 - DISTINCT and LIMIT
  • WatchMySQL Database Tutorial - 8 - Sorting Results
  • WatchMySQL Database Tutorial - 9 - Sort Direction
  • WatchMySQL Database Tutorial - 10 - Basic Data Filtering and WHERE
  • WatchMySQL Database Tutorial - 11 - Advanced Filtering Using AND and OR
  • WatchMySQL Database Tutorial - 12 - Are you IN or are you NOT IN?
  • WatchMySQL Database Tutorial - 13 - How Search Engines Work
  • WatchMySQL Database Tutorial - 14 - More on Wildcards
  • WatchMySQL Database Tutorial - 15 - Regular Expressions
  • WatchMySQL Database Tutorial - 16 - Creating Custom Columns
  • WatchMySQL Database Tutorial - 17 - Functions
  • WatchMySQL Database Tutorial - 18 - More on Aggregate Functions
  • WatchMySQL Database Tutorial - 19 - GROUP BY
  • WatchMySQL Database Tutorial - 20 - Subqueries
  • WatchMySQL Database Tutorial - 21 - Another Subquery Example
  • WatchMySQL Database Tutorial - 22 - How to Join Tables
  • WatchMySQL Database Tutorial - 23 - Outer Joins
  • WatchMySQL Database Tutorial - 24 - UNION
  • WatchMySQL Database Tutorial - 25 - Full-Text Searching
  • WatchMySQL Database Tutorial - 26 - INSERT INTO
  • WatchMySQL Database Tutorial - 27 - How to Insert Multiple Rows
  • WatchMySQL Database Tutorial - 28 - UPDATE & DELETE
  • WatchMySQL Database Tutorial - 29 - CREATE TABLE
  • WatchMySQL Database Tutorial - 30 - NOT NULL & AUTO INCREMENT
  • WatchMySQL Database Tutorial - 31 - ALTER / DROP / RENAME TABLE
  • WatchMySQL Database Tutorial - 32 - Views
  • WatchMySQL Database Tutorial - 33 - Final Video!

square is a database computer language designed for the retrieval and control of data in a relational database. square stands for structured query language. this academic will provide you with a quick start to square. it covers maximum of the subjects required for a primary expertise of square and to get a feel of the way it really works.
Audience
this educational is ready for beginners to help them recognize the simple in addition to the superior standards related to square languages. this tutorial will give you enough information on the numerous components of square at the side of suitable examples.
conditions
earlier than you start practicing with numerous kinds of examples given in this tutorial, i’m assuming that you are already aware about what a database is, specifically the rdbms and what is a laptop programming language.
collect/execute square programs
in case you are inclined to assemble and execute sq. applications with oracle 11g rdbms however you don’t have a setup for the same, do not worry. coding floor is available on a excessive-stop dedicated server providing you with actual programming revel in. it’s far free and is available on-line for every person.


Tags Cloud