- Pune: +91 82 82 82 9806
Advanced SQL Primer
Course Name : Advanced SQL Primer
Batch Schedule : 05-Jun-2021 To 20-Jun-2021
Schedule : Weekends (Sat & Sun)
Duration : 6 Days
Timings : 09:00 AM To 12:00 PM
Fees : Rs. 3000/- (Inc. 18% GST)
- Students
- Fresher's
- Working Professionals
- Getting Started With SQL (Recorded Session for Early bird offer only)
- RDBMS introduction
- SQL overview
- MySQL data types
- CREATE TABLE
- ALTER TABLE
- INSERT operations
- UPDATE operations
- DELETE operations
- SQL SELECT Common Operations (Recorded Session for Early bird offer only)
- ORDER BY, LIMIT clause
- GROUP BY, HAVING clause
- RDBMS Permissions (Recorded Session for Early bird offer only)
- Concept
- CREATE USER operation
- GRANT permissions
- REVOKE permissions
- RDBMS Constraints (Recorded Session for Early bird offer only)
- Primary key constraint
- Foreign key constraint
- Unique constraint
- NOT NULL constraint
- CHECK constraint
- SQL Functions (Recorded Session for Early bird offer only)
- 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
- Understaning of RDBMS concepts.
- Basic SQL commands( Register for early bird offer, to learn basics from Recorded sessions.)
- Fundamental Concepts - RDBMS, SQL concepts, and simple CRUD queries.
- Early Bird Offer- Enroll before 22 May and get Free access to Video Recording of Fundamental Concepts.
- 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)
- SQL performance tuning is a highly database specific topic and this course covers only primary aspects of performance using MySQL database.
- Conceptual topics like Codd’s rules and Normalization are not covered in this course.
- 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.
- 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.
- MySQL 8.x Server
- MySQL 8.x CLI client or Workbench or PHPMyAdmin
| Sr.No | Batch Code | Start Date | End Date | Time |
|---|---|---|---|---|
| 1 | ASP-O-01 | 05-Jun-2021 | 20-Jun-2021 | 09:00 AM To 12:00 PM |
Schedule : Weekends (Sat & Sun)
Contact us
Sunbeam Market Yard Pune
'Sunbeam Chambers', Plot No.R/2, Market Yard Road, Behind Hotel Fulora, Gultekdi, Pune - 411 037. MH-INDIA.
+91 82 82 82 9806
Sunbeam Hinjawadi Pune
"Sunbeam IT Park", Second Floor, Phase 2 of Rajiv Gandhi Infotech Park,Hinjawadi, Pune - 411057, MH-INDIA
+91 82 82 82 9806