SQL CERTIFICATE
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