https://upr.ac.id/wp-content/uploads/

slot gacor

https://event.unsia.ac.id/wp-content/uploads/

slot gacor

https://disdikbud.pemkomedan.go.id/.well-known/

slot maxwin

https://inspire.unsrat.ac.id/manajerial/uploads/bantuan_dana/

https://www.dekopinda.sumbawakab.go.id/assets/images/

situs slot gacor

https://simanis.lamongankab.go.id/js/

https://ebphtb.gresikkab.go.id/public/slthai/

https://dev-bomobile.cititrans.co.id/uploads/

https://ejournals.itda.ac.id/cache/

http://pdk.unand.ac.id/media/

https://tpp.padangpanjang.go.id/s-thai/

https://web-desa.muaraenimkab.go.id/go/gacor/

https://web-desa.muaraenimkab.go.id/go/rtp/

https://web-desa.muaraenimkab.go.id/go/thailand/

https://sipdatadik.probolinggokab.go.id/js/

https://facesofwarsaw.com/

http://esptpd.kaimanakab.go.id/public/img/

http://elibrary.pipmakassar.ac.id/assets/slot777/

http://bpprd.bungokab.go.id:8087/maxwin/

https://simanis.lamongankab.go.id/jurnal/

https://elsa.lamongankab.go.id/jurnal/

https://poltekkespangkalpinang.ac.id/media/

https://beasiswa.ika.pcr.ac.id/jurnal/

http://elibrary.pipmakassar.ac.id/assets/js/

https://e-office.balangankab.go.id/laravel/laravel/public/jurnal/

https://e-office.balangankab.go.id/laravel/laravel/public/media/

https://e-office.balangankab.go.id/laravel/laravel/public/document/

https://e-remun.poltekbangsby.ac.id/thai/

https://simpeg.unnur.ac.id/jurnal/

https://elsa.lamongankab.go.id/library/

https://simpeg.unnur.ac.id/document/

https://simpeg.unnur.ac.id/media/

https://palito.padangpanjang.go.id/jurnal/

https://tes-umkm.padangpanjang.go.id/jurnal/

slot thailand

https://camatbarat.padangpanjang.go.id/jurnal/

https://ejournal.staindirundeng.ac.id/jurnal/

https://ejournal.staindirundeng.ac.id/s777/

http://103.169.238.243:8071/image/

situs slot gacor

https://eplanning.pemkomedan.go.id/eperencanaan/web/assets/smaxwin/

https://disdikbud.pemkomedan.go.id/media/

slot thailand

https://ejournal.staindirundeng.ac.id/library/

https://silari.pa-ngawi.go.id/document/

slot thailand

https://sipdatadik.probolinggokab.go.id/document/

https://silari.pa-ngawi.go.id/media/

https://silajara.kepulauanselayarkab.go.id/jurnal/

https://rameezmukhtarqureshi.com/

https://dinamis.bkpsdm.ciamiskab.go.id/jurnal/

https://e-presensi.muaraenimkab.go.id/uploads/jurnal/

slot thailand

https://sipdatadik.probolinggokab.go.id/uploads/pagcor/

https://tegal.pramukajateng.or.id/sthai/

slot thailand

https://karanganyar.pramukajateng.or.id/wp-content/srver-thai/

slot thailand

https://e-presensi.muaraenimkab.go.id/file/s777/

https://easn.sumutprov.go.id/api/maxwin/

depo 5k

https://simanis.lamongankab.go.id/assets/media/

https://dpuair.jatimprov.go.id/asset/link/

slot777

https://bbppt.postel.go.id/kalibrasi/core/

https://simonik.demakkab.go.id/public/thai/

https://sidona.bengkulutengahkab.go.id/sgacor/

https://easn.sumutprov.go.id/jurnal/

http://logbook.poltekkes-medan.ac.id/media/zgacor/

https://keuangan.sulselprov.go.id/jurnal/

slot thailand

http://103.169.238.243:8071/image/

https://tpp.padangpanjang.go.id/xgacor/

slot gacor

https://siap-adpim.kalbarprov.go.id/wp-content/upgrade/

https://jdih.pekalongankota.go.id/thai/

https://sirapi.kalteng.go.id/thai/

https://pupr.tulangbawangkab.go.id/thai/

slot thailand

slot gacor

https://lms.unmas.ac.id/Thailand/

slot gacor

slot gacor

http://catalog.poltekkesjogja.ac.id/gacor2024/

http://catalog.poltekkesjogja.ac.id/sgacor/

https://sipinter.babelprov.go.id/sigacor/

slot gacor

https://e-sakip.situbondokab.go.id/thai/

https://rsud.sumbawakab.go.id/maxwin/

https://easn.sumutprov.go.id/demo/

