Databases training courseware.

Companies of every size use SQL Server as the database through which their business applications share information. These companies need knowledgeable database administrators and programmers to make sure that their applications access and use the databases in the most efficient and effective ways.

If you'd like to develop your skills as a database administrator or programmer, NEMBOT has training that will prepare you for the certification exam as well as give you skills you can apply on the job.

A comprehensive introduction into the use and management of the SQL client-server relational database management system (RDMBS), covering its installation, configuration, use, database administration and optimisation.

Contents

 

A practical introduction to SQL

• Running the mysql client program
• The simplest query: select *
• Displaying query results
• Splitting up queries
• Selecting columns and rows from database tables
• Queries over multiple tables
• Combining where and column choice
• Examining a MySQL database
• Using SQL insert queries to add data with and without column names
• Rearranging columns with insert
• Inserting several rows at once
• Using the SQL update statement to change existing data in a table
• Using the SQL delete statement to remove data from a table
• Counting rows with the SQL count function
• Finding the largest and smallest items (SQL min and max functions)
• Finding averages (SQL avg function)
• Rows with missing data ( null values)
• Finding rows with missing data (SQL is null and is not null tests)
• Sorting result rows (SQL order by clause, sorting in ascending or descending order with asc and desc )
• Using column-name aliases for long-winded column names in select
• Simple joins across multiple tables
• SQL summary

A introduction to database design

• Creating a database (SQL create database statement)
• Creating a simple table (SQL create table statement)
• Text types (e.g., varchar(255) )
• Primary keys, identifying numbers
• integer not null auto_increment primary key
• Cross-table linking (matching foreign keys to primary keys)
• Changing the type of a a column (SQL alter table statement)
• A non-entity table
• Junction tables (auxillary tables to enable ‘many to many' joins)

Database design

• Data types
• Text types (SQL varchar and char , MySQL specific mediumtext and longtext )
• Binary column types (MySQL specific mediumblob and longblob )
• Relationships between tables (‘one to many' and ‘many to many')
• Unique IDs (including MySQL specific extension auto_increment )
• Primary and foreign keys
• not null type qualifier
• Joining across many-to-many relationships