Dedicated to regular “Dummies” or MySQL for beginners. Fakhіvets databases (Excel, Access) Navchannya subd

Author's view: Did they call you a teapot? Well, the one on the right is correct! Kozhen samovar prick with a teapot! Have any skin professionals ever stabbed you with a samovar? No, they’re not the same again! Zagalom, MySQL for people from the beginning.

Advice for dummies MySQL

If you have seriously decided to connect your life with the Internet, then you will immediately come across the DBMS in the first few days of your life. MySQL can easily be called the “all-Internet” database management system. You cannot do without it for most serious resources, and it is present in the administration of your hosting. And most of all popular CMSs and messages from “self-made” engines are inspired by their participation.

Honestly, you can’t do without this platform. But for this training you also need the right approach, the right tools, and most importantly, patience. I hope you have enough of the remaining warehouses. And be prepared to boil your meats and pour steam from your head, like from a hot kettle.

But it is so important that MySQL for dummies is given especially because it is incorrect to print this application. We have no such peace with you, and we need to be familiar with this technology from the very basics.

Basic concepts

To get started, let’s go through the basic concepts that we learned in this publication:

A database (DB) is the main storage unit of a DBMS. The database includes tables that are made up of columns and records (rows). Designed on the web of the book to match the structure of the song type.

DBMS (database management system) – the totality of all software modules for database administration.

SQL is a language of structured queries, with the help of which the tool “combines” with the DBMS core (server). Like any program, SQL has its own syntax, set of commands and operators, which are supported by data types.

I think we have enough theoretical knowledge to begin with. Daily clearings are theoretically and “grossed out” by practice. Now I can no longer choose the correct software tool.

Selecting the right tool

Not completely spoiled by the entire assortment of MySQL shells for beginners, I think that there are simply no such thing. all software products For DBMS administration, the availability of the installed database server is required. So, having decided not to enter the “scooter”, you have selected your choice on the Denwer ham bag. You can enchant it on the official website.

This warehouse already includes all DBMS warehouses, which allow newbies to quickly get familiar with MySQL after a simple and intelligent installation. In addition, Denwer also includes a number of tools necessary for getting started as a tool maker: local server,PHP.

First crumbs

The installation process of the “gentleman’s” set is indescribable, since everything is installed there automatically. After starting the installation, press only the required keys. The very same things you need in the MySQL for Dummies version.

When the installation process is completed, start the local server and wait a few seconds. After this, enter the browser address bar localhost.

On the page "Hurray, requested!" go one by one from those indicated in the photo. Afterwards, you will use this in phpMyAdmin – a shell for database administration.

By going to http://downloads.mysql.com/docs/world.sql.zip, you will download a sample test database from the official MySQL website. Go again to phpMyAdmin, in the main menu go to the “Import” tab. In the “Import to stream” window, in the first section (“Imported file”), set the value “Computer overview”.

In the Explorer window, select the archives with the downloaded database. At the bottom of the main window, don’t forget to click OK.

Raju does not change the specified parameter values ​​yet. Tse can be called to incorrect image dzherela data that is imported. If the phpMyAdmin system has received a warning that it cannot recognize the database compression algorithm, unzip it and repeat the entire import process.

If everything went well, the beast will be notified by the program that the import has been successfully completed, and there is another left hand in the database list (word).

Let's take a look at the structure in the middle so that you can clearly see why you will be on the right.

Type the name of the MySQL database for starters. A list table will appear below it, including the following. Click on one of them. Then go to the top menu “Structure”. In the main work area, the structure of the table will be displayed: the names of all columns, data types and all attributes.

Date to take a cob

Database cursor program Access and Excel

Excel

1. Basic elements of the Excel interface

• 1.1. Main menu, toolbars, work area
• 1.2. Company name panel, row of formulas, scrolling options
• 1.3. Row system
• 1.4. Introduction and editing of data
• 1.5. Inserting and selecting middles, rows and stops

2. Visual design of the project

• 2.1. Format instead of middles, font parameters.
• 2.2. Different styles of armchairs and decoration table
• 2.3. Methods for verifying text in commercials
• 2.4. Introduced formats Excel data
• 2.5. Tools for creating and designing projects

3. Form the data entry in the Excel table.

• 3.1. Database creation in Excel
• 3.2. Managing data forms
• 3.3. Change of record
• 3.4. Introduction new entry
• 3.5. View of deleted entries
• 3.6. Search for records
• 3.7. Sorting the list

4. Formulas and functions.

• 4.1. Concept of formulas and functions in Excel.
• 4.2. Standard Excel functions.
• 4.3. Moving and copying formulas from commercial stores.
• 4.4. Fixed and floating names of endings in spreadsheet formulas.
• 4.5. Master of functions.
• 4.6. Names that are designated by koristuvach.
• 4.7. A practical example of a completed project aimed at diversifying shareholder income.

