BTEKS

Database Management Systems Support

On hand Experience:

When walking into a new DBMS that one has never seen... the first requirement is getting to know the DBMS by spending time viewing each of the databases configurations, and remind yourself to get to know the "default" settings, and know, which ones are currently, operational.

 

If there isn't an existing schematic of a current DBMS that provides the current configuration of the DBMS, then building one..., it helps one to become familiar with a DBMS quickly.

 

Differences between:

Oracle, MYSQL, MS SQL Server, Sybase, & Ingres:

Since all are DBMS, the functionality are all the same...

each one stores data, each one allows authorized users to access data, each one allows for the manipulation of the stored data, each one will crash for all of the same reasons.

 

Subtle idiosyncrasies are obvious, but, functionality for all, is the same,

"Store Data" and allow access to the data based on the individuals absolute

needs.

 

The 2 Differences are:

Accessing the DBMS:

The "SQL" used to access and manage each one of these DBMS... is all the same, except, each one has subtle differences in how the SQL Statement is written before the SQL Statement is accepted and executed.

 

Functionality of the DBMS:

10 years ago, there were major differences in the functionality of each one of these DBMS... but today, all have caught up with each other, in terms of the basics that are needed today:

Example: Replication, 9 years ago, was not a functionality that was equal by all DBMS... and today, each has several different configurations for replication but the purpose is all the same.

Another Example: 9 yeas ago, table joins was not a function capable in MYSQL, but, today it is, and each DBMS..., has a different degree of the extent to which each DBMS... performs table joins, as well as the many options associated with table joins, but the standard table join is a functionality with all DBMS...

The Process of Managing a DBMS:

 

1.  Identify the DBMS

The first step of supporting a DBMS... is identifying the exact iteration of the DBMS... that we are asked to support and if there are several iterations and/or several DBMS... with several different iterations, identity them all.

 

2.  Review DBMS Reference Material for specific configurations

Each iteration of a DBMS... has an associating reference book that describes all of the functionality of the specific iteration of a DBMS... If we are not already knowledgeable in the specific DBMS... iteration identified, simply review the reference material for functionality and apply.

 

3.  Review the existing environment specifications

There are hundreds of tools used to access a DBMS..., some come with the DBMS... and some are tools designed for different DBMS..., yet all of these different tools perform the same tasks, but differently, so often times, learning the tools used by a specific company, is all we need to become familiar with, because the tool is used to perform all tasks that we already understand how to perform.

 

4.  Implement Installation & Configuration

After identifying the specific DBMS... iteration and reviewing its reference material, review all task requirements with the customer, then begin to become familiar with the environment and practice with the specific tools used by the company and use the tools to master the tasks required by the company.

 

Website Design:

BTEKS WEBSITE SUPPORT

 

BTEKS helps you how:

 

You want a website and you have tried the "do it yourself" stuff but it was either to difficult, to confusing, or it took to much of your valuable time.

 

We take control for you:

 

BTEKS will find you a hosting company and act as your web master/manager to establish your domain name & create your business email address/s.

 

We guide you thru:

 

BTEKS will design your website from concept, or, assist you in your search for a full website template that you may use as your website.

 

BTEKS will up load all of your files to your hosting company's server for you and test the website to ensure it works.

 

We support your up and running website:

 

BTEKS will help you to edit all text for your website and add all pictures to your web pages in the locations that you select that will fit.

 

BTEKS will add any additional pictures that you want added to your website as you continue to grow with experience.

 

We train you on how to manage your website:

 

BTEKS will show you how to use editing tools that allow you to change your own text, change your font styles, shape and move pictures and how to create and move div's that store your data on a web page.

 

BTEKS will train you on how to access your hosting file manager, how to use it to upload new or changed files or pictures and then test the results for accuracy.

 

Dynamic Website Design


BTEKS Support Dynamic Website Design and Creation.

 

A Dynamic Website Design is a server driven website, in that, a percentage or all the data that displays on a web page is retrieved from a database.  Dynamic Website allows for more data security, more efficient data display and greater data storage, and are generally a website that may  be displaying some type of information for visitors to review.

 

BTEKS can provide Dynamic Website Design Services for any small, medium or large company or business that need complete services from concept.

 

News Related Website

BTEKS provides web content for specific interests.

BTEKS ASKFMB.COM Website has been up and running for 6 years and we have collected thousands of pictures, and thousands of article,s that we display on ASKFMB.COM.

 

News Media Websites that are interested in outsourcing their "news content collection", BTEKS offers a great deal that will provide your news website with "data mined from across the entire Internet", along with captured and blended pictures associated with the subject, and we will deliver this stuff packaged in "html" and send it to your news editor.

 

BTEKS does all the grunt work for you and the hours spent will only cost you a small fraction of what you would pay your own web content employees.

 

Website Development / Application Support Services

 

BTEKS WEBSITE DEVELOPER/APPLICATION SUPPORT SERVICES

 

DATABASE WEB APPLICATION SUPPORT:

 

Program Management Philosophy BTEKS Support: 

Full Development Life Cycle (FSDLC) & Agile Software Development

 

2 Week Sprints, 6 Week SCR Development, 6 - 18 Month Software Dev

 

