Chứng chỉ SQL

INTRODUCTION TO SQL AND SQL DATABASE SERVER

LESSON 1:

– An overview of SQL language
– SQL language
– Examples of simple programs

LESSON 2:

Introduction to SELECT statement
– WHERE, FROM commands
– BETWEEN, IN commands

LESSON 3:

Continuation of SELECT statement
– LIKE, DISTINCT commands
– DISTINCT commands

LESSON 4:

Continuation of SELECT statement
– COUNT, MAX, MIN Functions
– AVG, VARIANCE, STDDEV functions

LESSON 5:

Introduction to updating tables, joining tables
– INSERT, UPDATE, DELETE Statement
– JOIN Statement

LESSON 6:

Introduction to CREATE TABLE. Review
– CREATE TABLE Statement
– Materials review

JAVA I (WITH EMPHASIS ON JDBC)

LESSON 1:

Introduction to Classes and Objects, Inheritance, Interfaces for Java
– Classes and Objects
– Inheritance, Interfaces and Software Architecture

LESSON 2:

Introduction to Exception Handling, Stream and Files, Applets
– Exception Handling, Stream and Files
– Applets, Utility Classes

LESSON 3:

Introduction to AWT, Swing
– AWT
– Swing

LESSON 4:

Introduction to STP, .NET and J2EE Application Frameworks, Web Services Security
– STP, .NET and J2EE Application Frameworks
– Web Services Security

LESSON 5:

Introduction to Multithreading, Collections
– Multithreading
– Collections (Data Structures)

LESSON 6:

Introduction to Security. Review, practice writing complex programs
– Networking, Security
– Material review

SQL DATABASE ADMINISTRATION (DBA I)

LESSON 1:

Introduction to Database Administration
– Database Administration
– SQL Architecture

LESSON 2:

Introduction to SQL Installations
– General Installation
– Component Installation

LESSON 3:

Introduction to SQL Database Maintenance
– Configurations
– Tuning

LESSON 4:

Continuation of SQL Database Maintenance
– Database Optimizations
– Configuring systems and SQL

LESSON 5:

Introduction to Prevention of Data loss
– Backups
– Database Recovery

LESSON 6:

Introduction to SQL Networking. Review, practice complex Database performance
– SQL Networking
– Material

SQL DATABASE ADMINISTRATION (DBA II)

LESSON 1:

Introduction to SQL Networking
– SQL Networking
– SQL Network Administration

LESSON 2:

Introduction to Security and Monitoring in SQL
– Security
– Monitoring

LESSON 3:

Introduction to Auditing in SQL
– AUDIT Statement
– AUDIT Statement (Continuation)

LESSON 4:

Introduction to Query Optimizations
– All kinds of Queries
– Combining Queries

LESSON 5:

Introduction to Enterprise Java Beans (EJB)
– EJB Architectures
– EJB, JDBC and SQL

LESSON 6:

Introduction to applications of SQL Architecture in E-commerce. Review, practice complex programs
– E-commerce architecture and SQL
– Material review