196 Character courses in London

PYTHON BASICS: COURSE DESCRIPTION Excellent for beginners, practical, in small groups of max 4 people, 1 Day Online Instructor-led. You could contact us for your prefereed date. Session 1: Python Data Types and Variables: * Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python. * Operators and Expressions: * Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.. * Exercise: Calculate Movie Tickets for a Party, Are there enough seats in the cinema? Decision Making & Loops * If statement; If - else statement; If- elif - else statement; Nested if - else; * Exercise: Calculate the travel fee to deliver goods * The while, For loop * Jump statements: break, continue; * Nesting loops. * Exercise: Enter a password, if incorrect 3 times, you are blocked. Session 2: Data Structures * Lists. * Tuples. * Exercise: Hangman Game * Exercise: Get a word for the game from a Json File, store the high score in a Dictionary file Session 3: Files and exceptions * Exception Handling, Exception types; Using try and Except. * Files, streams: Open, Traverse, Read and Create Files: Csv, txt and Json Files. * API: Connecting to API’s. Session 4: OOP * Creating and using custom Functions. * Using parameters and return values. * Creating a Class; Creating an Object; Using an Object; Adding Instance variables; * Class Constructors; Parameterized Constructors. * Inheritance. Override. Session 5: Pandas Dataframe Basics * Getting data into a dataframe: Dict to Dataframe, Dataframe to Dict. Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets. * Getting information about the dataframe, * Filter, sort and query a Dataframes, Slicing Dataframes, * Duplicate values,Working with null-values, Sampling. * Exercise: Query the top 1000 grossing movies of the last century Session 6: Built in Functions: String, Math, Random * Python built-in functions: * Strings functions. Maths functions. Random Functions. * Exercise: Find information in prose, to get the sentiment of the prose. * Exercise: Get a word for the game from a txt File * Exercise: Win the lottery INCLUDED: * PCWorkshops's Python Programming Basics Certification * Course notes, exercises and code examples * Revision session after the course -------------------------------------------------------------------------------- REFUND POLICY No Refunds