6 Week Schedule Change Release (SCR) Development:

Step 1:

New Development Cycle begin with a meeting to discuss a list of SCRs that are part of the 6 week development cycle.  Each member of the development team chooses from the list scrs that they will address.

 

Step 2:

Developer reviews SCR description for requirements, and all associated content provided by users and analyst. 

 

Step 3:

Developer begins analysis of possible solutions to the SCR by reviewing application error, source code, database tables, stored procedures, views, triggers, packages, etc. 

 

Step 4:

Developer submits informal possible solution to database architect for approval.

 

Step 5:

Developer, per approved solution from db architect, makes code changes and tests code changes in the appropriate db development test environment.

 

Step 6:

Developer forwards the tested changes to the team lead for review and begins design of test material for code changes made.

 

Step 7:

Developer submits changes and testing material to team lead for promotions to integration testing.

 

Integration testing completes, and the SCR is promoted to QA and upon all upward testing, the SCR is included in the next Software/Application Release.

There are several different methods of actually creating a website utilizing something as simple as a word document or software that is designed to allow a creator to generate static and complex dynamic websites.  Website Design pricing can be as cheap as $50 bucks or as expensive as $500k, pending on the complexity and size of the website that an individual or a company requires. 

 

BTEKS is completely familiar with any website design that a person or a company is interested in, be it simple static website design or dynamic database driven website designed to display company catalogs or specifically display record sets.  Let’s talk.

 

Dynamic websites are becoming more and more easily developed but, the black hole of technical knowledge prevails if a small company decides to utilize “open source” databases like MYSQL as the database of choice.  Open Source Database simply means “a free database”, which can provide database driven website design and functionality and not requiring a DBA to install, configure and manage a company’s database.  Be very careful of open source because if your company continues to grow and you never hire a DBA that manages and configures your MYSQL Database, as an example, you will find somewhere in your future that you’ll eventually need a DBA to “re-design” the database from the ground up in order to normalize or clean up the mess. 


A Re-designed MYSQL database or a database migration to another type of database like MS SQL Server or Oracle will cost in the hundreds of thousands of dollars, unless, you hire a company like BTEKS that, cross trains its website designers to learn how to manage, install and configure databases. 


BTEKS

 

BTEKS

 

Software Development & Testing Support –

 

BTEKS provides Software Development & Testing Support to include but not limited to database installation, database architecture design and configuration for testing and production environments. 

 


 

 

 

Software Technical Writing & Software Formal Instruction Presentation –

 

BTEKS Supports Software Training to include but not limited to design and creation of software training material as well as providing formal presentation of software training material to subject matter experts and end users.

 

 Software Instructions, if not presented correctly, can cause more confusion than help and after providing software instructions for more than 900 software users, Felton Batiste has it down to a science.

 


 

 

 

Software Technical Support –

 

BTEKS understands that providing software technical support to end users provides the opportunity to ensure that the finished product is utilized at the optimum.

 

  When the end users have either a good grasp of all functioning parts of the software or have an on-site technical support representative at their side, the product will provide all described capabilities at 100% satisfaction, to the customer. 

 

BTEKS understands that by providing software development support, software testing, and software instructional material design, the best entity to present software instructions and on-site software technical support are the same entities that provides the development and testing.

 

  It’s called “completing the circle”, which is why BTEKS provides the complete circle of software technical support.

 

 


 

 

 

Network and System Administration:

 

BTEKS approach Network and System Administration as the starting point for all its personnel development pool.  There cannot be a website or a database without people who understand how to manage desktop administration and operating systems. 

 

BTEKS provide Network and System Administrators with the cross training necessary to provide a step above desktop help and system administrators by ensuring that every one learns all the elements of technology.

 


 

BTEKS Technical Support Services:

 

BTEKS Technical Support Services can meet the needs of Full Life Cycle Software Design and Development. 

 

BTEKS understands that software development is just part of the process and the completed circle requires testing, and implementing the finished product. 

 

The finished product will require the end user to have training and support of the finished product, which requires the creation of training material, instructing of training material, on-site support of the finished product and follow up documentation of customer’s request for enhancements and change recommendations.

 

  BTEKS can provide everything but the software design engineers whom actually write the code for the software. 
Software Testers, Software Technical Writers, Software Instructional Material Writers, Software Instructors, Software on-site Technical Support and Software Program Management Support.

 


 

 

 

BTEKSLogistics and Aviation Support

 

BTEKS approaches Logistics and Marine Aviation Support from a similar perspective. 

 

BTEKS CEO spent more than 15 years in the trenches of marine aviation O & I level maintenance, during which time, provided a significant role in the implementation of

3 initially implemented programs,

 F18 (Simulated) Automated Maintenance Environment Program ((S)AME),

 

V22 Osprey Aviation Maintenance Event Ground Station Program (AMEGS),

 

and

Marine Corps  Marine-Sierra Helicopter Aviation Reporting Program (M-SHARP).

 

Logistics and Technical Support goes hand in hand in that if you’re a technical support representative, you will undoubtedly perform a arms length of tasks that would otherwise be described as logistical tasks.

 

The bottom line, get the job done with professionalism and expertise.