5. Diagrams and graphs.

• 5.1. Master Diagram.
• 5.2. Design by diagrams. Autoformat diagrams.
• 5.3. Editing by diagrams.
• 5.5. Creation editing grouping and binding to sheets Excel graphic objects

6. Macros in Excel

• 6.1. Creation of a macro using an autorecoder
• 6.2. Editing a macro using the Visual Basic editor

7. Table entries.

• 7.1. Meister Zvedenikh table.
• 7.2. Consolidation of data.
• 7.3. Methods for changing the structure of an electronic table.

1. Access tables

• 1.1. Table structure
• 1.2. Created table. Zagalnye Vidomosti about types of fields
• 1.3. Entering data, editing, viewing, copying and pasting in a table
• 1.4. Dovgi text fields and MEMO – fields. Introduction area.
• 1.5. OLE object field.
• 1.6. Hyperpower field.
• 1.7. watering order. The healer's field. Field signatures.
• 1.8. Numeric fields.
• 1.9. Masks are introduced and they are important.

2. Report on Access tables

• 2.1. Search operations
• 2.2. Look for a replacement
• 2.3. Seen the tributes
• 2.4. Other data formats. Import and added table.
• 2.5. Import and acquisition of Excel archives and text files.
• 2.6. Work from the image of a great table.
• 2.7. Filter selection.
• 2.9. Keys.

• 3.1. Zagalni manifestations. Query constructor.
• 3.2. Writing of the minds of the selection.
• 3.3. Creation of calculated fields. Viraziv Day.
• 3.4. Ask for selection from group operations.
• 3.5. Create a table.
• 3.6. Ask for updates.
• 3.7. Ask for more.
• 3.8. Ask for a look. Crossover power supply

4. SQL – ask

• 4.1. Introduction of SQL viruses
• 4.2. Instructions Select
• 4.3. Statistical functions Count, First, Last
• 4.4. Statistical functions Min, Max, Avg
• 4.5. Sum function
• 4.6. Ask for additional information
• 4.7. Ask for updates
• 4.8. Ask for a video
• 4.9. Write to the created table

5. Fundamentals of multi-tabular databases

• 5.1. The data is displayed on the surrounding table. Happy fields.
• 5.2. Concepts of database normalization
• 5.3. The rich table will be entered into the selection. Tribute diagram. Subtable.
• 5.4. Working with subtables. Problems of data integrity.
• 5.5. Maintaining the integrity of data. Utilization parameters.
• 5.6. Maintaining the integrity of data. Substitution.
• 5.7. Practical applications of substitutions.
• 5.8. Other types of entries between tables.

6. Shape

• 6.1. Master of Forms
• 6.2. Formie. Autoform. Basic elements of the form designer.
• 6.3. Actions for the form designer.
• 6.4. Form areas. Entering marks. Formatting fields and marks.
• 6.5. Introduction of free fields that are calculated.
• 6.6. Posilannya na elementi formi. Form modes. Power of form.
• 6.7. Knitted shapes. The creation has a head and a lower form.
• 6.8. Methods of linking forms.

7. Call

• 7.1. Druk table of forms. Saving form as it is called.
• 7.2. Designer of sounds. Zoni is calling. This is the tabular view.
• 7.3. Changing the record holder, record numbering and storage functions.
• 7.4. Sorting and grouping is called.
• 7.5. Numbering of pages. Burnt letters.
• 7.6. Sounds from the appearance of the leaf. Label addresses.
• 7.7. Select a mode for outputting data from the form.
• 7.8. Parameters for other calls. Pictures of sounds.
• 7.9. Exporting sounds in various formats

The course will familiarize students with the basic principles of working with structured data in a relational model, learning how to design data, describing database objects in terms of a real DBMS, storing queries in SQL language, understanding statements, procedures, and triggers, create indexes, manage concurrent access until now, manipulate the transaction mechanism

About the course

The basis of the course is the learning and application of SQL language for creating, modifying database objects and managing data from a large relational database.
Vikonannya of practical tasks at the boundaries of the course is transferred to the Vikoristan DBMS My SQL.

The course looks at the stages of design relational databases data, rules for adding words; main methods of data indexing. You will be aware of the power of the transaction and access rights to the data.

The course also provides an overview of current trends in data science in connection with the emergence of BigData. The course will show the areas of NoSQL database storage and indicate the current approaches to processing big data.

Format

The form of training is in absentia (distance learning). Important activities include watching thematic video lectures, reading electronic notes and completing test assignments with automated verification of results, testing for completed material. To revoke the certificate, you need to sign out all the assignments, test and write the final test.