With Actress, Acting and Audition Coach Sarah Hannah -------------------------------------------------------------------------------- INTRODUCTION Join our internationally recognised Screen Acting Weekly Course and develop your technical performance skills and character understanding over 5 Weekly Evening Sessions before applying your new skills on a professional set at Pinewood Studios as you participate in filming two showreel scenes. Over weekly sessions, the Director will use practical techniques to build your confidence in performance and help you master the technical requirements to be a successful screen actor. You will focus on the importance of character preparations, how to portray emotion, comedy and drama on camera in addition to career advice before shooting a professional acting showreel. Upon completion of the Screen Acting Weekly course, you will emerge with a heightened sense of assurance and confidence in your screen acting abilities and the tools to progress with your acting career, whether you’re new to the industry or a Drama School Graduate looking for more acting opportunities in TV & Film. MEET YOUR TUTOR Sarah Hannah Acting Coach https://www.imdb.com/name/nm0161404/ Sarah Hannah is a highly experienced Professional Actress, Acting and Audition Coach. Bringing her extensive experience of working on stage and on screen, Sarah will focus on enhancing your presence on camera and cover the technical skills required of a professional screen actor. -------------------------------------------------------------------------------- Course Outline The course led by Acting Coach Sarah Hannah is held at The Audition House, Central London, and the first 5 weekly sessions run for 3 hours (6-9pm). There are 3 additional showreel filming sessions at Pinewood Studios. You will be required for 2 out of the 3 filming sessions.  We film during the day and you will be given a specific filming time and will not be required all day.   As this course is inclusive of all levels of ability, it offers a comprehensive overview of screen acting skills, starting from the basics and progressing to more advanced concepts. It will include resources, material and instructional stratergies that cater to beginners while also offering challenges for those with more advanced skills. -------------------------------------------------------------------------------- BOOKING OPTIONS Select a course date and add to cart to proceed with payment. This course has limited availability and spaces are first come first served. Please read our Terms and Conditions before proceeding with your booking. £750.00 Weds 24th April-Thurs 30th May 2024 Lesson 1: Wednesday 24th April 2024 – 6-9pm Central London Lesson 2: Wednesday 1st May 2024 – 6-9pm Central London Lesson 3: Wednesday 8th May 2024– 6-9pm Central London Lesson 4: Wednesday 15th May 2024 – 6-9pm Central London Lesson 5: Wednesday 22nd May 2024 – 6-9pm Central London Filming Sessions: Tuesday 28th, Wednesday 29th and Thursday 30th May 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. Weds 18th Sept-Thurs 24th Oct 2024 Lesson 1: Wednesday 18th September 2024 – 6-9pm Central London Lesson 2: Wednesday 25th September 2024 – 6-9pm Central London Lesson 3: Wednesday 2nd October 2024– 6-9pm Central London Lesson 4: Wednesday 9th October 2024 – 6-9pm Central London Lesson 5: Wednesday 16th October 2024 – 6-9pm Central London Filming Sessions: Tuesday 22nd, Wednesday 23rd and Thursday 24th October 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. -------------------------------------------------------------------------------- ADDITIONAL INFORMATION FEATURES Practical acting training for screenShoot two scenes for your professional acting showreel with our Award Winning CrewSuitable if you are (17 yrs+) and committed to improving your screen acting skillsAttracts a varied age range from 17 yrs+. International Students WelcomeThe course is taught in English, so it is important that you have proficient English language skillsSmall Class Size LEARNING OUTCOMES Learn techniques to effectively analyse a Film/TV ScriptCreate truthful and inspirational charactersBuild confidence performing in-front of cameraUnderstanding the workflow of a busy film setAudition preparationCareer advice and direction – how to market yourself COURSE LOCATION Training Sessions (1-5)   6pm – 9pm The Audition House, 129A Whitfield Street, Fitzrovia, London, W1T 5EQThe Audition House is a two minute walk from Warren Street tube and 5 minutes from Euston Station Filming Sessions (6-8) Between 8am and 4pm Actors Studio, Pinewood Studios, Pinewood Road, Iver Heath, Buckinghamshire, SL0 0NH Free Parking available at Pinewood StudiosFree frequent shuttle bus service from London Uxbridge Tube Station, Slough and Gerrards Cross. Transfer from station to Pinewood Studios – 10 minutesCanteen and Coffee shops on siteExcellent transport links from London

