Diploma in MySQL

0 STUDENTS ENROLLED

    Mode Of Examination

    Online Examination

    Number Of Question: 100 (1 Marks Each)

    Total Time: 120 Min

    Syllabus

    General MySQL Use:

    Database terminology, mysql setup and interactions.

    Using SQL to Manage Data:

    Server sql mode, mysql identifiers and rules, sql statements case sensitivity, selecting, creating, dropping and altering databases, table retrievals with joins, union and subqueries, views, transactions, foreign key, table creation, populating and modifying tables.

    Data Types:

    Data value categories, datatypes, sequences and type conversions.

    Stored Programs:

    Compound statements, stored functions, triggers, events and security.

    Query Optimization:

    Indexing, query optimizer, choosing and loading data types, scheduling and locking issues, administrative level optimizations, query mechanics and clauses.

    MySQL Programming:

    Mysql programs and apis.

    MySQL Programs Using C:

    Compiling and linking client programs, server connection, error handling, processing sql statements, embedded server library, multiple statement execution.

    MySQL Programs Using Perl DBI and PHP:

    Perl script characteristics, perl dbi and php overviews.

    MySQL Administration:

    Mysql components and administration, access control and security, database maintenance, backups and replication.

    MySQL Data Directory:

    Location, structure and relocating data directory’s.

    General MySQL Administration:

    Mysql installation and server startup, managing mysql user accounts, maintaining logs, server tuning, storage engine configuration, running multiple servers, internationalization and localization issues.

    Access Control and Security:

    Secure connections, internal and external security.

    Database Maintenance, Backups and Replication:

    Preventive maintenance principles, database backups, checking and repairing database tables, backups for data recovery and replication servers setting.

    Data Type Reference, Operators and Functions:

    Numeric, string and spatial data types, operators and functions.

    System, Status and User Variables:

    System and session only system variables, status and user defined variables.

    SQL Syntax:

    Sql statement syntax, compound statement and comment syntax.

    Select Statement:

    Select clauses, from clauses, order by clauses, where clauses, group by and having clause.

    Nulls and Conditions and Miscellaneous:

    Database copies, secure connections, conditional evaluation, null and condition types.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    X