18001025661 / 8527794500
info@sgtuniversity.org

Syllabus | B.Tech-Computer Science & Engineering | Technical Skills for Computer Engineers-II

 

Technical  Skills for Computer Engineers-II

Learning Schedule

L

T

P

C

Pre-requisites: Fundamental of computers

0

0

2

1

Course Objectives

  1. To prepare students to build solid foundation in theory and practice of B.Tech-Computer Science & Engineering.
  2. To make B.Tech-Computer Science & Engineering graduates most competent, industry ready & competitive  in public and private organization
  3. To build extensive foundation among students to take up higher study
  4. To reduce the industry & academic gap & also train students as per current industry requirement.

Course Outcomes
On completion of this course, the students will be able to:

  1. Develop programs using threads in C
  2. Use system calls, low level programming features and threads in C.
  3. Write queries in MYSQL.
  4. Understand basic concepts of networking, DBMS & compiler
  5. Design components of compiler
  6. Describe the process of problem solving.
  7. Identify and employ techniques for generating possible solutions.

Course Content

Unit I: Theory of Automata & Compiler
DFA/NDFA, CFG, Turing m/c, phases of compilers, lexical analysis, parsing

Unit II: DBMS & Networking
Networking basics: OSI Model, bridge. Router, hub, TCP/IP, Basics of Database, ACID properties, schema, type of data bases, tuple relation algebra, normalization.

Unit III:  System Programming
System calls: get pid, kill, fork, exec, system, wait, zombie process.  Use of system call in linux: fchmod, setpriority, getpriority, statfs, other system calls. pthread : Create thread, exiting from thread, joining threads,  Thread synchronization: Thread synchronization using semaphores, thread synchronization using mutex

Unit IV:  MySQL
Practicing DML, Simple Select, Char, Number, Date functions, Dual table, : Number Function, Character Function, Set Operations, Aggregate functions, GROUPING, JOINS, Joins, Cartesian product, Views, Sequence

Unit V:  Problem solving
Solving logical problems related to these topics. Clearing students doubts, testing their level of understanding.

Text Books

  1. Linux system Programming, Love, O reilley
  2. Introduction to Automata Theory, Languages, and Computation (3rd Edition) [John E.Hopcroft, Rajeev Motwani, Jeffrey D. Pearson
  3. Computer Networks, Tannenbaum, Pearson
  4. Compilers: Principles, Techniques and tools, Aho-Lam-Sethi-Ulman, Pearson
  5. Fundamentals of database systems, Elmasari, Navathe, Addison Wesley 

Reference Books/Links

  1. www.tutorialspoint.com/unix_system_calls
  2. www.linux-tutorial.info
  3. http://www.advancedlinuxprogramming.com/alp-folder/alp-ch08-linux-system-calls.pdf
ADMISSIONS 2021