Why Choose Character Animation in 3ds Max Training Course? Click here for more info. [https://www.londondesigntrainingcourse.co.uk/product-page/character-animation-in-3ds-max-training-course] Top character animation course in 3ds Max, this course provides an accessible learning experience. Learning character animation enables you to create your own short films. It's not just a means of income; it evolves into a passion.  Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Monday to Saturday between 9 am and 7 pm. Enroll in our exclusive "Character Animation Fundamentals in 3ds Max" course at London Design Training, guided by experienced tutors Sitwat Ali, Qasim Ali, and Jess. Gain in-depth insights into animating 3D characters, covering essential techniques like character rigging, pose creation, and seamless pose-to-pose animation. 3ds Max Character Animation Course Duration: 20 hours Course Overview: Master the art of character animation in 3ds Max with our comprehensive course. Ideal for beginners and those with some 3D modeling and animation experience, this course covers everything you need to know to bring characters to life. Course Outline: * Introduction to Character Animation * Explore animation principles * Get familiar with 3ds Max animation tools * Learn to create character rigs and manage the timeline * Basic Animation Principles * Understand keyframes and animation cycles * Apply the 12 principles of animation * Work with the graph editor and ease-in/out techniques * Advanced Animation Techniques * Utilize the reaction manager for complex animations * Master non-linear animation methods * Animate with inverse kinematics, custom controllers, expressions, and scripts * Creating Characters * Craft a character model with proper topology * Create UV maps and apply textures * Prepare characters for rigging * Facial Animation * Learn facial animation principles * Create blend shapes and morph targets * Master lip syncing techniques * Body Animation * Animate walk cycles and character motion * Achieve believable character poses * Implement character physics * Advanced Character Animation * Work with motion capture data * Use CAT and Biped tools * Understand motion blur and create special effects * Render and output animations * Character Animation Projects * Bring all skills together in practical projects * Create basic and complex character animations Course Requirements: * Computer with 3ds Max installed * Basic computer operations knowledge * Passion for character animation Course Goals: Upon completion, you'll have a thorough grasp of character animation in 3ds Max, capable of creating realistic and sophisticated character animations using advanced techniques. You'll be equipped with the skills to continue honing your character animation abilities independently.

face to face training customised and bespoke. One to One Online or Face to Face

Work with award winning filmmaker and leading London acting coach Fay Beck.

Who is this course for? 3ds Max Character Animation Training Course. Master character animation in our 3ds Max course. All levels welcome. Learn from certified tutors in flexible in-person or online sessions. Create unique 3D characters from scratch, gaining personalized techniques to fuel your creativity. Click here for more info: Website [https://www.autocadtraininglondon.co.uk/product-page/character-animation-3ds-max-training-course] Duration: 20 hours Method: 1-on-1 personalized attention Schedule: Flexible 1-on-1 sessions. Schedule your sessions at your convenience, choosing any hour between 9 am and 7 pm from Mon to Sat. Course Title: 3ds Max Character Animation Workshop Duration: 20 Hours Course Overview: This workshop is meticulously crafted to instill the foundational principles of character animation utilizing 3ds Max. Whether you're a novice or possess some background in 3D modeling and animation, this course caters to your learning needs. You'll delve into the art of character rigging, grasp animation essentials, and employ advanced methods to breathe life into your characters. Course Outline: Module 1: Introduction to Character Animation * Grasping animation principles * Exploring 3ds Max animation tools * Mastering character rig creation * Understanding the intricacies of the timeline Module 2: Basic Animation Principles * Embracing keyframe dynamics * Crafting fundamental animation cycles * Applying the 12 principles of animation * Navigating the graph editor * Utilizing ease-in and ease-out techniques Module 3: Advanced Animation Techniques * Harnessing the power of the reaction manager * Crafting non-linear animations * Implementing inverse kinematics for dynamic movements * Designing custom controllers * Exploring expressions and scripts Module 4: Character Creation * Sculpting a character model from scratch * Grasping the nuances of topology * Perfecting UV maps and texturing techniques * Preparing characters for seamless rigging Module 5: Facial Animation * Mastering facial animation principles * Creating expressive blend shapes * Utilizing morph targets for nuanced expressions * Achieving flawless lip syncing Module 6: Body Animation * Crafting seamless walk cycles * Animating characters in motion * Creating authentic and believable poses * Employing character physics for lifelike movements Module 7: Advanced Character Animation * Implementing motion capture data for realistic animations * Leveraging CAT and Biped for intricate movements * Understanding motion blur nuances * Adding special effects for enhanced realism * Fine-tuning rendering and outputting animations Module 8: Character Animation Projects * Synthesizing knowledge into practical applications * Creating a fundamental character animation * Crafting a nuanced walk cycle * Executing complex character animations Course Requirements: * Access to a computer with 3ds Max installed * Basic proficiency in computer operations * Enthusiasm for delving into the world of character animation Course Goals: Upon completion, you will possess a profound understanding of character animation in 3ds Max. You'll be equipped with the expertise to create intricate, lifelike character animations using advanced techniques. Moreover, you'll gain the skills necessary to continue honing your craft, ensuring a solid foundation for your future endeavors in the realm of character animation. Upon successful completion of the 3ds Max Character Animation Workshop, participants will: * Master Fundamental Principles: Understand the core principles of character animation, including keyframe dynamics, timing, and the 12 principles of animation, laying a strong foundation for advanced techniques. * Proficient Software Usage: Navigate 3ds Max confidently, utilizing animation tools, character rigging techniques, and specialized editors for precise control over character movements. * Advanced Animation Techniques: Apply advanced techniques such as non-linear animations, inverse kinematics, and custom controller design to create dynamic and realistic character movements. * Facial Animation Mastery: Demonstrate expertise in facial animation by creating expressive blend shapes, morph targets, and achieving seamless lip syncing for realistic character emotions. * Body Language Proficiency: Create fluid and natural body movements, including walk cycles, dynamic poses, and character motions, capturing the essence of lifelike animations. * Special Effects Integration: Integrate special effects seamlessly into character animations, enhancing visual appeal and realism in the final output. * Project Implementation: Apply acquired knowledge and skills in practical projects, including basic character animations, walk cycles, and complex character animations, demonstrating proficiency in real-world scenarios. * Problem-Solving Skills: Develop problem-solving abilities related to character animation challenges, employing creative solutions to achieve desired results. * Collaborative Skills: Engage in collaborative projects, demonstrating effective communication and teamwork while integrating animations into broader creative contexts. * Portfolio Enhancement: Build a robust portfolio showcasing diverse character animations, reflecting both technical prowess and creative expression, essential for career advancement in the animation industry. * Continued Learning: Acquire the skills and confidence necessary to pursue further learning and self-improvement in the field of character animation, enabling a continuous growth trajectory in the industry. Course Title: 3ds Max Character Animation Workshop Duration: 20 Hours Key Details: * Course Focus: Comprehensive training in character animation using 3ds Max, covering fundamental principles, advanced techniques, facial animation, body language, special effects integration, and project-based learning. * Audience: Ideal for beginners and individuals with some background in 3D modeling and animation, aiming to enhance their skills in character animation for industries such as animation studios, gaming, and film production. * Instruction Method: Interactive, instructor-led sessions combining theoretical knowledge with hands-on practical exercises, fostering a dynamic learning environment. * Flexible Learning Options: Participants can choose between in-person and live online sessions, accommodating diverse schedules and geographical locations. * Certified Instructors: Experienced tutors and industry professionals with certification in 3ds Max and character animation, ensuring high-quality instruction and personalized guidance. * Project-Based Learning: Engage in real-world projects, applying learned skills to create character animations, walk cycles, and intricate character movements, fostering practical expertise. * Software Proficiency: Gain proficiency in 3ds Max, including animation tools, character rigging, and specialized editors, enabling participants to confidently navigate the software. * Collaborative Learning: Opportunities for teamwork and collaborative projects, encouraging effective communication and networking within the class. * Career Development: Build a diverse and impressive portfolio, receive guidance on industry best practices, and develop problem-solving skills crucial for a successful career in character animation. * Post-Course Support: Access to resources, tutorials, and community forums, allowing participants to continue learning and stay updated with industry trends even after the course completion. * Certification: Participants receive a certificate of completion, recognizing their proficiency in 3ds Max character animation, enhancing their professional credibility in the job market. By enrolling in this course, you'll enjoy the following advantages: * Comprehensive Learning: Master the art of character animation in 3ds Max, covering fundamental concepts and advanced techniques. * Certified Tutors and Industry Experts: Learn from experienced professionals with extensive knowledge of character animation, providing valuable insights. * Personalized Instruction: Receive one-to-one training tailored to your specific learning needs, ensuring individual attention and effective progress. * Flexible Learning Options: Choose between in-person or live online training, offering convenience and accessibility to suit your schedule. * Recorded Lessons: Access recorded sessions to review content and reinforce your learning at your own pace and convenience. * Lifetime Email Support: Benefit from ongoing assistance and guidance through email, even after completing the course. * Free Career Advice: Tap into our industry expertise and receive valuable career guidance to excel in the field of character animation.

REGULAR EXPRESSIONS TRAINING COURSE DESCRIPTION Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Python and MySQL. Regular expressions allow you to code complex and subtle text processing that you never imagined could be automated. Once you've mastered regular expressions, they'll become an invaluable part of your toolkit. You will wonder how you ever got by without them. WHAT WILL YOU LEARN * Use Regular Expressions. * Troubleshoot Regular Expressions. * Compare RE features among different versions. * Explain how the regular expression engine works. * Optimize REs. * Match what you want, not what you don't want. REGULAR EXPRESSIONS TRAINING COURSE DETAILS * Who will benefit: Anyone looking to use regular expressions. * Prerequisites: None. * Duration 1 day REGULAR EXPRESSIONS TRAINING COURSE CONTENTS * Introduction to Regular Expressions Solving real problems, REs as a language, the filename analogy, language analogy, RE frame of mind, searching text files: egrep, egrep metacharacters, start and end of the line, character classes, matching any character with dot, alternation, ignoring differences in capitalization, word boundaries, optional items, other quantifiers: repetition, parentheses and backreferences, the great escape, expanding the foundation, linguistic diversification, the goal of a RE, more examples, RE nomenclature, Improving on the status quo. * Extended introductory examples A short introduction to Perl, matching text with regular expressions, toward a more real-world example, side effects of a successful match, Intertwined regular expression, intermission, modifying text with regular expressions, example: form letter, example: prettifying a stock price, automated editing, a small mail utility, adding commas to a number with lookaround, text-to-HTML conversion, that doubled-word thing. * Regular expression features and flavours The regex landscape, origins of REs, care and handling of REs, Integrated handling, procedural and object-oriented handling, search-and-replace example. strings character encodings and modes, strings as REs, character-encoding issues, unicode, regex modes and match modes, common metacharacters and features, character representations, character classes and class-like constructs, anchors and other 'zero-width assertions', comments and mode modifiers, grouping capturing conditionals and control. * The mechanics of expression processing Two kinds of engines, new standards, regex engine types, from the department of redundancy department, testing the engine type, match basics, about the examples, rule 1: the match that begins earliest wins, engine pieces and parts, rule 2: the standard quantifiers are greedy, regex-directed versus text-directed, NFA engine: regex-directed, DFA engine: text-directed, first thoughts: NFA and DFA in comparison, backtracking, two important points on backtracking, saved states, backtracking and greediness, more about greediness and backtracking, problems of greediness, multi-character 'quotes', lazy quantifiers, greediness and laziness, laziness and backtracking, possessive quantifiers and atomic grouping, possessive quantifiers ?, +, *+, ++ and {m,n}+, the backtracking of lookaround, is alternation greedy? taking advantage of ordered alternation, NFA DFA and posix, the longest-leftmost', posix and the longest-leftmost rule, speed and efficiency. * Practical regex techniques Continuation lines, matching an IP address, working with filenames, matching balanced sets of parentheses, watching out for unwanted matches, matching delimited text, knowing your data and making assumptions, stripping leading and trailing whitespace, matching and HTML tag, matching an HTML link, examining an HTTP URL, validating a hostname, plucking a hostname, plucking a URL, parsing CSV files. * Crafting an efficient expression Efficiency vs. correctness, localizing greediness, global view of backtracking, more work for POSIX NFA, work required during a non-match, being more specific, alternation can be expensive, benchmarking, know what you re measuring, benchmarking with Python, common optimisations, the mechanics of regex application, pre-application optimizations, optimizations with the transmission, optimization of the regex itself, techniques for faster expressions, common sense techniques, expose literal text, expose anchors, lazy versus greedy: be specific, split into multiple REs, mimic initial-character discrimination, use atomic grouping and possessive quantifiers, lead the engine to a match, unrolling the loop, observations, using atomic grouping and possessive quantifiers, short unrolling examples, unrolling C comments, the free flowing regex, a helping hand to guide the match, a well-guided regex is a fast regex.

ORACLE SQL TRAINING COURSE DESCRIPTION The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create SQL statements to query database tables. * Use standard aggregate functions and related SELECT statement clauses. * Join Tables. * Use basic subqueries and the set operators. * Use numeric, character and date functions. * Use conversion and other miscellaneous functions. * Use SQL parameters. * Use complex subqueries. * Create and alter tables and views. * Insert, update and delete rows in database tables. * Manage sequences and synonyms. ORACLE SQL TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. * Prerequisites: None. * Duration 3 days ORACLE SQL TRAINING COURSE CONTENTS * Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. * Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. * Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. * Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. * Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. * Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. * SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. * Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. * Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. * Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. * Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. * Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Game design training face to face training customised and bespoke.

MYSQL FOUNDATION TRAINING COURSE DESCRIPTION The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create, alter and drop a MySQL database. * Write SQL statements. * Use SQL expressions and functions. * Create and alter tables, indexes and views. * Use transactions. * Grant and revoke access privileges. * Export and import data. MYSQL FOUNDATION TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to access and work with a MySQL Database. * Prerequisites: An understanding of databases and exposure to information technology in general would be useful. * Duration 3 days MYSQL FOUNDATION TRAINING COURSE CONTENTS * Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. * Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. * Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. * LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. * Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. * Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. * Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. * Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. * Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. * Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. * Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. * Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.