About the course

Teaches initial commands, for example, the creation of a database, table creation to more advanced commands, such as JOIN and store produres.

1 Chapter 1
Lesson 1. Introduction to the Database
Lesson 2. Wampserver and its Functioning
Lesson 3. Execution of Programs
Lesson 4. Database Implementation
Lesson 5. Organizes and Teaches Data
Lesson 6. Tables and Fields
Lesson 7. Drop and DataBase
Lesson 8. Data Consistency with Primary Key
Lesson 9. Primary Key and Drop
Lesson 10. Automatic Numbering
Lesson 11. Table Change - Part 1
Lesson 12. Table Change - Part 2
Lesson 13. Relationship between tables
Lesson 14. Standardization Rules 3rd Form
Lesson 15. Base Creation
2 Chapter 2
Lesson 16. Constraint Foreign
Lesson 17. Foreign II
Lesson 18. Diagrams and Insertion of Records
Lesson 19. Insert 1
Lesson 20. Insert 2
Lesson 21. Select Command
Lesson 22. Comparison Operators - Part 1
Lesson 23. Comparison Operators - Part 2
Lesson 24. Related Operators - Part 1
Lesson 25. Related Operators - Part 2
Lesson 26. LIKE Operator and Aggregate Functions
Lesson 27. Between and IN
Lesson 28. Functions and Aggregations I
Lesson 29. Functions and Aggregations II
Lesson 30. Data Modeling in the Workbench
Lesson 31. Modeling and Inserting Data Types
3 Chapter 3
Lesson 32. Creating Tables
Lesson 33. Constraints
Lesson 34. Association of Tables and Other SQL Constraints I
Lesson 35. INNER JOIN command
Lesson 36. JOIN
Lesson 37. Association of Tables and Other SQL Constraints II
Lesson 38. Righ Join and Cross
Lesson 39. Default, Check, Unique and Full
Lesson 40. Database Backup
Lesson 41. Backup
Lesson 42. Import and Delete Join
Lesson 43. Store Procedures I
Lesson 44. Inclusion of Records
Lesson 45. Exclusion
Lesson 46. Exclusion II and Execution
Lesson 47. Store Produres II
Lesson 48. Return of Data II

About the Certificate

Only in iPED can you print the digital certificate for free or choose to receive this beautiful certificate at home (additional cost of + freight). On the back of the certificate is the schedule, CNPJ stamp and the signature of the person in charge, characteristics that are mandatory for the validity of the certificate.

Online chat
Pad
Study Groups
Virtual instructor
Support material
Online reports
Interactive animations
Explanatory videos

Only iPED can offer a quality service for free. We are the only company in the industry that possesses all the qualities and numbers below:

Purchase Security Differentials

Professional security audit;
Digital certificate with 256-bit encryption in transactions;
Quality with the consumer award;
National reference award in education;
National reference award in social projects

Differentials in Services Offered

Content-rich video, games and animations online;
Accumulation of loyalty points;
satisfaction rate of more than 98.5%;
indication index for friends over 98%;
Index that considers good / optimal material of more than 95%;
Online, face-to-face or telephone service;
Service through 0800 (free connection for all of Brazil);
Variation of the workload from 20 to 120 hours for free courses;
More than 500 online courses;
Significant testimony for each course attended;
Presence in more than 60 countries;
Thousands of students enrolled in courses;
More than 1 million consumers of our services.

About the Author: Anderson Cardoso

Professional Analysis Systems, Consulting and Projects. Graduated in Information Systems and postgraduate in Management and Governance of Ti.
Professional Experience of 10 years in the area of Ti, having acted as a developer, consultant and teacher in analysis and programming of systems and creation of Websites.

Choose your plan