Terima kasih telah mengirimkan pertanyaan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Terima kasih telah mengirimkan pemesanan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Kerangka Materi
Sistem Pengelolaan Basis Data Relasional (RDBMS)
Operator Relasional
SQL sebagai Bahasa Deklaratif
Sintaks SQL
Bahasa Pendukung SQL: DQL, DML, DDL, DCL
Rincian DQL (Data Query Language)
- Klausa SELECT
- Alias kolom
- Alias tabel
- Tipe tanggal dan fungsi tanggal
- Fungsi kelompok
- Penyambungan tabel
- Klausa JOIN
- Operator UNION
- Query bersarang
- Subquery terkait
Pandangan Umum DML (Data Manipulation Language)
- Menambahkan baris (INSERT)
- Menambahkan baris menggunakan subquery
- Memperbarui baris (UPDATE)
- Menghapus baris (DELETE)
Pandangan Umum DDL (Data Definition Language)
- Membuat, memodifikasi dan menghapus objek (CREATE, ALTER, DROP)
- Membuat tabel menggunakan subquery (CREATE TABLE .... AS SELECT...)
Pandangan Umum CONSTRAINTS
- NULL atau tidak NULL
- Klausa CONSTRAINT
- Tipe ENUM
- Tipe SET
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- Klausa DEFAULT
Pandangan Umum Transaksi
- COMMIT
- ROLLBACK
- SAVEPOINT
- Pengembalian dan penyimpanan implisit dan eksplisit
Pandangan Umum Dialek SQL
- MySQL
- Microsoft Access dan SQL Server
- Oracle dan PostgreSQL
Persyaratan
Keterampilan dasar komputer.
14 Jam
Testimoni (7)
Mempelajari hal-hal baru dan mengembangkan diri dengan pengetahuan
Todor - MYPOS TECHNOLOGIES
Kursus - SQL Fundamentals
Diterjemahkan Mesin
I like this training because it was interactive
Amalia - Banca Transilvania
Kursus - SQL Fundamentals
He had a lot of patience with all the students.
Cristina
Kursus - SQL Fundamentals
I like the exercise part.It was exactly as a course should be.
Larisa
Kursus - SQL Fundamentals
His attitude, the way he teaches, very easy to understand and it's so enjoyable having him as a trainer!
Raluca Voicu
Kursus - SQL Fundamentals
the way he explained, I finally understood certain functions that I didn't understand even in college
Adriana
Kursus - SQL Fundamentals
The trainer respected the timetable of the course, had good time management and responded to all the questions addressed by the participants. He explained topics that were not in the curriculum, but were relevant to the subject.