Vimogi

To successfully complete the course, you need knowledge of the basics of programming, basic concepts of multiplier theory, fundamentals linear algebra and the foundations of mathematical statistics. Insurance course for bachelor's students. The course may be useful for students majoring in Computer and Information Sciences, as well as for other students who need to manipulate large amounts of data.

Course program

Day 1. A lecture is presented in which the main course, sections of the course, and the place of databases for various information systems are presented.
Week 2. Design of databases. Model "Sutnity-links".
Day 3. Relational algebra. Normalization of relational notes.
Day 4. The main objects of the database are described in SQL.
Week 5. Ask for mov SQL.
Day 6. Manifestations, procedures, functions, triggers.
Week 7. Data indexing.
Week 8. Optimization of inputs.
Week 9. Competitive access management.
Year 10. Direct trends in the development of databases. Current approaches to processing Big Data.

Navchannya results

The course will include an understanding of terminology and basic database objects, SQL basics, design data and create database objects using terms of the relational model, write queries in SQL, create indexes for faster search queries, construct manifestations, functions, procedures and triggers, give access to a database of rich investors, use transaction mechanisms, and also formulate the methods of databases in different galuzahs.

Formation of competencies

After completing the course, students will know:

1. Principles for describing the conceptual informational (infological) data model
2. Principles of data design in terms of the relational model
3. Basic SQL operators
4. Current trends in the development of data science
5. Main types of NoSQL databases
6. Basic methods of data analysis

After completing the course, students should note:

1. Describe the structure of data in terms of the conceptual model “Subsistence-connections”
2. Create database objects
3. Describe the integrity of the data
4. There will be additional structures to quickly search for data
5. Write a request in mov SQL
6. Create manifestations, functions, procedures and triggers
7. Create new accounts and give them access rights to the database
8. Vikoristovat transaction mechanism for competitive access to data

After completing the course, students will understand:

1. Basic planting design data
2. How the indexes are controlled
3. How the query optimizer works
4. How does a transaction manager work?
5. What is the task of processing Big Data

Today it is impossible to determine the work of the largest companies, banks and government organizations without searching databases of these funds. Databases allow us to save and deny access to large amounts of information, and a database management system (DBMS) allows us to manage available collections of information. Today, the largest DBMS developers are transnational corporations such as Microsoft and Oracle.

Koshti is used for business analysis and modeling of various processes. They allow you to come up with high-level information, focusing the attention of stakeholders on the key factors of effectiveness, modeling the results of various options for action, and the resulting results of making these and other decisions.

You can learn about databases and Business Intelligence features at coursesB.I.() Center “Specialist” at MDTU im. N.E. Bauman – wired Microsoft Authorized Startup Center in Russia.

The Center “Specialist” also conducts course navchannya zSQL Server, which describes the fundamental principles of relational databases, starting with the main objects, which can be accessed using additional SQL language. In progress navchannyaSQL Server Strategies for accessing, obtaining data, and changing data are discussed in detail with additional instructions; tables, such as declarative data; complex entries, programming in Microsoft SQL Server in T-SQL language of customized procedures, functions, triggers and declarations; methods for increasing the productivity of drinks, expanding functional capabilities Microsoft SQL Server for the XML search engine, SQLCLR and Filestream, as well as for additional space types, full-text search and Service Broker. The classes will be led by certified Microsoft trainers. Prestigious international certificates, national training programs, the largest Prometric testing center in Russia are waiting for you!

In Crimea, the Center “Specialist” is conducting kursi zOracle, on which the main features of the Oracle DBMS architecture are understood and thoroughly revealed, which fundamentally differ from other popular database management systems. Moreover, on coursesOracle a detailed description and illustration of all applications, capabilities, features and particularities Oracle, which will ensure the development of effective add-ons for this DBMS and its successful operation.

Also, the Center “Specialist” conducts courses in MySQL. With us you can walk the path from the level of the retailer-cob to the level of the retailer-expert MySQL DB.

Advantages of working with databases at the Specialist Center:

• Center "Specialist" - the largest initial center Microsoft in Russia, Russia and Central Europe!
• The Specialist Center has the highest partner status Microsoft Gold Learning Galuzia has knowledge, as well as competence Silver Data Platform, which confirms the high qualifications of the depositors of the Center in the area of ​​administration, development and business analytics based on SQL Server 2012.
• The Specialist Center has a prestigious status Oracle Academy.
• We have the best depositories. Bauman traditions of yakost .
• The best rhubarb training of administrators, database developers and analytical solutions with the SQL Server system. Ponad 80% DBMS administrators and developers, as well as business analysts (BI) in Russia, completed courses at the Specialist Center.
• Prestigious