infyni

SQL Crash Course

SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database

Live Course

Duration: 14 Hours

Enrolled: 0

Offered by: infyni

(2)

Live Course
$75 60% off

$30

Coming Soon Notify Me

About Course

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 shall 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.

Skills You Will Gain

Pl/SQL Programming SQL Data Types DML DDL SQL Conditional Loops Cursor Stored Procedure Functions

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of completion
  • Employability opportunity
  • Topics
  • Instructor (2)
  • Reviews
  • Introduce you to PL/SQL programming language and its architecture
  • SQL data types – give you a brief overview of PL/SQL data types including number, Boolean, character, and datetime
  • SQL variables – introduce you to PL/SQL variables
  • SELECT
  • SELECT DISTINCT
  • ORDER BY
  • WHERE
  • AND
  • OR
  • IN
  • BETWEEN
  • LIKE
  • LIMIT
  • IS NULL
  • Table & Column Aliases
  • INNER JOIN, LEFT JOIN, RIGHT JOIN, Self Join, CROSS JOIN
  • GROUP BY
  • HAVING
  • ROLLUP
  • Subquery
  • Derived Tables
  • EXISTS, UNION, MINUS, INTERSECT
  • INSERT
  • INSERT INTO SELECT
  • Insert On Duplicate Key Update
  • INSERT IGNORE
  • UPDATE
  • UPDATE JOIN
  • DELETE
  • DELETE JOIN
  • ON DELETE CASCADE
  • REPLACE
  • Selecting Database
  • CREATE DATABASE
  • Managing Databases
  • Data Types
  • CREATE TABLE
  • Primary Key
  • Foreign Key
  • UNIQUE Constraint
  • CHECK Constraint
  • NOT NULL
  • Sequence
  • ALTER TABLE
  • ADD COLUMN
  • DROP COLUMN RENAME TABLE
  • DROP TABLE
  • Temporary Tables
  • TRUNCATE TABLE
  • IF statements – introduce you various IF statement to either execute or skip a sequence of statements based on a condition
  • CASE statements – learn how to choose one sequence of statements out of many possible sequences to execute.
  • Basic LOOP statement – show you how to use the basic LOOP statement to execute a sequence of code multiple times
  • SQL Exception – show you how to deal with SQL exceptions such as declaring a user-defined exception, raising an exception and handling it.
  • SELECT INTO – learn how to fetch a single row from a table into variables
  • Cursor – introduce you to cursors including implicit and explicit cursors and shows you how to use them
  • SQL procedure – a step-by-step guide to create, compile and execute a procedure
  • SQL function – show you how to develop a PL/SQL function and explain you various ways to call a function.

(2)

SQL Crash Course students also learn