- Hinjawadi Pune: +91 7410071951 / 7410071952 / 9881208115
- Karad: +91 9561213447 / 9881208114
Advanced SQL Primer
Course Name : Advanced SQL Primer
Schedule : Weekdays (Mon-Sat)
Duration : 5 Days
Fees : Rs. Rs. 2000/-
- Students
- Fresher's
- Working Professionals
- 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
- Understaning of RDBMS concepts.
- Basic SQL commands.
- Get access to recorded videos for free.
- 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.
- 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
Coming soon...
Contact us
Sunbeam Hinjawadi Pune
Authorized Training Center of C-DAC
"Sunbeam IT Park", Ground Floor, Phase 2 of Rajiv Gandhi Infotech Park, Hinjawadi, Pune - 411057, MH-INDIA
+91 7410 071 951 / 7410 071 952
Sunbeam Karad
Authorized Training Center of C-DAC
'Anuda Chambers', 203 Shaniwar Peth, Near Gujar Hospital, Karad - 415 110, Dist. Satara, MH-INDIA.
02164 - 225500 / 225800