• Mail us!

    info@uriahtraining.com
  • Call us today!

    +91 7619683761
  • We are open!

    Mon-Sun 7:00-21:00

SQL SERVER

Course Info

  • Category: IT Program
  • TRAINER: MR.ASHUTOSH
  • Duration: 2 Months.
  • Share Course:

SQL SERVER Course

MySQL (officially pronounced as "My S-Q-L", is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.

MySQL is a central component of the LAMP open-source web application software stack (and other "LAMP" stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, Simple Machines Forum, phpBB, MyBB, and Drupal. MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), Facebook, Twitter,Flickrt.

MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyzer. MySQL works on many system platforms, including AIX, BSDi, FreeBSD, HP-UX, eComStation, i5/OS, IRIX, Linux, macOS, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO Open Server, SCO UnixWare, Sanos and Tru64. A port of MySQL to OpenVMS also exists. The MySQL server software itself and the client libraries use dual-licensing distribution. They are offered under GPL version 2, beginning from 28 June 2000 (which in 2009 has been extended with a FLOSS License Exception or to use a proprietary license. Support can be obtained from the official manual. Free support additionally is available in different IRC channels and forums. Oracle offers paid support via its MySQL Enterprise products. They differ in the scope of services and in price. Additionally, a number of third party organisations exist to provide support and services, including MariaDB and Percona.

MySQL has received positive reviews, and reviewers noticed it "performs extremely well in the average case" and that the "developer interfaces are there, and the documentation (not to mention feedback in the real world via Web sites and the like) is very, very good" It has also been tested to be a "fast, stable and true multi-user, multi-threaded sql database server".

OVERVIEW:

Lesson 1: Introduction to SQL
Lesson 2: Retrieving Data
Lesson 3: Updating Data
Lesson 4: Inserting Data
Lesson 5: Deleting Data
Lesson 6: Sorting and Filtering Data
Lesson 7: Advanced Filtering
Lesson 8: Summarizing Data
Lesson 9: Grouping Data
Lesson 10: Using Subqueries
Lesson 11: Joining Tables
Lesson 12: Managing Tables
Lesson 13: Using Views
Lesson 14: Stored Procedures
Lesson 15: Using Cursors
Lesson 16: Using Transactions

Advanced MySQL course

Stored procedures

• Creating stored procedures
• Executing stored procedures
• System stored procedures

Variables

• Declaring variables
• SET versus SELECT
• Tricks with variables
• So-called global variables

Parameters and return values

• Passing parameters
• Default values / WHERE clauses
• Output parameters
• Using RETURN

Scalar functions

• What they are
• Writing user-defined functions
• Worked examples
• Pros and cons of scalar functions

Testing conditions

• IF / ELSE statement
• Using CASE where possible

Looping

• Syntax of WHILE
• Breaking out of a loop

Error-handling

• Using TRY / CATCH
• System error functions
• Custom error messages

Deleting using SQL

• Ways to drop tables
• DELETE versus TRUNCATE

Updating data in SQL

• The UPDATE statement
• Updating using joins

Inserting data

• Making tables (SELECT INTO)
• Appending data (INSERT INTO)
• Inserting individual rows

Creating tables

• Creating tables in SQL
• Primary keys and indexes
• Adding relationships

Transactions

• Beginning a transaction
• Committing / rolling back

Temporary tables and table variables

• Scope (local versus global)
• Using temporary tables
• Creating table variables
• Pros and cons of each approach

Table-valued functions

• In-line table-valued functions
• Mult-statement table-valued functions

Derived tables and CTEs

• Using derived tables
• Common Table Expressions (CTEs)
• Multiple CTEs in a single query

Cursors (*)

• Syntax of fetching rows
• Why not to use cursors!

Debugging

• Debugging queries and procedures
• Setting breakpoints

Dynamic SQL (*)

• Building up dynamic SQL
• Executing dynamic SQL
• Disadvantages of dynamic SQL

Pivots (*)

• Assembling data for pivoting
• Using PIVOT
• Dynamic column headers

Triggers (*)

• Insert, update and delete triggers
• Using the generated table INSERTED
• Using INSTEAD OF