SQL Certification


  • WatchSQL Tutorial - 1: Introduction
  • WatchSQL Tutorial - 2: Installing MySQL
  • WatchSQL Tutorial - 3: MySQL Workbench and Command Line Client
  • WatchSQL Tutorial - 4: Things You Need To Know About Tables
  • WatchSQL Tutorial - 5: Create, Use and Drop Databases
  • WatchSQL Tutorial - 6: Data-Types in SQL (Part-1)
  • WatchSQL Tutorial - 7: Data-Types in SQL (Part-2)
  • WatchSQL Tutorial - 8: Constraints in SQL
  • WatchSQL Tutorial - 9: Create Table Statement
  • WatchSQL Tutorial - 10: Creating Tables from Other Tables
  • WatchSQL Tutorial - 11: Removing Tables from Database
  • WatchSQL Tutorial - 12: Inserting Data Into Tables
  • WatchSQL Tutorial - 13: Inserting Data Into a Table From Another Table
  • WatchSQL Tutorial - 14: The SELECT Query
  • WatchSQL Tutorial - 15: Arithmetic Operators
  • WatchSQL Tutorial- 16: Comparison Operators
  • WatchSQL Tutorial - 17: Logical Operators (Part-1)
  • WatchSQL Tutorial - 18: Logical Operators (Part-2)
  • WatchSQL Tutorial - 19: The WHERE Clause
  • WatchSQL Tutorial - 20: AND & OR Operators
  • WatchSQL Tutorial - 21: The UPDATE Query
  • WatchSQL Tutorial - 22: The DELETE Query
  • WatchSQL Tutorial - 23: The LIKE Operator and Wildcard Characters
  • WatchSQL Tutorial - 24: The TOP and LIMIT Clauses
  • WatchSQL Tutorial - 25: The ORDER BY Clause
  • WatchSQL Tutorial - 26: The GROUP BY Clause
  • WatchSQL Tutorial - 27: The DISTINCT Keyword
  • WatchSQL Tutorial - 28: Aliasing Through AS Clause
  • WatchSQL Tutorial - 29: SQL JOINS
  • WatchSQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS
  • WatchSQL Tutorial - 31: Left Outer JOIN
  • WatchSQL Tutorial - 32: Right Outer JOIN
  • WatchSQL Tutorial - 33: ABS() Function
  • WatchSQL Tutorial - 34: ROUND() Function
  • WatchSQL Tutorial - 35: DIV() & MOD() Functions
  • WatchSQL Tutorial - 36: Useful Numeric Functions Part-1
  • WatchSQL Tutorial - 37: Useful Numeric Functions Part-2
  • WatchSQL Tutorial - 38: The CONCAT() Function
  • WatchSQL Tutorial - 39: UPPER() and LOWER() Functions
  • WatchSQL Tutorial - 40: The TRIM() Function
  • WatchSQL Tutorial - 41: SUBSTR(), RIGHT() & LEFT() Functions
  • WatchSQL Tutorial - 42: The LENGTH() & INSERT() Functions
  • WatchSQL Tutorial - 43: REPEAT() & REPLACE() Functions
  • WatchSQL Tutorial - 44: REVERSE() & STRCMP() Functions
  • WatchSQL Tutorial - 45: Date & Time Functions (Part-1)
  • WatchSQL Tutorial - 46: Date & Time Functions (Part-2)
  • WatchSQL Tutorial - 47: Date & Time Functions (Part-3)
  • WatchSQL Tutorial - 48: Views in SQL (Part-1)
  • WatchSQL Tutorial - 49: Views in SQL (Part-2)
  • WatchSQL Tutorial - 50: Views in SQL (Part-3)

necessities
certainly no programming enjoy is required to grasp the content material in this direction
description
get prepared to accumulate a few severely marketable programming capabilities! you cannot keep in mind yourself a entire stop to end developer till you could code in square. these days, facts has turn out to be the hottest subject matter in technology and a agency’s biggest asset is their records. all databases require the language sq. to save and retrieve records. salaries for junior stage sq. developers are upwards of $70,000 – $90,000 bucks a 12 months! the superb element is, for this route, you do now not need any previous revel in in programming what so ever. square is a special animal and we are going to demystify the language from scratch and prepare you with masses of step by step difficult assignments in order that by the time you have finished the route (in 2 months), you can name your self an oracle sq. master! oracle is the maximum popular relational database in the world! this course will put together you to be activity-geared up in only 1 month of take a look at and exercise.
all physical activities and solutions are within the lectures. in several lectures i ask college students to pause the video and entire the task earlier than resuming to look at my answer. make certain you figure out the problems for your own before transferring directly to my answer!!
who is the audience?
everybody inclined to get into the software improvement profession
every body willing to grasp square and get a activity as a well paid oracle square developer
all people willing to work difficult in studying the sq. language