Specialising Course - Workshop Managing Data with SQL | AI & BIG DATA duration Evening
SQL allows users to visualize data inside the database in a personalized way by gathering and/or dividing it so as to focus just on specific and necessary information.
The SQL language allows users to work on two fundamental fronts: programming and data processing on the one hand, and data visualization on the other. In fact, thanks to SQL, professionals can not only manage the database while preserving the data, but they can also work on data analysis in a specific and customizable way in the shortest possible time, having the advantage of being able to process millions of rows in a few seconds.
Main Contents
UNIT 1 | Introduction to Relational Databases: an introduction to the main themes of databases, basic concepts, terminology and main technologies through history and in the work field.
- Databases
- Database management systems
- Relational model
- Normalization
UNIT 2 | Data Consistency and Integrity: the definition of the standards for a correct use of the rdbms and the data structures used by them
UNIT 3 | Interaction with the Database: how to interact effectively with the database by performing queries, manipulations and creation of data structures
- Interrogation
- Handling
- Structure
UNIT 4 | MySQL: query system tables and schemas to obtain database status information and perform statement optimization
UNIT 5 | Security: how to handle the SQL injection problem and avoid the execution of malicious code
Request a one-on-one interview to learn more about each teaching unit
Who is this course aimed at?
The course is open to beginners who are recommended to have basic computer skills.
For those who are interested, the Foundation module is also available (basic knowledge of computers; basic knowledge of networks; basic knowledge of linux systems; basic knowledge of virtual machines).
What will you gain from this course?
At the end of the course, participants will be able to use SQL to collect, clean and analyze large data sets.
Diploma & Certifications
At the end of the course, you will receive a certificate of completion “GEEKS ACADEMY DIPLOMA”, a “DIPLOMA SUPPLEMENT” and the EXIN INTERNATIONAL CERTIFICATIONS included in your study plan – if you choose to sit the exam, which is not mandatory.
Career Coaching
For a period of 5 years after the conclusion of the course, you will have the chance to benefit from our Career Coaching service for free.
Over 95% of our graduates have found a job within 3 months since the end of the course!
International Experiences
To our students we offer the possibility to take part in exciting study trips in Dubai, Seoul, Milan, Rome and Singapore, where the hubs of our international network are located. These immersive experiences represent a great way to enrich students’ wealth of knowledge and increase their career opportunities.
Global Alumni Community
By joining this course, you will automatically become a member of the AGA: the Alumni Geeks Academy.
AGA is the community that gathers all our former students in order to offer them support, help them strengthen and develop professional relationships, provide them with networking opportunities and notify them about the latest job offers. The Alumni International Day represents the community’s most important international networking event, as well as a valuable opportunity to keep up-to-date with the latest trends and technologies.
Teaching Arrangements & Technical Equipment
Smart Education Formula
Course delivery mode: synchronous distance learning.
The lessons will take place on Saturday and Sunday (10:00-13:00 and 13:45-15:45 CET).
*The hours indicated are intended as academic hours of 50 minutes each.
E-learning Platform
Our flexible approach allows you to study wherever and whenever you want, even if you work and do not have much time.
All lessons are delivered OnlineLive by qualified teachers, and are recorded in real time to give you the opportunity to watch them asynchronously on our e-learning platform, in case you miss one lesson or you want to review some contents. Among other things, on the platform you will also find many useful materials for self-studying, such as self-assessment tests, exercises and exam simulations.
Minimum hardware & software requirements
Notebook: dual core 64-bit on x86-64 CPU | 8GB RAM | O.S. Windows, Linux or macOS
Payment Method
Payment must be issued in one single solution before the beginning of the course.
The number of places available is limited
Please fill out the form to inquire about our services & promotions and to check the availability.