SQL Server

SQL Server course is offered by Firstman Academy. Since Firstman Academy inception it has imparted quality training to more than 10000 students and many of them were placed in reputed MNCs as well as established Indian companies over a decade.

Organization is currently focused on IT/GIS Training and Services Staffing Firstman Academy has spent over 15 years in innovating, refining and fine tuning its offerings to suit the needs of students, professionals and employees.

Course Content:

• Introduction to Oracle Database
• List the features of Oracle Database 11g
• Describe the Process StructuresDiscuss the basic design, theoretical, and physical aspects of a relational database
• Categorize the different types of SQL statements
• Describe the data set used by the course
• Log on to the database using SQL Developer environment
• Save queries to files and use script files in SQL Developer
• Preparing the Database Environment
• Identify the tools for Administering an Oracle Database
• Plan an Oracle Database installation
• Install the Oracle software by using Oracle Universal Installer (OUI)
• Creating an Oracle Database
• Create a database by using the Database Configuration Assistant (DBCA)
• Managing the Oracle Instance
• Setting database initialization parameters
• Describe the stages of database startup and shutdown
• Using alert log and trace files
• Using data dictionary and dynamic performance views
• Configuring the Oracle Network Environment
• Configure and Manage the Oracle Network
• Using the Oracle Shared Server architecture
• Managing Database Storage Structures
• Overview of table space and data files
• Create and manage table spaces
• Space management in table spaces
• Administering User Security
• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles
• Managing Data and Concurrency
• Monitor and resolve locking conflicts
• Managing Data and Concurrency
• Overview of Undo
• Transactions and undo data
• Managing undo
• Managing Data and Concurrency
• Use and manage optimizer statistics
• Use and manage Automatic Workload Repository (AWR)
• Use advisory framework
• Manage Alerts and Thresholds
• Performance Management
• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot invalid and unusable objects
• Backup and Recovery Concepts
• Identify the types of failure that can occur in an Oracle database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Overview of flash recovery area
• Configure ARCHIVELOG mode