Linux System Programming, Data Management and MySQL

Project based Career Oriented Training

Software Design Development and Debugging

Module 5: Linux System Programming, Data Management, MySQL

Abstract:

Linux System programming is all about programming computer system software ising C on Linux. The primary distinguishing characteristic of systems programming when compared to application programming is that application programming aims to produce software which provides services to the user directly, whereas systems programming aims to produce software and software platforms which provide services to application software, are performance constrained, or both. it also covers data management using terminals and interfaces using curses. Database query is also used extinsively using MySQL.

Training Content:

01.Working with Files in Linux
- Linux File Structure
  - Directories, Files and Devices, System Calls and Device Drivers, Library Functions
- Low-Level File Access
  - write, read, open, Initial Permissions, Other System Calls for Managing Files
- The Standard I/O Library
  - fopen, read, fwrite, fclose, fflush, fseek, fgetc, getc, and getchar, fputc, putc, and putchar, fgets and gets
- Formatted Input and Output
  - printf, fprintf, and sprintf,scanf, fscanf, and sscanf, Other Stream Functions, Stream Errors, Streams and File Descriptors
- File and Directory Maintenance
  - chmod, chown, unlink, link, and symlink, mkdir and rmdir, chdir and getcwd
- Scanning Directories
  - opendir, readdir, telldir, seekdir, closedir
- Errors
  - strerror, perror
- The /proc File System
  - Advanced Topics: fcntl and mmap, fcntl, mmap
02.Linux Environment
- Program Arguments
  - getopt, getopt_long
- Environment Variables
  - Use of Environment Variables, The environ Variable
- Time and Date
- Temporary Files
- User Information
- Host Information
- Logging
- Resources and Limits
03.Terminals
- Reading from and Writing to the Terminal
- Talking to the Terminal
- The Terminal Driver and the General Terminal Interface
  - Overview, Hardware Model, The termios Structure, Input Modes, Output Modes, Control Modes, Local Modes, , Special Control Characters, Terminal Speed, Additional Functions
- Terminal Output
  - Terminal Type, Identify Your Terminal Type, Using terminfo Capabilities
- Detecting Keystrokes
  - Virtual Consoles, Pseudo-Terminals
04.Screens and Curses
- Compiling with curses
- Curses Terminology and Concepts
- The Screen
  - Output to the Screen, Reading from the Screen, Clearing the Screen, Moving the Cursor, Character Attributes
- The Keyboard
  - Keyboard Modes, Keyboard Input
- Windows
  - The WINDOW Structure, Generalized Functions, Moving and Updating a Window, Optimizing Screen Refreshes
- Subwindows
- The Keypad
- Using Color
  - Redefining Colors
- Pads
- An Application Development
  - Introduction to The Application, Looking at main, Building the Menu, Database File Manipulation, Querying the CD Database
05.Data Management
- Managing Memory
  - Simple Memory Allocation, Allocating Lots of Memory, Abusing Memory, The Null Pointer, Freeing Memory, Other Memory Allocation Functions
- File Locking
  - Creating Lock Files, Locking Regions, Use of read and write with Locking, Competing Locks, Other Lock Commands, Deadlocks
- Databases
  - The dbm Database, The dbm Routines, dbm Access Functions, Additional dbm Functions
- An Application
  - Updating the Design, The Database Application Using dbm
06.MySQL
- Installation
  - MySQL Packages, Post-Install Configuration, Post-Installation Troubleshooting
- MySQL Administration
  - Commands, Creating Users and Giving Them Permissions, Passwords, Creating a Database, Data Types, Creating a Table, Graphical Tools
- Accessing MySQL Data from C
  - Connection Routines, Error Handling, Executing SQL Statements, Miscellaneous Functions
- A Database Application
  - Creating the Tables, Adding Some Data, Accessing the Application Data from C

Other Modules in SDDD Training are as follows.

Sl No	Project based Training/Modules	Sessions	Labs	Hours
1	Linux Systems Administration ...	5	5	30
2	Shell Scripting using Bash ...	10	10	52
3	Linux Networking & Network Administration ...	5	5	30
4	Data Structures with C using Linux, vim, gcc, gdb, SCCT ...	25	35	190
5	Linux System Programming, Data Management and MySQL ...	10	10	60
6	Linux System Programming using IPC, Sync & threads ...	10	15	60
7	Linux Network Programming using Sockets & NW Protocols ...	10	10	60
8	C++ with Eclipse and QT on Linux ...	20	20	120
9	OOps and Scripting using Python on Linux with Eclipse ...	15	15	90
	Six Projects would be implemented during the training
	Total	110	115	660

__Back__

EmbLogic™ is an ISO 9001:2008(QMS) (Quality Management System) Certified Company.