Warning: mysql_connect(): Can't connect to MySQL server on 'netsoftgyan.db.11670554.hostedresource.com' (111) in /home/netsoftg/public_html/classes/DB.class.php on line 15

Warning: mysql_select_db(): Access denied for user 'netsoftg'@'localhost' (using password: NO) in /home/netsoftg/public_html/classes/DB.class.php on line 16

Warning: mysql_select_db(): A link to the server could not be established in /home/netsoftg/public_html/classes/DB.class.php on line 16
 
Enquiry

NSG Certified SQL Writer


SQL (pronounced “ess-que-el”) stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system.

However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database. This course will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.

The following are the concepts covered in this course;


  • Introduction to SQL
  • Syntax
  • Select
  • Distinct
  • Where
  • And/Or
  • Order by
  • Insert
  • Update
  • Delete
  • Injection
  • Select Top
  • Like
  • Wildcard
  • In
  • Between
  • Joins
  • Create DB
  • Create Table
  • Constraints
  • Not Null
  • Unique
  • Primary
  • Foreign Key
  • SQL Functions like
    • Avg()
    • Count()
    • First()
    • Last()
    • Max()
    • Min()
    • Sum()
    • Group By ()
    • Having ()
    • UCase()
    • LCase()


Duration: 30hrs
Employment Options: SQL Developer


Testimonial


Warning: mysql_query(): Access denied for user 'netsoftg'@'localhost' (using password: NO) in /home/netsoftg/public_html/classes/UserTools.class.php on line 92

Warning: mysql_query(): A link to the server could not be established in /home/netsoftg/public_html/classes/UserTools.class.php on line 92

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/netsoftg/public_html/classes/UserTools.class.php on line 92

Warning: mysql_query(): Access denied for user 'netsoftg'@'localhost' (using password: NO) in /home/netsoftg/public_html/classes/UserTools.class.php on line 103

Warning: mysql_query(): A link to the server could not be established in /home/netsoftg/public_html/classes/UserTools.class.php on line 103

Latest News


    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/netsoftg/public_html/include/news.php on line 15

Our Gallery