•   Pune: +91 82 82 82 9805
  • Karad: +91 82 82 82 9806 / 02164-225500, 225800

Advanced SQL Primer

Course Name : Advanced SQL Primer

Schedule : weekends (Sat & Sun)

Duration : 6 Days

Fees : Rs. Rs. 3000/- (Inc.18% GST)

  • Students
  • Fresher's
  • Working Professionals
Click to Register
  • Getting Started With SQL (recorded session)
    • RDBMS introduction
    • SQL overview
    • MySQL data types
    • CREATE TABLE
    • ALTER TABLE
    • INSERT operations
    • UPDATE operations
    • DELETE operations
  • SQL SELECT Common Operations (recorded session)
    • ORDER BY, LIMIT clause
    • GROUP BY, HAVING clause
  • RDBMS Permissions (recorded session)
    • Concept
    • CREATE USER operation
    • GRANT permissions
    • REVOKE permissions
  • RDBMS Constraints (recorded session)
    • Primary key constraint
    • Foreign key constraint
    • Unique constraint
    • NOT NULL constraint
    • CHECK constraint
  • SQL Functions (recorded session)
    • Single row functions
    • Group functions
    • Handling NULL values
  • RDBMS Transactions
    • Concept
    • ACID properties
    • SAVEPOINT
    • COMMIT & ROLLBACK
    • Table locking
    • Row locking
    • Optimistic vs Pessimistic locking
  • SQL Joins
    • Inner join
    • Left & Right outer join
    • Self join
    • Joining multiple tables
  • SQL Sub-queries
    • Single row sub-query
    • Multi row sub-query
    • Correlated sub-query
    • Sub-query performance
  • RDBMS Indexes
    • Simple index
    • Composite index
    • Unique index
  • RDBMS Views
    • Simple views
    • Complex views
    • Views with CHECK constraint
  • SQL Windowing Functions
    • Windowing concept
    • PARTITION BY & ORDER BY Window
    • SUM(), COUNT(), AVG(), ...
    • ROW_NUMBER(), RANK() & DENSE_RANK()
    • LEAD(), LAG(), FIRST_VALUE() & LAST_VALUE()
  • SQL Common Table Expressions
    • Derived tables
    • CTE concept
    • WITH clause
    • Recursive CTE
    • CTE vs Derived tables
Click to Register
  • Understaning of RDBMS concepts.
  • Basic SQL commands.
  • Get access to recorded videos for free.
Click to Register
  • Even though this course covers SQL queries in MySQL database, as per ANSI standard they should work well in any leading RDBMS like Oracle or MS-SQL server.
  • This course covers the foundations of SQL required for any data-warehousing or big data framework (like Apache Hive, Apache Drill)
  • Due to the time limit this course doesn’t include very fundamental concepts like RDBMS, SQL concepts, and simple CRUD queries. However free recorded sessions are available*.
  • This course doesn't cover concepts of database administration, distributed/cluster database, (custom) database development and database connectivity from various languages.
  • PL/SQL or PSM (i.e. stored procedure, function, triggers) is beyond the scope of this course.
  • Conceptual topics like Codd’s rules and Normalization are covered in this course.
  • SQL performance tuning is a highly database specific topic and this course covers only primary aspects of performance using MySQL database.
Click to Register
  • Solid understanding of SQL essentials like. Grouping, joins, sub-queries and indexes.
  • Gain confidence in Advanced SQL like Windowing functions, Common table expressions.
  • Learn about SQL transactions, table/row locking and query performance tuning.
Click to Register
  • MySQL 8.x Server
  • MySQL 8.x CLI client or Workbench or PHPMyAdmin
Click to Register
Click to Register

Contact us

Sunbeam Hinjawadi Pune

Authorized Training Centre of C-DAC ACTS

"Sunbeam IT Park", Ground Floor, Phase 2 of Rajiv Gandhi Infotech Park, Hinjawadi, Pune - 411057, MH-INDIA

+91 82 82 82 9805 / +91 82 82 82 9806
Sunbeam Karad

Authorized Training Centre of C-DAC ACTS

'Anuda Chambers', 203 Shaniwar Peth, Near Gujar Hospital, Karad - 415 110,     Dist. Satara, MH-INDIA.

+91 82 82 82 9806 / 02164 - 225500 , 225800