https://silk.semarangkota.go.id/vendor/sthai/

ugasli

https://simpeg.kendalkab.go.id/efile/storage/app/link-gacor/

https://perdagangan.tulangbawangkab.go.id/s777/

https://krs.dinus.ac.id/assets/link-gacor/

https://rekrutmen.bkpsdm.banggaikep.go.id/js/

https://krs.dinus.ac.id/assets/sigacor/

https://cedc.ulm.ac.id/id/wp-content/thai/

https://pakesiska.perhubungan.jatengprov.go.id/situs-thailand/

slot thailand

slot gacor

https://bppkad.magetan.go.id/upgacor/

https://simpeg.dinus.ac.id/updir/xgacor/

https://www.info.sumbawakab.go.id/bingo/link/

https://silk.semarangkota.go.id/packages/tugumuda/

https://lsp.ulm.ac.id/wp-content/slthai/

slot pulsa

betingslot

https://sidona.bengkulutengahkab.go.id/sthai/

https://skd.salatiga.go.id/statis/slothai/

https://cedc.ulm.ac.id/id/wp-content/

https://skd.salatiga.go.id/statis/slothai/

https://siap-adpim.kalbarprov.go.id/wp-includes/assets/

https://kermadn.unisba.ac.id/wp-content/uploads/

https://pdk.unand.ac.id/templates/

https://distani.tulangbawangkab.go.id/assets/

https://siapja.maroskab.go.id/stthailand/

slot777

https://simpatda.bppkad.kedirikota.go.id/data/

https://inspektorat.kuansing.go.id/document/

https://gresikcab.dindik.jatimprov.go.id/gacor/

slot gacor hari ini

SQL & PL/SQL Course in Pune -Technogeeks -Trainwick

Course Detail

SQL & PL/SQL Course

SQL & PL/SQL Course - Technogeeks


Course Detail


Course Description

SQL & PL/SQL Course / Training Content

Module: 01 Introduction to SQL and Installation

      • What is SQL
      • Need of SQL
      • RDBMS (Relational Database Management System) Significance
      • Difference between SQL and file storage
      • Benefits of SQL storage
      • How to use command line interface
      • How to use IDE (Integrated Development Environment)
      • How to start writing query as beginner

Module: 02 DDL (Data Definitions Language) Commands and Start SQL as Beginner Level

      • Create database
      • Data Types
      • Create Table
      • Delete database
      • Alter database
      • Constraints and Types of Constraints
      • Introduction to View
      • Differentiate between Table and View
      • Need of Normalization
      • Normalization Implementation

Module: 03 DML (Data Manipulation Language) and TCL (Transaction control language) Commands

      • Insert command and applications
      • Delete command and applications
      • Update command and applications
      • Commit and rollback
      • Bulk insert
      • Bulk update
      • Specific record insert operation
      • Specific record update operation
      • Specific record delete operation
      • Differentiate between delete, drop and truncate
      • Usage of where clause
      • Usage of different type of operators

Module: 04 Frequently used Operates and Clauses in SQL

      • Insert – As- Select Statement
      • Select Statement
      • Select with Sorting
      • Select with where clause
      • Wildcard
      • CASE Expression and usage

Module: 05 Joins and multi table handling

      • How to create relationship between multiple tables using primary-key and foreign key relation
      • Self-Join Inner to retrieve data from tables
      • Join Left to retrieve data from tables
      • Join Right to retrieve data from tables
      • Join Cross Join to retrieve data from tables

Module: 06 Functions usage in SQL and frequently used Clauses

      • Data type specific functions in SQL
      • Generic functions in SQL
      • Build-in functions in SQL
      • Group by clause
      • Having clause
      • Order by clause
      • Logical Functions
      • Aggregate Functions
      • String Functions
      • Date Functions
      • Logical Functions

Module: 07 Advance SQL (PL/SQL)

      • Need of PL (Procedural Language)
      • Benefits of PL
      • Procedural Language and SQL Integration
      • Need of Stored Procedure
      • Need of Functions
      • Differentiate between Function and Stored Procedure
      • Need of Triggers
      • Types of Triggers
      • How to create Triggers
      • How to execute Stored Procedures with parameters

Module: 08 Real time best practices in Project

    • Common query writing standards in Projects
    • Naming standards
    • Code review strategy
    • Real time nested query examples
    • Query optimization and importance in project
    • Performance Tuning and importance in Project
    • Project build on SQL and PL/SQL.

Institute Overview

Pune, Maharashtra, India

Our Story Technogeeks is a Group of IT working professionals, located in Pune. Technogeeks Trainers are working on real-time projects on multiple technologies and always believe to share the knowledge and best practices to help the candidates to bui... Read More

Related Courses

Google Map