Course Details

Professional Database Administration (SQL)

Instructor:

Mamun-ur Rashid

Categories:

DATABASE
Image

Course Description

Talented and knowledgeable database professionals are always in demand. The most in-demand certifications for database administrators, database developers, and anyone else who works with databases. During the past three decades, we've seen a lot of database platforms come and go, but there's never been any question that database technology is a crucial component for all kinds of applications and computing tasks.

Career Opportunities

Database administrator (DBA), Database developer, Database designer/database architect, Data analyst/data scientist, Data mining/business intelligence (BI) specialist, Data warehousing specialist :

Prerequisites

    No prior technical experience is required!

  • ( Database & SQL CoConcept)
  • ( Download, install and design Database)
  • (SQL Types ​Import ​Use of SQL Plus ​Editing in SQL Plus ​Saving query ​Projection Selection ​Arithmetic Operation ​Operator Precedence)
  • ​Using SQL developer Null Value Operation ​Aliasing ​Concatenation ​Literals ​Quotation
  • Restricting Data Sorting Data ​Removing Delicacy ​Description of Table ​Comparison ​Substitution ​Verify
  • ​Dummy table ​Single Row Function ​​Character Function ​​Number Function ​​Date Function
  • ​Conversion Function ​Aggregation ​​Grouping Function ​​Grouping Row
  • ​Test 1
  • ​Joins
  • ​Set Operation​ Subqueries
  • ​  Data Definition ​​SQL Data Types​ Creating Table Constraints Modifying Table Structure Removing Table
  • ​  Data Manipulation ​​Data Insert ​​Data modification ​​Data deletion
  • ​View ​Indexing ​Procedure ​Function Trigger
  • ​Bonus Class
  • ​Final Test

Course rating

5.00 average based on 1 rating

Star

90%

Star

80%

Star

65%

Star

60%

Reviews

  • Image

    Anna Dew

    Cover all my needs

    The course identify things we want to change and then figure out the things that need to be done to create the desired outcome. The course helped me in clearly define problems and generate a wider variety of quality solutions. Support more structures analysis of options.